Query Metrics
9
Database Queries
7
Different statements
2.64 ms
Query time
0
Invalid entities
1295
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.49 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.15 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.23 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.15 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.18 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.12 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.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:
[] |
| 8 | 0.95 ms |
SELECT t0.title AS title_1, t0.article_nr AS article_nr_2, t0.publisher_nr AS publisher_nr_3, t0.gtin AS gtin_4, t0.rank AS rank_5, t0.duration AS duration_6, t0.difficulty AS difficulty_7, t0.difficulty_detail AS difficulty_detail_8, t0.trial_voice AS trial_voice_9, t0.sequence AS sequence_10, t0.pages AS pages_11, t0.weight AS weight_12, t0.quantity AS quantity_13, t0.delivery_time AS delivery_time_14, t0.external_nr AS external_nr_15, t0.options AS options_16, t0.indexable AS indexable_17, t0.is_catalog AS is_catalog_18, t0.is_new AS is_new_19, t0.is_slider AS is_slider_20, t0.is_saleable AS is_saleable_21, t0.is_visible AS is_visible_22, t0.rid AS rid_23, t0.state AS state_24, t0.sync AS sync_25, t0.state_at AS state_at_26, t0.id AS id_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.arranger_id AS arranger_id_30, t0.group_id AS group_id_31, t0.composer_id AS composer_id_32, t0.country_id AS country_id_33, t0.publisher_id AS publisher_id_34, t0.shop_id AS shop_id_35 FROM articles t0 WHERE t0.id = ?
Parameters:
[
884681
]
|
| 9 | 0.23 ms |
SELECT c0_.title AS title_0, c0_.article_count AS article_count_1, c0_.position AS position_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_.parent_id AS parent_id_8, c0_.genre_id AS genre_id_9 FROM categories c0_ WHERE c0_.shop_id = ? AND c0_.is_visible = 1 ORDER BY c0_.position ASC
Parameters:
[
1
]
|
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\Category | 641 |
| Database\Entity\Genre | 641 |
| Database\Entity\Shop | 6 |
| Database\Entity\Country | 2 |
| Database\Entity\Address | 1 |
| Database\Entity\Currency | 1 |
| Database\Entity\Article | 1 |
| Database\Entity\Group | 1 |
| Database\Entity\Publisher | 1 |