Query Metrics
18
Database Queries
7
Different statements
1.71 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.10 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
]
|
2 | 0.14 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:
[ "supplier_order_state_for_supplier_waiting_in_the_product_view" b"\x1E╚5\x1DHÔd\x06ÅÚoµð\e»ã" ] |
3 | 0.07 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 IS NULL LIMIT 1
Parameters:
[
"supplier_order_state_for_supplier_waiting_in_the_product_view"
]
|
4 | 0.08 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
]
|
5 | 0.07 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:
[ "supplier_order_state_for_supplier_waiting_in_the_product_view" b"\x1E╚5\x1DHÔd\x06ÅÚoµð\e»ã" ] |
6 | 0.06 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 IS NULL LIMIT 1
Parameters:
[
"supplier_order_state_for_supplier_waiting_in_the_product_view"
]
|
7 | 0.04 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
]
|
8 | 0.08 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:
[ "sales_bundle__shared_sales" b"\x1E╚5\x1DHÔd\x06ÅÚoµð\e»ã" ] |
9 | 0.07 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 IS NULL LIMIT 1
Parameters:
[
"sales_bundle__shared_sales"
]
|
10 | 0.04 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
]
|
11 | 0.08 ms |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.reference AS reference_2, e0_.address AS address_3, e0_.address2 AS address2_4, e0_.postcode AS postcode_5, e0_.city AS city_6, e0_.phone AS phone_7, e0_.email AS email_8, e0_.created_at AS created_at_9, e0_.updated_at AS updated_at_10, e0_.deleted_at AS deleted_at_11, e0_.country_id AS country_id_12, e0_.context_id AS context_id_13, e0_.created_by_id AS created_by_id_14, e0_.updated_by_id AS updated_by_id_15, e0_.deleted_by_id AS deleted_by_id_16 FROM establishment e0_ WHERE (e0_.deleted_at IS NULL)
Parameters:
[] |
12 | 0.07 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
]
|
13 | 0.08 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:
[ "prestashop_connector_bundle__shop_url" b"\x1E╚5\x1DHÔd\x06ÅÚoµð\e»ã" ] |
14 | 0.07 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
]
|
15 | 0.07 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:
[ "prestashop_connector_bundle__api_key" b"\x1E╚5\x1DHÔd\x06ÅÚoµð\e»ã" ] |
16 | 0.26 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.mobile_phone AS mobile_phone_5, t0.password AS password_6, t0.token AS token_7, t0.token_validity AS token_validity_8, t0.login_name AS login_name_9, t0.api_pin AS api_pin_10, t0.api_token AS api_token_11, t0.api_token_validity AS api_token_validity_12, t0.config AS config_13, t0.email_signature AS email_signature_14, t0.note AS note_15, t0.is_solo AS is_solo_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_active AS is_active_20, t0.profile_id AS profile_id_21, t0.language_id AS language_id_22, t0.created_by_id AS created_by_id_23, t0.updated_by_id AS updated_by_id_24, t0.deleted_by_id AS deleted_by_id_25 FROM user t0 WHERE t0.email = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
"contact@scaledev.fr"
]
|
17 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6 FROM profile t0 WHERE t0.id = ?
Parameters:
[
b"\x1E╚5\x1DAãdêüÂoµð\e»ã"
]
|
18 | 0.18 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.deleted_at AS deleted_at_4, s0_.default_location_id AS default_location_id_5, s0_.default_sub_location_id AS default_sub_location_id_6, s0_.created_by_id AS created_by_id_7, s0_.updated_by_id AS updated_by_id_8, s0_.deleted_by_id AS deleted_by_id_9 FROM stocks_bundle__warehouse s0_ WHERE (s0_.deleted_at IS NULL) ORDER BY s0_.id ASC LIMIT 30
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\User | No errors. |
App\Entity\Profile | No errors. |
App\Entity\Language | No errors. |
Bluue\CategoriesBundle\Entity\Category | No errors. |
App\Entity\Context | No errors. |
App\Entity\Currency | No errors. |
App\Entity\Country | No errors. |
App\Entity\CountryState | No errors. |
App\Entity\Configuration | No errors. |
App\Entity\UserContext | No errors. |
App\Entity\MailServer | No errors. |
App\Entity\Establishment | No errors. |
Bluue\SalesBundle\Entity\OrderLine | No errors. |
App\Entity\UsersEstablishments | No errors. |
App\Entity\UserLoginLog | No errors. |
App\Entity\Notification | No errors. |
App\Entity\TeamUser | No errors. |
Bluue\StocksBundle\Entity\Warehouse | No errors. |
Bluue\StocksBundle\Entity\Location | No errors. |
Bluue\StocksBundle\Entity\SubLocation | No errors. |
Bluue\StocksBundle\Entity\StockProduct | No errors. |