Query Metrics
21
Database Queries
7
Different statements
14.65 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
4.00 ms (27.30%) |
13 |
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
]
|
2.33 ms (15.89%) |
1 |
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.21 ms (15.09%) |
2 |
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"
]
|
2.01 ms (13.70%) |
1 |
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 ] ] |
1.86 ms (12.71%) |
2 |
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"
]
|
1.61 ms (10.97%) |
1 |
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 ] ] |
0.64 ms (4.35%) |
1 |
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. |
App\Entity\SubProduct | No errors. |