Query Metrics
20
Database Queries
4
Different statements
5.05 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.77 ms (34.97%) |
7 |
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:
[ "stocks_bundle__calc_stock_with_product_parent" b"\x1E╚5\x1DHÔd\x06ÅÚoµð\e»ã" ] |
1.67 ms (33.18%) |
8 |
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
]
|
1.42 ms (28.18%) |
4 |
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:
[
"stocks_bundle__calc_stock_with_product_parent"
]
|
0.19 ms (3.67%) |
1 |
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:
[] |
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\Context | No errors. |
App\Entity\Currency | No errors. |
App\Entity\Country | No errors. |
App\Entity\CountryState | No errors. |
App\Entity\User | No errors. |
App\Entity\Configuration | No errors. |
App\Entity\UserContext | No errors. |
App\Entity\MailServer | No errors. |
App\Entity\Establishment | No errors. |
Bluue\CategoriesBundle\Entity\Category | No errors. |
Bluue\SalesBundle\Entity\OrderLine | No errors. |
Bluue\SalesBundle\Entity\Quotation | No errors. |
Bluue\SalesBundle\Entity\Order | No errors. |
Bluue\SalesBundle\Entity\Invoice | No errors. |
Bluue\SalesBundle\Entity\CreditNote | No errors. |
Bluue\SalesBundle\Entity\DeliveryNote | No errors. |
Bluue\SalesBundle\Entity\InvoiceLine | No errors. |
Bluue\SalesBundle\Entity\CreditNoteLine | No errors. |
Bluue\SalesBundle\Entity\Payment | No errors. |
App\Entity\UsersEstablishments | No errors. |