https://performancesx.com/fr/admin/products

Query Metrics

60 Database Queries
16 Different statements
4.57 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.01 ms
(22.18%)
1
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.reference AS reference_3, t0.username AS username_4, t0.email AS email_5, t0.enabled AS enabled_6, t0.salt AS salt_7, t0.password AS password_8, t0.last_login AS last_login_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.lastname AS lastname_12, t0.firstname AS firstname_13, t0.birthday AS birthday_14, t0.phones AS phones_15, t0.extra_emails AS extra_emails_16, t0.status AS status_17, t0.address_line1 AS address_line1_18, t0.address_line2 AS address_line2_19, t0.address_zipcode AS address_zipcode_20, t0.address_city AS address_city_21, t0.address_country AS address_country_22, t0.delivery_address_line1 AS delivery_address_line1_23, t0.delivery_address_line2 AS delivery_address_line2_24, t0.delivery_address_zipcode AS delivery_address_zipcode_25, t0.delivery_address_city AS delivery_address_city_26, t0.delivery_address_country AS delivery_address_country_27, t0.iscompany AS iscompany_28, t0.company AS company_29, t0.siret_number AS siret_number_30, t0.is_divers AS is_divers_31, t0.lastActivityAt AS lastActivityAt_32, t0.locale AS locale_33, t0.facebook_id AS facebook_id_34, t0.google_id AS google_id_35, t0.thumbnail_id AS thumbnail_id_36, t0.thumbnail2_id AS thumbnail2_id_37, t0.basket_id AS basket_id_38 FROM ss_user t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.70 ms
(15.43%)
19
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.old_price AS old_price_3, t0.created_at AS created_at_4, t0.lapsing AS lapsing_5, t0.unique_reduction AS unique_reduction_6, t0.product_id AS product_id_7 FROM ss_hotdeal t0 WHERE t0.product_id = ?
Parameters:
[
  2
]
0.69 ms
(15.09%)
19
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created_at AS created_at_3, t0.started_at AS started_at_4, t0.lead_number AS lead_number_5, t0.lead_interval AS lead_interval_6, t0.quantity AS quantity_7, t0.limitation AS limitation_8, t0.product_id AS product_id_9 FROM ss_preorder t0 WHERE t0.product_id = ?
Parameters:
[
  2
]
0.53 ms
(11.63%)
9
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.reference AS reference_3, t0.reference_public AS reference_public_4, t0.names AS names_5, t0.descriptions AS descriptions_6, t0.color AS color_7, t0.extra_price AS extra_price_8, t0.position AS position_9, t0.enabled AS enabled_10, t0.level AS level_11, t0.category_parent_id AS category_parent_id_12, t0.thumbnail_id AS thumbnail_id_13, t0.thumbnail2_id AS thumbnail2_id_14 FROM ss_category t0 WHERE t0.category_parent_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  1
]
0.33 ms
(7.14%)
1
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.type AS type_2, s0_.reference AS reference_3, s0_.reference_public AS reference_public_4, s0_.created_at AS created_at_5, s0_.name AS name_6, s0_.descriptions AS descriptions_7, s0_.properties AS properties_8, s0_.weight AS weight_9, s0_.quantity AS quantity_10, s0_.unity AS unity_11, s0_.price AS price_12, s0_.is_pneumatic AS is_pneumatic_13, s0_.pneumatic_width AS pneumatic_width_14, s0_.pneumatic_height AS pneumatic_height_15, s0_.pneumatic_type AS pneumatic_type_16, s0_.pneumatic_diameter AS pneumatic_diameter_17, s0_.pneumatic_charge AS pneumatic_charge_18, s0_.pneumatic_speed AS pneumatic_speed_19, s0_.enabled AS enabled_20, s0_.is_extension AS is_extension_21, s0_.new AS new_22, s0_.trash AS trash_23, s0_.declination AS declination_24, s0_.position AS position_25, s0_.color AS color_26 FROM ss_product s0_ WHERE s0_.trash = 0 AND s0_.declination = 0) dctrn_result) dctrn_table
Parameters:
[]
0.20 ms
(4.27%)
1
SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.type AS type_2, s0_.reference AS reference_3, s0_.reference_public AS reference_public_4, s0_.created_at AS created_at_5, s0_.name AS name_6, s0_.descriptions AS descriptions_7, s0_.properties AS properties_8, s0_.weight AS weight_9, s0_.quantity AS quantity_10, s0_.unity AS unity_11, s0_.price AS price_12, s0_.is_pneumatic AS is_pneumatic_13, s0_.pneumatic_width AS pneumatic_width_14, s0_.pneumatic_height AS pneumatic_height_15, s0_.pneumatic_type AS pneumatic_type_16, s0_.pneumatic_diameter AS pneumatic_diameter_17, s0_.pneumatic_charge AS pneumatic_charge_18, s0_.pneumatic_speed AS pneumatic_speed_19, s0_.enabled AS enabled_20, s0_.is_extension AS is_extension_21, s0_.new AS new_22, s0_.trash AS trash_23, s0_.declination AS declination_24, s0_.position AS position_25, s0_.color AS color_26, s0_.media_reference_id AS media_reference_id_27, s0_.extension_id AS extension_id_28, s0_.brand_id AS brand_id_29, s0_.category_id AS category_id_30, s0_.collection_id AS collection_id_31, s0_.provider_id AS provider_id_32, s0_.barcode_id AS barcode_id_33, s0_.groupe_product_id AS groupe_product_id_34, s0_.groupe_declination_id AS groupe_declination_id_35, s0_.groupe_attribute_id AS groupe_attribute_id_36, s0_.attribute_id AS attribute_id_37, s0_.deposit_stock_id AS deposit_stock_id_38 FROM ss_product s0_ WHERE s0_.trash = 0 AND s0_.declination = 0 AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  2
  3
  4
  5
  6
  9
  10
  11
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
]
0.17 ms
(3.70%)
1
SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.name AS name_2, s0_.description AS description_3, s0_.thumbnail_id AS thumbnail_id_4 FROM ss_brand s0_ ORDER BY s0_.id ASC
Parameters:
[]
0.14 ms
(3.06%)
1
SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.type AS type_2, s0_.reference AS reference_3, s0_.reference_public AS reference_public_4, s0_.created_at AS created_at_5, s0_.name AS name_6, s0_.descriptions AS descriptions_7, s0_.properties AS properties_8, s0_.weight AS weight_9, s0_.quantity AS quantity_10, s0_.unity AS unity_11, s0_.price AS price_12, s0_.is_pneumatic AS is_pneumatic_13, s0_.pneumatic_width AS pneumatic_width_14, s0_.pneumatic_height AS pneumatic_height_15, s0_.pneumatic_type AS pneumatic_type_16, s0_.pneumatic_diameter AS pneumatic_diameter_17, s0_.pneumatic_charge AS pneumatic_charge_18, s0_.pneumatic_speed AS pneumatic_speed_19, s0_.enabled AS enabled_20, s0_.is_extension AS is_extension_21, s0_.new AS new_22, s0_.trash AS trash_23, s0_.declination AS declination_24, s0_.position AS position_25, s0_.color AS color_26 FROM ss_product s0_ WHERE s0_.trash = 0 AND s0_.declination = 0) dctrn_result LIMIT 19
Parameters:
[]
0.12 ms
(2.74%)
1
SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.reference AS reference_2, s0_.reference_public AS reference_public_3, s0_.names AS names_4, s0_.descriptions AS descriptions_5, s0_.color AS color_6, s0_.extra_price AS extra_price_7, s0_.position AS position_8, s0_.enabled AS enabled_9, s0_.level AS level_10, s0_.category_parent_id AS category_parent_id_11, s0_.thumbnail_id AS thumbnail_id_12, s0_.thumbnail2_id AS thumbnail2_id_13 FROM ss_category s0_ WHERE s0_.category_parent_id IS NULL ORDER BY s0_.position ASC
Parameters:
[]
0.12 ms
(2.63%)
1
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.reference AS reference_3, t0.reference_public AS reference_public_4, t0.names AS names_5, t0.descriptions AS descriptions_6, t0.color AS color_7, t0.extra_price AS extra_price_8, t0.position AS position_9, t0.enabled AS enabled_10, t0.level AS level_11, t0.category_parent_id AS category_parent_id_12, t0.thumbnail_id AS thumbnail_id_13, t0.thumbnail2_id AS thumbnail2_id_14 FROM ss_category t0 WHERE t0.category_parent_id IS NULL
Parameters:
[]
0.12 ms
(2.52%)
1
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.description AS description_4, t0.thumbnail_id AS thumbnail_id_5 FROM ss_brand t0
Parameters:
[]
0.11 ms
(2.39%)
1
SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.type AS type_2, s0_.domain AS domain_3, s0_.description AS description_4, s0_.variables AS variables_5, s0_.created_at AS created_at_6, s0_.readed_at AS readed_at_7, s0_.is_readed AS is_readed_8 FROM ss_notification s0_ WHERE s0_.domain = ? AND s0_.is_readed = ? ORDER BY s0_.id DESC
Parameters:
[
  "admin"
  0
]
0.10 ms
(2.23%)
1
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.code AS code_3, t0.name AS name_4, t0.decimal_code AS decimal_code_5, t0.priority AS priority_6, t0.enabled AS enabled_7 FROM ss_currency t0 WHERE t0.priority = ? LIMIT 1
Parameters:
[
  1
]
0.08 ms
(1.84%)
1
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.value AS value_4 FROM ss_setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "orderonline_state"
]
0.08 ms
(1.78%)
1
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.names AS names_3, t0.descriptions AS descriptions_4 FROM ss_collection t0
Parameters:
[]
0.06 ms
(1.36%)
1
SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.names AS names_2, s0_.descriptions AS descriptions_3 FROM ss_collection s0_ ORDER BY s0_.id ASC
Parameters:
[]

