GET https://dev.hebu-music.com/en/shipping

Query Metrics

92 Database Queries
11 Different statements
13.71 ms Query time
0 Invalid entities
212 Managed entities

Queries

Group similar statements

# Time Info
1 0.66 ms
SELECT t0.nr AS nr_1, t0.name AS name_2, t0.mail AS mail_3, t0.vat_id AS vat_id_4, t0.background AS background_5, t0.logo AS logo_6, t0.template AS template_7, t0.url AS url_8, t0.bank_bic AS bank_bic_9, t0.bank_iban AS bank_iban_10, t0.api_username AS api_username_11, t0.api_key AS api_key_12, t0.web_key AS web_key_13, t0.is_active AS is_active_14, t0.is_master AS is_master_15, t0.id AS id_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.address_id AS address_id_19, t0.currency AS currency_20, t0.parent_id AS parent_id_21 FROM shops t0 WHERE t0.web_key = ? LIMIT 1
Parameters:
[
  "dev.hebu-music.com"
]
2 0.28 ms
SELECT t0.nr AS nr_1, t0.name AS name_2, t0.mail AS mail_3, t0.vat_id AS vat_id_4, t0.background AS background_5, t0.logo AS logo_6, t0.template AS template_7, t0.url AS url_8, t0.bank_bic AS bank_bic_9, t0.bank_iban AS bank_iban_10, t0.api_username AS api_username_11, t0.api_key AS api_key_12, t0.web_key AS web_key_13, t0.is_active AS is_active_14, t0.is_master AS is_master_15, t0.id AS id_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.address_id AS address_id_19, t0.currency AS currency_20, t0.parent_id AS parent_id_21 FROM shops t0 WHERE t0.is_master = ? LIMIT 1
Parameters:
[
  1
]
3 0.41 ms
SELECT t0.nr AS nr_1, t0.name AS name_2, t0.mail AS mail_3, t0.vat_id AS vat_id_4, t0.background AS background_5, t0.logo AS logo_6, t0.template AS template_7, t0.url AS url_8, t0.bank_bic AS bank_bic_9, t0.bank_iban AS bank_iban_10, t0.api_username AS api_username_11, t0.api_key AS api_key_12, t0.web_key AS web_key_13, t0.is_active AS is_active_14, t0.is_master AS is_master_15, t0.id AS id_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.address_id AS address_id_19, t0.currency AS currency_20, t0.parent_id AS parent_id_21 FROM shops t0 WHERE t0.parent_id = ?
Parameters:
[
  10
]
4 0.14 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.rate AS rate_3, t0.sign AS sign_4, t0.is_active AS is_active_5, t0.is_default AS is_default_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.rate_at AS rate_at_9 FROM currencies t0 WHERE t0.code = ?
Parameters:
[
  "EUR"
]
5 0.17 ms
SELECT c0_.code AS code_0, c0_.title AS title_1, c0_.locale AS locale_2, c0_.city_format AS city_format_3, c0_.is_default AS is_default_4, c0_.rid AS rid_5, c0_.state AS state_6, c0_.sync AS sync_7, c0_.state_at AS state_at_8, c0_.id AS id_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.currency AS currency_12 FROM countries c0_ WHERE c0_.is_default = 1 ORDER BY c0_.id ASC LIMIT 1
Parameters:
[]
6 0.14 ms
SELECT c0_.code AS code_0, c0_.title AS title_1, c0_.locale AS locale_2, c0_.city_format AS city_format_3, c0_.is_default AS is_default_4, c0_.rid AS rid_5, c0_.state AS state_6, c0_.sync AS sync_7, c0_.state_at AS state_at_8, c0_.id AS id_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.currency AS currency_12 FROM countries c0_ WHERE c0_.is_default = 1 ORDER BY c0_.id ASC LIMIT 1
Parameters:
[]
7 0.22 ms
SELECT c0_.code AS code_0, c0_.title AS title_1, c0_.locale AS locale_2, c0_.city_format AS city_format_3, c0_.is_default AS is_default_4, c0_.rid AS rid_5, c0_.state AS state_6, c0_.sync AS sync_7, c0_.state_at AS state_at_8, c0_.id AS id_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11, c0_.currency AS currency_12 FROM countries c0_ WHERE c0_.is_default = 1 ORDER BY c0_.id ASC LIMIT 1
Parameters:
[]
8 0.30 ms
SELECT s0_.zone AS zone_0, s0_.value AS value_1, s0_.price_min AS price_min_2, s0_.price_max AS price_max_3, s0_.weight_min AS weight_min_4, s0_.weight_max AS weight_max_5, s0_.rid AS rid_6, s0_.state AS state_7, s0_.sync AS sync_8, s0_.state_at AS state_at_9, s0_.id AS id_10, s0_.created_at AS created_at_11, s0_.updated_at AS updated_at_12, s0_.country_id AS country_id_13, s0_.ref_country_id AS ref_country_id_14 FROM shipping s0_ ORDER BY s0_.zone ASC, s0_.price_max ASC, s0_.weight_max ASC, s0_.id ASC
Parameters:
[]
9 0.39 ms
SELECT t0.name AS name_1, t0.value AS value_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM options t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "shipping_free_standard_DE"
]
10 0.26 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  15
]
11 0.19 ms
SELECT t0.name AS name_1, t0.value AS value_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM options t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "shipping_free_standard_AT"
]
12 0.18 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  22
]
13 0.20 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  59
]
14 0.14 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  126
]
15 0.17 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  152
]
16 0.14 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  75
]
17 0.14 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  172
]
18 0.13 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  58
]
19 0.14 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  107
]
20 0.18 ms
SELECT t0.name AS name_1, t0.value AS value_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM options t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "shipping_free_standard_IT"
]
21 0.14 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  224
]
22 0.15 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  205
]
23 0.12 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  197
]
24 0.12 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  191
]
25 0.14 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  192
]
26 0.13 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  99
]
27 0.14 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  74
]
28 0.13 ms
SELECT t0.name AS name_1, t0.value AS value_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM options t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "shipping_free_standard_FI"
]
29 0.12 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  162
]
30 0.14 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  100
]
31 0.12 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  173
]
32 0.12 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  105
]
33 0.12 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  134
]
34 0.14 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  119
]
35 0.14 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  34
]
36 0.13 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  69
]
37 0.12 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  125
]
38 0.12 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  177
]
39 0.13 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  85
]
40 0.12 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  55
]
41 0.14 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  206
]
42 0.13 ms
SELECT t0.name AS name_1, t0.value AS value_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM options t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "shipping_free_standard_CH"
]
43 0.21 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  124
]
44 0.15 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  45
]
45 0.11 ms
SELECT t0.name AS name_1, t0.value AS value_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM options t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "shipping_free_standard_CN"
]
46 0.10 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  103
]
47 0.12 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  190
]
48 0.10 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  208
]
49 0.10 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  127
]
50 0.10 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  109
]
51 0.11 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  131
]
52 0.10 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  98
]
53 0.11 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  211
]
54 0.11 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  115
]
55 0.11 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  140
]
56 0.10 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  39
]
57 0.16 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  144
]
58 0.12 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  72
]
59 0.14 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  31
]
60 0.11 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  1
]
61 0.11 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  174
]
62 0.10 ms
SELECT t0.name AS name_1, t0.value AS value_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM options t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "shipping_free_standard_PR"
]
63 0.11 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  106
]
64 0.12 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  14
]
65 0.10 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  48
]
66 0.10 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.locale AS locale_3, t0.city_format AS city_format_4, t0.is_default AS is_default_5, t0.rid AS rid_6, t0.state AS state_7, t0.sync AS sync_8, t0.state_at AS state_at_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.currency AS currency_13 FROM countries t0 WHERE t0.id = ?
Parameters:
[
  11
]
67 0.14 ms
SELECT c0_.count AS count_0, c0_.position AS position_1, c0_.is_active AS is_active_2, c0_.is_visible AS is_visible_3, c0_.id AS id_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.shop_id AS shop_id_7, c0_.genre_id AS genre_id_8, c0_.parent_id AS parent_id_9 FROM categories c0_ WHERE c0_.shop_id = ? AND c0_.is_visible = 1 ORDER BY c0_.position ASC
Parameters:
[
  1
]
68 0.16 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.google_key AS google_key_3, t0.rid AS rid_4, t0.state AS state_5, t0.sync AS sync_6, t0.state_at AS state_at_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.description AS description_11, t0.indexable AS indexable_12, t0.parent_id AS parent_id_13 FROM genres t0 WHERE t0.id = ?
Parameters:
[
  1
]
69 0.15 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.google_key AS google_key_3, t0.rid AS rid_4, t0.state AS state_5, t0.sync AS sync_6, t0.state_at AS state_at_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.description AS description_11, t0.indexable AS indexable_12, t0.parent_id AS parent_id_13 FROM genres t0 WHERE t0.id = ?
Parameters:
[
  1201
]
70 0.13 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.google_key AS google_key_3, t0.rid AS rid_4, t0.state AS state_5, t0.sync AS sync_6, t0.state_at AS state_at_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.description AS description_11, t0.indexable AS indexable_12, t0.parent_id AS parent_id_13 FROM genres t0 WHERE t0.id = ?
Parameters:
[
  1182
]
71 0.11 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.google_key AS google_key_3, t0.rid AS rid_4, t0.state AS state_5, t0.sync AS sync_6, t0.state_at AS state_at_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.description AS description_11, t0.indexable AS indexable_12, t0.parent_id AS parent_id_13 FROM genres t0 WHERE t0.id = ?
Parameters:
[
  6
]
72 0.12 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.google_key AS google_key_3, t0.rid AS rid_4, t0.state AS state_5, t0.sync AS sync_6, t0.state_at AS state_at_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.description AS description_11, t0.indexable AS indexable_12, t0.parent_id AS parent_id_13 FROM genres t0 WHERE t0.id = ?
Parameters:
[
  1153
]
73 0.12 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.google_key AS google_key_3, t0.rid AS rid_4, t0.state AS state_5, t0.sync AS sync_6, t0.state_at AS state_at_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.description AS description_11, t0.indexable AS indexable_12, t0.parent_id AS parent_id_13 FROM genres t0 WHERE t0.id = ?
Parameters:
[
  2
]
74 0.19 ms
SELECT t0.type AS type_1, t0.value AS value_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.shop_id AS shop_id_6 FROM shop_data t0 WHERE (t0.type = ? AND t0.shop_id = ?) ORDER BY t0.type ASC LIMIT 1
Parameters:
[
  "rid.catalog"
  1
]
75 0.13 ms
SELECT c0_.count AS count_0, c0_.position AS position_1, c0_.is_active AS is_active_2, c0_.is_visible AS is_visible_3, c0_.id AS id_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.shop_id AS shop_id_7, c0_.genre_id AS genre_id_8, c0_.parent_id AS parent_id_9 FROM categories c0_ WHERE c0_.shop_id = ? AND c0_.is_visible = 1 ORDER BY c0_.position ASC
Parameters:
[
  2
]
76 0.13 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.google_key AS google_key_3, t0.rid AS rid_4, t0.state AS state_5, t0.sync AS sync_6, t0.state_at AS state_at_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.description AS description_11, t0.indexable AS indexable_12, t0.parent_id AS parent_id_13 FROM genres t0 WHERE t0.id = ?
Parameters:
[
  746
]
77 0.13 ms
SELECT t0.type AS type_1, t0.value AS value_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.shop_id AS shop_id_6 FROM shop_data t0 WHERE (t0.type = ? AND t0.shop_id = ?) ORDER BY t0.type ASC LIMIT 1
Parameters:
[
  "rid.catalog"
  2
]
78 0.14 ms
SELECT c0_.count AS count_0, c0_.position AS position_1, c0_.is_active AS is_active_2, c0_.is_visible AS is_visible_3, c0_.id AS id_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.shop_id AS shop_id_7, c0_.genre_id AS genre_id_8, c0_.parent_id AS parent_id_9 FROM categories c0_ WHERE c0_.shop_id = ? AND c0_.is_visible = 1 ORDER BY c0_.position ASC
Parameters:
[
  3
]
79 0.14 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.google_key AS google_key_3, t0.rid AS rid_4, t0.state AS state_5, t0.sync AS sync_6, t0.state_at AS state_at_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.description AS description_11, t0.indexable AS indexable_12, t0.parent_id AS parent_id_13 FROM genres t0 WHERE t0.id = ?
Parameters:
[
  651
]
80 0.11 ms
SELECT t0.type AS type_1, t0.value AS value_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.shop_id AS shop_id_6 FROM shop_data t0 WHERE (t0.type = ? AND t0.shop_id = ?) ORDER BY t0.type ASC LIMIT 1
Parameters:
[
  "rid.catalog"
  3
]
81 0.10 ms
SELECT t0.type AS type_1, t0.value AS value_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.shop_id AS shop_id_6 FROM shop_data t0 WHERE (t0.type = ? AND t0.shop_id = ?) ORDER BY t0.type ASC LIMIT 1
Parameters:
[
  "rid.catalog"
  10
]
82 0.11 ms
SELECT c0_.count AS count_0, c0_.position AS position_1, c0_.is_active AS is_active_2, c0_.is_visible AS is_visible_3, c0_.id AS id_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.shop_id AS shop_id_7, c0_.genre_id AS genre_id_8, c0_.parent_id AS parent_id_9 FROM categories c0_ WHERE c0_.shop_id = ? AND c0_.is_visible = 1 ORDER BY c0_.position ASC
Parameters:
[
  4
]
83 0.17 ms
SELECT t0.type AS type_1, t0.value AS value_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.shop_id AS shop_id_6 FROM shop_data t0 WHERE (t0.type = ? AND t0.shop_id = ?) ORDER BY t0.type ASC LIMIT 1
Parameters:
[
  "rid.catalog"
  4
]
84 0.11 ms
SELECT t0.type AS type_1, t0.value AS value_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.shop_id AS shop_id_6 FROM shop_data t0 WHERE (t0.type = ? AND t0.shop_id = ?) ORDER BY t0.type ASC LIMIT 1
Parameters:
[
  "rid.catalog"
  10
]
85 0.14 ms
SELECT c0_.count AS count_0, c0_.position AS position_1, c0_.is_active AS is_active_2, c0_.is_visible AS is_visible_3, c0_.id AS id_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.shop_id AS shop_id_7, c0_.genre_id AS genre_id_8, c0_.parent_id AS parent_id_9 FROM categories c0_ WHERE c0_.shop_id = ? AND c0_.is_visible = 1 ORDER BY c0_.position ASC
Parameters:
[
  5
]
86 0.12 ms
SELECT t0.code AS code_1, t0.title AS title_2, t0.google_key AS google_key_3, t0.rid AS rid_4, t0.state AS state_5, t0.sync AS sync_6, t0.state_at AS state_at_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.description AS description_11, t0.indexable AS indexable_12, t0.parent_id AS parent_id_13 FROM genres t0 WHERE t0.id = ?
Parameters:
[
  646
]
87 0.10 ms
SELECT t0.type AS type_1, t0.value AS value_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.shop_id AS shop_id_6 FROM shop_data t0 WHERE (t0.type = ? AND t0.shop_id = ?) ORDER BY t0.type ASC LIMIT 1
Parameters:
[
  "rid.catalog"
  5
]
88 0.11 ms
SELECT t0.type AS type_1, t0.value AS value_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.shop_id AS shop_id_6 FROM shop_data t0 WHERE (t0.type = ? AND t0.shop_id = ?) ORDER BY t0.type ASC LIMIT 1
Parameters:
[
  "rid.catalog"
  10
]
89 0.20 ms
SELECT t0.type AS type_1, t0.value AS value_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.shop_id AS shop_id_6 FROM shop_data t0 WHERE (t0.type = ? AND t0.shop_id = ?) ORDER BY t0.type ASC LIMIT 1
Parameters:
[
  "text.home"
  1
]
90 0.14 ms
SELECT t0.type AS type_1, t0.value AS value_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.shop_id AS shop_id_6 FROM shop_data t0 WHERE (t0.type = ? AND t0.shop_id = ?) ORDER BY t0.type ASC LIMIT 1
Parameters:
[
  "text.home"
  10
]
91 0.15 ms
SELECT t0.type AS type_1, t0.value AS value_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.shop_id AS shop_id_6 FROM shop_data t0 WHERE (t0.type = ? AND t0.shop_id = ?) ORDER BY t0.type ASC LIMIT 1
Parameters:
[
  "text.home"
  1
]
92 0.11 ms
SELECT t0.type AS type_1, t0.value AS value_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.shop_id AS shop_id_6 FROM shop_data t0 WHERE (t0.type = ? AND t0.shop_id = ?) ORDER BY t0.type ASC LIMIT 1
Parameters:
[
  "text.home"
  10
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
Database\Entity\Shipping 104
Database\Entity\Country 52
Database\Entity\Category 34
Database\Entity\Genre 9
Database\Entity\Shop 6
Database\Entity\Currency 3
Database\Entity\ShopData 3
Database\Entity\Address 1