Query Metrics
47
Database Queries
7
Different statements
175.12 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.30 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:
[
"7"
]
|
| 2 | 0.26 ms |
SELECT count(DISTINCT o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.status_id <> ? AND o0_.active = ? AND o0_.shop_id = ?
Parameters:
[ 10 1 7 ] |
| 3 | 0.75 ms |
SELECT DISTINCT o0_.id AS id_0, o0_.date AS date_1 FROM `order` o0_ WHERE o0_.status_id <> ? AND o0_.active = ? AND o0_.shop_id = ? ORDER BY o0_.date DESC LIMIT 30 OFFSET 120
Parameters:
[ 10 1 7 ] |
| 4 | 10.16 ms |
SELECT o0_.id AS id_0, o0_.reference AS reference_1, o0_.coupon AS coupon_2, o0_.custom_reference AS custom_reference_3, o0_.confirm AS confirm_4, o0_.accept_terms AS accept_terms_5, o0_.total_product AS total_product_6, o0_.delivery_ht AS delivery_ht_7, o0_.delivery_total AS delivery_total_8, o0_.amount_ht AS amount_ht_9, o0_.amount_total AS amount_total_10, o0_.discount AS discount_11, o0_.vat AS vat_12, o0_.date AS date_13, o0_.b2l_id AS b2l_id_14, o0_.bak2_reference AS bak2_reference_15, o0_.shipping_number AS shipping_number_16, o0_.payment AS payment_17, o0_.payment_reference AS payment_reference_18, o0_.comment AS comment_19, o0_.option_price AS option_price_20, o0_.invoice_filename AS invoice_filename_21, o0_.active AS active_22, o0_.user_id AS user_id_23, o0_.shop_id AS shop_id_24, o0_.delivery_address_id AS delivery_address_id_25, o0_.invoice_address_id AS invoice_address_id_26, o0_.status_id AS status_id_27, o0_.temp_address_id AS temp_address_id_28 FROM `order` o0_ WHERE o0_.status_id <> ? AND o0_.active = ? AND o0_.shop_id = ? AND o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY o0_.date DESC
Parameters:
[ 10 1 7 68 67 66 65 64 63 62 61 60 59 58 57 56 55 54 53 52 51 49 48 47 ] |
| 5 | 0.48 ms |
SELECT t0.id AS id_1, t0.imei AS imei_2, t0.tracking AS tracking_3, t0.sync AS sync_4, t0.date AS date_5, t0.order_id AS order_id_6, t0.product_id AS product_id_7, t0.shop_id AS shop_id_8, t0.cart_id AS cart_id_9 FROM imei t0 WHERE t0.order_id = ?
Parameters:
[
68
]
|
| 6 | 0.22 ms |
SELECT t0.id AS id_1, t0.imei AS imei_2, t0.tracking AS tracking_3, t0.sync AS sync_4, t0.date AS date_5, t0.order_id AS order_id_6, t0.product_id AS product_id_7, t0.shop_id AS shop_id_8, t0.cart_id AS cart_id_9 FROM imei t0 WHERE t0.order_id = ?
Parameters:
[
67
]
|
| 7 | 0.22 ms |
SELECT t0.id AS id_1, t0.imei AS imei_2, t0.tracking AS tracking_3, t0.sync AS sync_4, t0.date AS date_5, t0.order_id AS order_id_6, t0.product_id AS product_id_7, t0.shop_id AS shop_id_8, t0.cart_id AS cart_id_9 FROM imei t0 WHERE t0.order_id = ?
Parameters:
[
66
]
|
| 8 | 0.22 ms |
SELECT t0.id AS id_1, t0.imei AS imei_2, t0.tracking AS tracking_3, t0.sync AS sync_4, t0.date AS date_5, t0.order_id AS order_id_6, t0.product_id AS product_id_7, t0.shop_id AS shop_id_8, t0.cart_id AS cart_id_9 FROM imei t0 WHERE t0.order_id = ?
Parameters:
[
65
]
|
| 9 | 0.22 ms |
SELECT t0.id AS id_1, t0.imei AS imei_2, t0.tracking AS tracking_3, t0.sync AS sync_4, t0.date AS date_5, t0.order_id AS order_id_6, t0.product_id AS product_id_7, t0.shop_id AS shop_id_8, t0.cart_id AS cart_id_9 FROM imei t0 WHERE t0.order_id = ?
Parameters:
[
64
]
|
| 10 | 0.22 ms |
SELECT t0.id AS id_1, t0.imei AS imei_2, t0.tracking AS tracking_3, t0.sync AS sync_4, t0.date AS date_5, t0.order_id AS order_id_6, t0.product_id AS product_id_7, t0.shop_id AS shop_id_8, t0.cart_id AS cart_id_9 FROM imei t0 WHERE t0.order_id = ?
Parameters:
[
63
]
|
| 11 | 5.06 ms |
SELECT t0.id AS id_1, t0.imei AS imei_2, t0.tracking AS tracking_3, t0.sync AS sync_4, t0.date AS date_5, t0.order_id AS order_id_6, t0.product_id AS product_id_7, t0.shop_id AS shop_id_8, t0.cart_id AS cart_id_9 FROM imei t0 WHERE t0.order_id = ?
Parameters:
[
62
]
|
| 12 | 3.63 ms |
SELECT t0.id AS id_1, t0.imei AS imei_2, t0.tracking AS tracking_3, t0.sync AS sync_4, t0.date AS date_5, t0.order_id AS order_id_6, t0.product_id AS product_id_7, t0.shop_id AS shop_id_8, t0.cart_id AS cart_id_9 FROM imei t0 WHERE t0.order_id = ?
Parameters:
[
61
]
|
| 13 | 0.29 ms |
SELECT t0.id AS id_1, t0.imei AS imei_2, t0.tracking AS tracking_3, t0.sync AS sync_4, t0.date AS date_5, t0.order_id AS order_id_6, t0.product_id AS product_id_7, t0.shop_id AS shop_id_8, t0.cart_id AS cart_id_9 FROM imei t0 WHERE t0.order_id = ?
Parameters:
[
60
]
|
| 14 | 7.19 ms |
SELECT t0.id AS id_1, t0.imei AS imei_2, t0.tracking AS tracking_3, t0.sync AS sync_4, t0.date AS date_5, t0.order_id AS order_id_6, t0.product_id AS product_id_7, t0.shop_id AS shop_id_8, t0.cart_id AS cart_id_9 FROM imei t0 WHERE t0.order_id = ?
Parameters:
[
59
]
|
| 15 | 0.38 ms |
SELECT t0.id AS id_1, t0.imei AS imei_2, t0.tracking AS tracking_3, t0.sync AS sync_4, t0.date AS date_5, t0.order_id AS order_id_6, t0.product_id AS product_id_7, t0.shop_id AS shop_id_8, t0.cart_id AS cart_id_9 FROM imei t0 WHERE t0.order_id = ?
Parameters:
[
58
]
|
| 16 | 0.22 ms |
SELECT t0.id AS id_1, t0.imei AS imei_2, t0.tracking AS tracking_3, t0.sync AS sync_4, t0.date AS date_5, t0.order_id AS order_id_6, t0.product_id AS product_id_7, t0.shop_id AS shop_id_8, t0.cart_id AS cart_id_9 FROM imei t0 WHERE t0.order_id = ?
Parameters:
[
57
]
|
| 17 | 0.22 ms |
SELECT t0.id AS id_1, t0.imei AS imei_2, t0.tracking AS tracking_3, t0.sync AS sync_4, t0.date AS date_5, t0.order_id AS order_id_6, t0.product_id AS product_id_7, t0.shop_id AS shop_id_8, t0.cart_id AS cart_id_9 FROM imei t0 WHERE t0.order_id = ?
Parameters:
[
56
]
|
| 18 | 0.22 ms |
SELECT t0.id AS id_1, t0.imei AS imei_2, t0.tracking AS tracking_3, t0.sync AS sync_4, t0.date AS date_5, t0.order_id AS order_id_6, t0.product_id AS product_id_7, t0.shop_id AS shop_id_8, t0.cart_id AS cart_id_9 FROM imei t0 WHERE t0.order_id = ?
Parameters:
[
55
]
|
| 19 | 0.22 ms |
SELECT t0.id AS id_1, t0.imei AS imei_2, t0.tracking AS tracking_3, t0.sync AS sync_4, t0.date AS date_5, t0.order_id AS order_id_6, t0.product_id AS product_id_7, t0.shop_id AS shop_id_8, t0.cart_id AS cart_id_9 FROM imei t0 WHERE t0.order_id = ?
Parameters:
[
54
]
|
| 20 | 0.22 ms |
SELECT t0.id AS id_1, t0.imei AS imei_2, t0.tracking AS tracking_3, t0.sync AS sync_4, t0.date AS date_5, t0.order_id AS order_id_6, t0.product_id AS product_id_7, t0.shop_id AS shop_id_8, t0.cart_id AS cart_id_9 FROM imei t0 WHERE t0.order_id = ?
Parameters:
[
53
]
|
| 21 | 0.22 ms |
SELECT t0.id AS id_1, t0.imei AS imei_2, t0.tracking AS tracking_3, t0.sync AS sync_4, t0.date AS date_5, t0.order_id AS order_id_6, t0.product_id AS product_id_7, t0.shop_id AS shop_id_8, t0.cart_id AS cart_id_9 FROM imei t0 WHERE t0.order_id = ?
Parameters:
[
52
]
|
| 22 | 4.75 ms |
SELECT t0.id AS id_1, t0.imei AS imei_2, t0.tracking AS tracking_3, t0.sync AS sync_4, t0.date AS date_5, t0.order_id AS order_id_6, t0.product_id AS product_id_7, t0.shop_id AS shop_id_8, t0.cart_id AS cart_id_9 FROM imei t0 WHERE t0.order_id = ?
Parameters:
[
51
]
|
| 23 | 19.80 ms |
SELECT t0.id AS id_1, t0.imei AS imei_2, t0.tracking AS tracking_3, t0.sync AS sync_4, t0.date AS date_5, t0.order_id AS order_id_6, t0.product_id AS product_id_7, t0.shop_id AS shop_id_8, t0.cart_id AS cart_id_9 FROM imei t0 WHERE t0.order_id = ?
Parameters:
[
49
]
|
| 24 | 0.43 ms |
SELECT t0.id AS id_1, t0.imei AS imei_2, t0.tracking AS tracking_3, t0.sync AS sync_4, t0.date AS date_5, t0.order_id AS order_id_6, t0.product_id AS product_id_7, t0.shop_id AS shop_id_8, t0.cart_id AS cart_id_9 FROM imei t0 WHERE t0.order_id = ?
Parameters:
[
48
]
|
| 25 | 0.22 ms |
SELECT t0.id AS id_1, t0.imei AS imei_2, t0.tracking AS tracking_3, t0.sync AS sync_4, t0.date AS date_5, t0.order_id AS order_id_6, t0.product_id AS product_id_7, t0.shop_id AS shop_id_8, t0.cart_id AS cart_id_9 FROM imei t0 WHERE t0.order_id = ?
Parameters:
[
47
]
|
| 26 | 0.52 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.qty AS qty_3, t0.price AS price_4, t0.sku AS sku_5, t0.option_price AS option_price_6, t0.attribute_price AS attribute_price_7, t0.order_id AS order_id_8, t0.stock_id AS stock_id_9 FROM cart t0 WHERE t0.order_id = ?
Parameters:
[
68
]
|
| 27 | 21.57 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.b2l_id AS b2l_id_3, t0.color AS color_4, t0.type AS type_5 FROM status t0 WHERE t0.id = ?
Parameters:
[
11
]
|
| 28 | 0.45 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.qty AS qty_3, t0.price AS price_4, t0.sku AS sku_5, t0.option_price AS option_price_6, t0.attribute_price AS attribute_price_7, t0.order_id AS order_id_8, t0.stock_id AS stock_id_9 FROM cart t0 WHERE t0.order_id = ?
Parameters:
[
67
]
|
| 29 | 0.25 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.qty AS qty_3, t0.price AS price_4, t0.sku AS sku_5, t0.option_price AS option_price_6, t0.attribute_price AS attribute_price_7, t0.order_id AS order_id_8, t0.stock_id AS stock_id_9 FROM cart t0 WHERE t0.order_id = ?
Parameters:
[
66
]
|
| 30 | 0.25 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.qty AS qty_3, t0.price AS price_4, t0.sku AS sku_5, t0.option_price AS option_price_6, t0.attribute_price AS attribute_price_7, t0.order_id AS order_id_8, t0.stock_id AS stock_id_9 FROM cart t0 WHERE t0.order_id = ?
Parameters:
[
65
]
|
| 31 | 0.25 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.qty AS qty_3, t0.price AS price_4, t0.sku AS sku_5, t0.option_price AS option_price_6, t0.attribute_price AS attribute_price_7, t0.order_id AS order_id_8, t0.stock_id AS stock_id_9 FROM cart t0 WHERE t0.order_id = ?
Parameters:
[
64
]
|
| 32 | 27.84 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.qty AS qty_3, t0.price AS price_4, t0.sku AS sku_5, t0.option_price AS option_price_6, t0.attribute_price AS attribute_price_7, t0.order_id AS order_id_8, t0.stock_id AS stock_id_9 FROM cart t0 WHERE t0.order_id = ?
Parameters:
[
63
]
|
| 33 | 0.51 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.qty AS qty_3, t0.price AS price_4, t0.sku AS sku_5, t0.option_price AS option_price_6, t0.attribute_price AS attribute_price_7, t0.order_id AS order_id_8, t0.stock_id AS stock_id_9 FROM cart t0 WHERE t0.order_id = ?
Parameters:
[
62
]
|
| 34 | 0.28 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.qty AS qty_3, t0.price AS price_4, t0.sku AS sku_5, t0.option_price AS option_price_6, t0.attribute_price AS attribute_price_7, t0.order_id AS order_id_8, t0.stock_id AS stock_id_9 FROM cart t0 WHERE t0.order_id = ?
Parameters:
[
61
]
|
| 35 | 0.25 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.qty AS qty_3, t0.price AS price_4, t0.sku AS sku_5, t0.option_price AS option_price_6, t0.attribute_price AS attribute_price_7, t0.order_id AS order_id_8, t0.stock_id AS stock_id_9 FROM cart t0 WHERE t0.order_id = ?
Parameters:
[
60
]
|
| 36 | 0.29 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.qty AS qty_3, t0.price AS price_4, t0.sku AS sku_5, t0.option_price AS option_price_6, t0.attribute_price AS attribute_price_7, t0.order_id AS order_id_8, t0.stock_id AS stock_id_9 FROM cart t0 WHERE t0.order_id = ?
Parameters:
[
59
]
|
| 37 | 0.27 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.qty AS qty_3, t0.price AS price_4, t0.sku AS sku_5, t0.option_price AS option_price_6, t0.attribute_price AS attribute_price_7, t0.order_id AS order_id_8, t0.stock_id AS stock_id_9 FROM cart t0 WHERE t0.order_id = ?
Parameters:
[
58
]
|
| 38 | 14.78 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.qty AS qty_3, t0.price AS price_4, t0.sku AS sku_5, t0.option_price AS option_price_6, t0.attribute_price AS attribute_price_7, t0.order_id AS order_id_8, t0.stock_id AS stock_id_9 FROM cart t0 WHERE t0.order_id = ?
Parameters:
[
57
]
|
| 39 | 0.46 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.qty AS qty_3, t0.price AS price_4, t0.sku AS sku_5, t0.option_price AS option_price_6, t0.attribute_price AS attribute_price_7, t0.order_id AS order_id_8, t0.stock_id AS stock_id_9 FROM cart t0 WHERE t0.order_id = ?
Parameters:
[
56
]
|
| 40 | 6.04 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.qty AS qty_3, t0.price AS price_4, t0.sku AS sku_5, t0.option_price AS option_price_6, t0.attribute_price AS attribute_price_7, t0.order_id AS order_id_8, t0.stock_id AS stock_id_9 FROM cart t0 WHERE t0.order_id = ?
Parameters:
[
55
]
|
| 41 | 0.46 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.qty AS qty_3, t0.price AS price_4, t0.sku AS sku_5, t0.option_price AS option_price_6, t0.attribute_price AS attribute_price_7, t0.order_id AS order_id_8, t0.stock_id AS stock_id_9 FROM cart t0 WHERE t0.order_id = ?
Parameters:
[
54
]
|
| 42 | 0.27 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.qty AS qty_3, t0.price AS price_4, t0.sku AS sku_5, t0.option_price AS option_price_6, t0.attribute_price AS attribute_price_7, t0.order_id AS order_id_8, t0.stock_id AS stock_id_9 FROM cart t0 WHERE t0.order_id = ?
Parameters:
[
53
]
|
| 43 | 5.24 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.qty AS qty_3, t0.price AS price_4, t0.sku AS sku_5, t0.option_price AS option_price_6, t0.attribute_price AS attribute_price_7, t0.order_id AS order_id_8, t0.stock_id AS stock_id_9 FROM cart t0 WHERE t0.order_id = ?
Parameters:
[
52
]
|
| 44 | 9.99 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.qty AS qty_3, t0.price AS price_4, t0.sku AS sku_5, t0.option_price AS option_price_6, t0.attribute_price AS attribute_price_7, t0.order_id AS order_id_8, t0.stock_id AS stock_id_9 FROM cart t0 WHERE t0.order_id = ?
Parameters:
[
51
]
|
| 45 | 28.36 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.qty AS qty_3, t0.price AS price_4, t0.sku AS sku_5, t0.option_price AS option_price_6, t0.attribute_price AS attribute_price_7, t0.order_id AS order_id_8, t0.stock_id AS stock_id_9 FROM cart t0 WHERE t0.order_id = ?
Parameters:
[
49
]
|
| 46 | 0.43 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.qty AS qty_3, t0.price AS price_4, t0.sku AS sku_5, t0.option_price AS option_price_6, t0.attribute_price AS attribute_price_7, t0.order_id AS order_id_8, t0.stock_id AS stock_id_9 FROM cart t0 WHERE t0.order_id = ?
Parameters:
[
48
]
|
| 47 | 0.26 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.qty AS qty_3, t0.price AS price_4, t0.sku AS sku_5, t0.option_price AS option_price_6, t0.attribute_price AS attribute_price_7, t0.order_id AS order_id_8, t0.stock_id AS stock_id_9 FROM cart t0 WHERE t0.order_id = ?
Parameters:
[
47
]
|
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\Address | No errors. |
| App\Entity\Cart | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Sav | No errors. |
| App\Entity\Attribute | No errors. |