Database Connections

Name Service
db1 doctrine.dbal.db1_connection

Entity Managers

Name Service
auto_generate_proxy_classes doctrine.orm.auto_generate_proxy_classes_entity_manager
auto_mapping doctrine.orm.auto_mapping_entity_manager
em1 doctrine.orm.em1_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

auto_generate_proxy_classes entity manager

No loaded entities.

auto_mapping entity manager

No loaded entities.

em1 entity manager

Class Mapping errors
App\Entity\User No errors.
App\Entity\Image No errors.
App\Entity\Basket No errors.
App\Entity\UserAddress No errors.
App\Entity\Remark No errors.
App\Entity\AccountingDocument No errors.
App\Entity\CashRegister No errors.
App\Entity\Product No errors.
App\Entity\Brand No errors.
App\Entity\Category No errors.
App\Entity\Collection No errors.
App\Entity\Currency No errors.
App\Entity\CurrencyFluctuation No errors.
App\Entity\CashFund No errors.
App\Entity\Setting No errors.
App\Entity\Notification No errors.
App\Entity\Media No errors.
App\Entity\BarCode No errors.
App\Entity\GroupeProduct No errors.
App\Entity\GroupeDeclination No errors.
App\Entity\GroupeAttribute No errors.
App\Entity\Attribute No errors.
App\Entity\DepositStock No errors.
App\Entity\RemarkFake No errors.
App\Entity\AccountingDocumentLine No errors.
App\Entity\HotDeal No errors.
App\Entity\PreOrder No errors.
App\Entity\SupplyRegistration No errors.
App\Entity\BasketElement No errors.
App\Entity\InventoryProduct No errors.
App\Entity\VehicleCylinder No errors.