http://parcelapp.rakitaapps.com/hook/calculate

Query Metrics

21 Database Queries
7 Different statements
14.65 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.