Query Metrics
21
Database Queries
7
Different statements
14.65 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 2.33 ms |
SELECT s0_.id AS id_0, s0_.store_id AS store_id_1, s0_.title AS title_2, s0_.logo_url AS logo_url_3, s0_.api_user AS api_user_4, s0_.api_key AS api_key_5, s0_.store_url AS store_url_6, s0_.store_info AS store_info_7, s0_.warehouse_address AS warehouse_address_8, s0_.contact_phone AS contact_phone_9, s0_.created_at AS created_at_10, s0_.unit AS unit_11 FROM store_setting s0_ WHERE s0_.store_url = ?
Parameters:
[
"bodynetworx.myshopify.com"
]
|
2 | 0.98 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.shopify_id AS shopify_id_3, t0.code AS code_4, t0.tax AS tax_5 FROM country t0 WHERE t0.code = ?
Parameters:
[
"US"
]
|
3 | 0.88 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.shopify_id AS shopify_id_3, t0.code AS code_4, t0.tax AS tax_5 FROM country t0 WHERE t0.code = ?
Parameters:
[
"US"
]
|
4 | 1.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.shopify_id AS shopify_id_3, t0.shopify_country_id AS shopify_country_id_4, t0.code AS code_5, t0.country_id AS country_id_6 FROM province t0 WHERE t0.code = ?
Parameters:
[
"NY"
]
|
5 | 1.00 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.shopify_id AS shopify_id_3, t0.shopify_country_id AS shopify_country_id_4, t0.code AS code_5, t0.country_id AS country_id_6 FROM province t0 WHERE t0.code = ?
Parameters:
[
"CA"
]
|
6 | 2.01 ms |
SELECT t0.id AS id_1, t0.origin_postal_code AS origin_postal_code_2, t0.destination_postal_code AS destination_postal_code_3, t0.price AS price_4, t0.pallete_id AS pallete_id_5, t0.origin_country_id AS origin_country_id_6, t0.destination_country_id AS destination_country_id_7, t0.origin_province_id AS origin_province_id_8, t0.destination_province_id AS destination_province_id_9, t0.store_id AS store_id_10 FROM freight_price t0 WHERE t0.destination_country_id IN (?) AND t0.destination_province_id IN (?) AND t0.origin_country_id IN (?)
Parameters:
[ [ 39 ] [ 19 123 264 ] [ 39 ] ] |
7 | 1.61 ms |
SELECT t0.id AS id_1, t0.origin_postal_code AS origin_postal_code_2, t0.destination_postal_code AS destination_postal_code_3, t0.price AS price_4, t0.pallete_id AS pallete_id_5, t0.origin_country_id AS origin_country_id_6, t0.destination_country_id AS destination_country_id_7, t0.origin_province_id AS origin_province_id_8, t0.destination_province_id AS destination_province_id_9, t0.store_id AS store_id_10 FROM freight_price t0 WHERE t0.origin_country_id IN (?) AND t0.destination_country_id IN (?) AND t0.origin_province_id IN (?) AND t0.destination_province_id IN (?)
Parameters:
[ [ 39 ] [ 39 ] [ 295 ] [ 19 123 264 ] ] |
8 | 1.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.width AS width_4, t0.length AS length_5, t0.height AS height_6, t0.deleted_at AS deleted_at_7, t0.weight AS weight_8, t0.price AS price_9, t0.store_id AS store_id_10 FROM pallet t0 WHERE t0.id = ?
Parameters:
[
36
]
|
9 | 0.50 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.width AS width_4, t0.length AS length_5, t0.height AS height_6, t0.deleted_at AS deleted_at_7, t0.weight AS weight_8, t0.price AS price_9, t0.store_id AS store_id_10 FROM pallet t0 WHERE t0.id = ?
Parameters:
[
35
]
|
10 | 0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.width AS width_4, t0.length AS length_5, t0.height AS height_6, t0.deleted_at AS deleted_at_7, t0.weight AS weight_8, t0.price AS price_9, t0.store_id AS store_id_10 FROM pallet t0 WHERE t0.id = ?
Parameters:
[
38
]
|
11 | 0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.width AS width_4, t0.length AS length_5, t0.height AS height_6, t0.deleted_at AS deleted_at_7, t0.weight AS weight_8, t0.price AS price_9, t0.store_id AS store_id_10 FROM pallet t0 WHERE t0.id = ?
Parameters:
[
37
]
|
12 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.width AS width_4, t0.length AS length_5, t0.height AS height_6, t0.deleted_at AS deleted_at_7, t0.weight AS weight_8, t0.price AS price_9, t0.store_id AS store_id_10 FROM pallet t0 WHERE t0.id = ?
Parameters:
[
39
]
|
13 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.width AS width_4, t0.length AS length_5, t0.height AS height_6, t0.deleted_at AS deleted_at_7, t0.weight AS weight_8, t0.price AS price_9, t0.store_id AS store_id_10 FROM pallet t0 WHERE t0.id = ?
Parameters:
[
40
]
|
14 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.width AS width_4, t0.length AS length_5, t0.height AS height_6, t0.deleted_at AS deleted_at_7, t0.weight AS weight_8, t0.price AS price_9, t0.store_id AS store_id_10 FROM pallet t0 WHERE t0.id = ?
Parameters:
[
41
]
|
15 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.width AS width_4, t0.length AS length_5, t0.height AS height_6, t0.deleted_at AS deleted_at_7, t0.weight AS weight_8, t0.price AS price_9, t0.store_id AS store_id_10 FROM pallet t0 WHERE t0.id = ?
Parameters:
[
42
]
|
16 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.width AS width_4, t0.length AS length_5, t0.height AS height_6, t0.deleted_at AS deleted_at_7, t0.weight AS weight_8, t0.price AS price_9, t0.store_id AS store_id_10 FROM pallet t0 WHERE t0.id = ?
Parameters:
[
43
]
|
17 | 0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.width AS width_4, t0.length AS length_5, t0.height AS height_6, t0.deleted_at AS deleted_at_7, t0.weight AS weight_8, t0.price AS price_9, t0.store_id AS store_id_10 FROM pallet t0 WHERE t0.id = ?
Parameters:
[
44
]
|
18 | 0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.width AS width_4, t0.length AS length_5, t0.height AS height_6, t0.deleted_at AS deleted_at_7, t0.weight AS weight_8, t0.price AS price_9, t0.store_id AS store_id_10 FROM pallet t0 WHERE t0.id = ?
Parameters:
[
45
]
|
19 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.width AS width_4, t0.length AS length_5, t0.height AS height_6, t0.deleted_at AS deleted_at_7, t0.weight AS weight_8, t0.price AS price_9, t0.store_id AS store_id_10 FROM pallet t0 WHERE t0.id = ?
Parameters:
[
46
]
|
20 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.width AS width_4, t0.length AS length_5, t0.height AS height_6, t0.deleted_at AS deleted_at_7, t0.weight AS weight_8, t0.price AS price_9, t0.store_id AS store_id_10 FROM pallet t0 WHERE t0.id = ?
Parameters:
[
47
]
|
21 | 0.64 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_id AS product_id_3, t0.sku AS sku_4, t0.width AS width_5, t0.length AS length_6, t0.height AS height_7, t0.weight AS weight_8, t0.product_order AS product_order_9, t0.deleted_at AS deleted_at_10, t0.variant_id AS variant_id_11, t0.keep_flat AS keep_flat_12, t0.position AS position_13, t0.is_single_palette AS is_single_palette_14, t0.store_id AS store_id_15 FROM product t0 WHERE t0.product_id IS NULL AND t0.variant_id IS NULL LIMIT 1
Parameters:
[] |
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\Pallet | No errors. |
App\Entity\Product | No errors. |
App\Entity\FreightPrice | No errors. |
App\Entity\Country | No errors. |
App\Entity\Province | No errors. |
App\Entity\Store | No errors. |