Query Metrics
10
Database Queries
5
Different statements
2.30 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.45 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.ip_address AS ip_address_2, c0_.address AS address_3, c0_.postcode AS postcode_4, c0_.city AS city_5, c0_.phone AS phone_6, c0_.password AS password_7, c0_.options AS options_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.deleted_at AS deleted_at_11, c0_.currency_id AS currency_id_12, c0_.country_id AS country_id_13, c0_.context_id AS context_id_14, c0_.establishment_id AS establishment_id_15, c0_.created_by_id AS created_by_id_16, c0_.updated_by_id AS updated_by_id_17, c0_.deleted_by_id AS deleted_by_id_18, c0_.warehouse_id AS warehouse_id_19 FROM cash_register_bundle__shop c0_ WHERE (c0_.ip_address IS NULL OR (c0_.ip_address IS NOT NULL AND c0_.ip_address = ?)) AND (c0_.deleted_at IS NULL)
Parameters:
[
"3.135.219.153"
]
|
2 | 0.32 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
1
]
|
3 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id = ? LIMIT 1
Parameters:
[ "bluue.favicon" b"\x1E╚5\x1DHÔd\x06ÅÚoµð\e»ã" ] |
4 | 0.16 ms |
SELECT t0.id AS id_1, t0.key_path AS key_path_2, t0.original_filename AS original_filename_3, t0.mime_type AS mime_type_4, t0.extension AS extension_5, t0.size AS size_6, t0.width AS width_7, t0.height AS height_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM file_manager t0 WHERE t0.id = ?
Parameters:
[
b"\x1EÌ«€Ñäj ¯|×âê\x00lƒ"
]
|
5 | 0.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
1
]
|
6 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id = ? LIMIT 1
Parameters:
[ "bluue.favicon" b"\x1E╚5\x1DHÔd\x06ÅÚoµð\e»ã" ] |
7 | 0.21 ms |
SELECT f0_.id AS id_0, f0_.key_path AS key_path_1, f0_.original_filename AS original_filename_2, f0_.mime_type AS mime_type_3, f0_.extension AS extension_4, f0_.size AS size_5, f0_.width AS width_6, f0_.height AS height_7, f0_.created_at AS created_at_8, f0_.updated_at AS updated_at_9 FROM file_manager f0_ WHERE f0_.key_path LIKE ? LIMIT 1
Parameters:
[
"cash_register_bundle.login_background"
]
|
8 | 0.19 ms |
SELECT f0_.id AS id_0, f0_.key_path AS key_path_1, f0_.original_filename AS original_filename_2, f0_.mime_type AS mime_type_3, f0_.extension AS extension_4, f0_.size AS size_5, f0_.width AS width_6, f0_.height AS height_7, f0_.created_at AS created_at_8, f0_.updated_at AS updated_at_9 FROM file_manager f0_ WHERE f0_.key_path LIKE ? LIMIT 1
Parameters:
[
"cash_register_bundle.login_background"
]
|
9 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
1
]
|
10 | 0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id = ? LIMIT 1
Parameters:
[ "cash_register_bundle__show_shop_name_with_city" b"\x1E╚5\x1DHÔd\x06ÅÚoµð\e»ã" ] |
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 |
---|---|
Bluue\CashRegisterBundle\Entity\Shop | No errors. |
App\Entity\Currency | No errors. |
App\Entity\Country | No errors. |
App\Entity\Context | No errors. |
App\Entity\Establishment | No errors. |
App\Entity\User | No errors. |
Bluue\StocksBundle\Entity\Warehouse | No errors. |
Bluue\CashRegisterBundle\Entity\CashRegister | No errors. |
Bluue\CashRegisterBundle\Entity\CashierShop | No errors. |
Bluue\CategoriesBundle\Entity\Category | No errors. |
Bluue\SalesBundle\Entity\OrderLine | No errors. |
App\Entity\CountryState | No errors. |
App\Entity\Configuration | No errors. |
App\Entity\UserContext | No errors. |
App\Entity\MailServer | No errors. |
App\Entity\FileManager | No errors. |