Symfony Profiler

Query Metrics

29 Database Queries
19 Different statements
32.74 ms Query time
0 Invalid entities
28 Managed entities
Queries


SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ref AS ref_4, t0.alt AS alt_5, t0.position AS position_6, t0.price AS price_7, t0.promo AS promo_8, t0.image AS image_9, t0.stock AS stock_10, t0.create_at AS create_at_11, t0.update_at AS update_at_12, t0.active AS active_13, t0.default_name AS default_name_14, t0.long_description AS long_description_15, t0.short_description AS short_description_16, t0.care AS care_17, t0.category_id AS category_id_18, t19.id AS id_20, t19.name AS name_21, t19.slug AS slug_22, t19.image AS image_23, t19.alt AS alt_24, t19.min_price AS min_price_25, t19.update_at AS update_at_26, t19.title_page AS title_page_27, t19.sub_title_page AS sub_title_page_28, t19.cite_page AS cite_page_29, t19.main_image AS main_image_30, t19.main_alt AS main_alt_31, t19.second_image AS second_image_32, t19.second_alt AS second_alt_33, t19.third_image AS third_image_34, t19.third_alt AS third_alt_35, t19.fourth_image AS fourth_image_36, t19.fourth_alt AS fourth_alt_37, t19.nb_display AS nb_display_38, t19.sort AS sort_39, t19.show_sub_categories AS show_sub_categories_40, t19.description AS description_41, t19.meta_title AS meta_title_42, t19.parent_id AS parent_id_43, t0.field_id AS field_id_44, t0.product_option_id AS product_option_id_45 FROM product t0 LEFT JOIN category t19 ON t0.category_id = t19.id WHERE t0.slug = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.ref AS ref_3, p0_.alt AS alt_4, p0_.position AS position_5, p0_.price AS price_6, p0_.promo AS promo_7, p0_.image AS image_8, p0_.stock AS stock_9, p0_.create_at AS create_at_10, p0_.update_at AS update_at_11, p0_.active AS active_12, p0_.default_name AS default_name_13, p0_.long_description AS long_description_14, p0_.short_description AS short_description_15, p0_.care AS care_16, p0_.category_id AS category_id_17, p0_.field_id AS field_id_18, p0_.product_option_id AS product_option_id_19 FROM product p0_ WHERE p0_.active = 1 AND p0_.id <> ? AND p0_.default_name = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.product_attribute_group_id AS product_attribute_group_id_6 FROM product_attribute t0 INNER JOIN product_product_attribute ON t0.id = product_product_attribute.product_attribute_id WHERE product_product_attribute.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.public_name AS public_name_4, t0.position AS position_5, t0.sync AS sync_6 FROM product_attribute_group t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.custom_value AS custom_value_2, t0.product_id AS product_id_3, t0.feature_id AS feature_id_4, t0.feature_value_id AS feature_value_id_5 FROM product_feature t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.alt AS alt_5, t0.min_price AS min_price_6, t0.update_at AS update_at_7, t0.title_page AS title_page_8, t0.sub_title_page AS sub_title_page_9, t0.cite_page AS cite_page_10, t0.main_image AS main_image_11, t0.main_alt AS main_alt_12, t0.second_image AS second_image_13, t0.second_alt AS second_alt_14, t0.third_image AS third_image_15, t0.third_alt AS third_alt_16, t0.fourth_image AS fourth_image_17, t0.fourth_alt AS fourth_alt_18, t0.nb_display AS nb_display_19, t0.sort AS sort_20, t0.show_sub_categories AS show_sub_categories_21, t0.description AS description_22, t0.meta_title AS meta_title_23, t0.parent_id AS parent_id_24 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.alt AS alt_5, t0.min_price AS min_price_6, t0.update_at AS update_at_7, t0.title_page AS title_page_8, t0.sub_title_page AS sub_title_page_9, t0.cite_page AS cite_page_10, t0.main_image AS main_image_11, t0.main_alt AS main_alt_12, t0.second_image AS second_image_13, t0.second_alt AS second_alt_14, t0.third_image AS third_image_15, t0.third_alt AS third_alt_16, t0.fourth_image AS fourth_image_17, t0.fourth_alt AS fourth_alt_18, t0.nb_display AS nb_display_19, t0.sort AS sort_20, t0.show_sub_categories AS show_sub_categories_21, t0.description AS description_22, t0.meta_title AS meta_title_23, t0.parent_id AS parent_id_24 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.images AS images_2, t0.alt AS alt_3, t0.create_at AS create_at_4, t0.update_at AS update_at_5, t0.product_id AS product_id_6 FROM attachment t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.alt AS alt_5, t0.min_price AS min_price_6, t0.update_at AS update_at_7, t0.title_page AS title_page_8, t0.sub_title_page AS sub_title_page_9, t0.cite_page AS cite_page_10, t0.main_image AS main_image_11, t0.main_alt AS main_alt_12, t0.second_image AS second_image_13, t0.second_alt AS second_alt_14, t0.third_image AS third_image_15, t0.third_alt AS third_alt_16, t0.fourth_image AS fourth_image_17, t0.fourth_alt AS fourth_alt_18, t0.nb_display AS nb_display_19, t0.sort AS sort_20, t0.show_sub_categories AS show_sub_categories_21, t0.description AS description_22, t0.meta_title AS meta_title_23, t0.parent_id AS parent_id_24 FROM category t0 WHERE t0.name = ? LIMIT 1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.image AS image_3, c0_.alt AS alt_4, c0_.min_price AS min_price_5, c0_.update_at AS update_at_6, c0_.title_page AS title_page_7, c0_.sub_title_page AS sub_title_page_8, c0_.cite_page AS cite_page_9, c0_.main_image AS main_image_10, c0_.main_alt AS main_alt_11, c0_.second_image AS second_image_12, c0_.second_alt AS second_alt_13, c0_.third_image AS third_image_14, c0_.third_alt AS third_alt_15, c0_.fourth_image AS fourth_image_16, c0_.fourth_alt AS fourth_alt_17, c0_.nb_display AS nb_display_18, c0_.sort AS sort_19, c0_.show_sub_categories AS show_sub_categories_20, c0_.description AS description_21, c0_.meta_title AS meta_title_22, c0_.parent_id AS parent_id_23 FROM category c0_ WHERE c0_.parent_id = ? ORDER BY c0_.nb_display ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.alt AS alt_5, t0.min_price AS min_price_6, t0.update_at AS update_at_7, t0.title_page AS title_page_8, t0.sub_title_page AS sub_title_page_9, t0.cite_page AS cite_page_10, t0.main_image AS main_image_11, t0.main_alt AS main_alt_12, t0.second_image AS second_image_13, t0.second_alt AS second_alt_14, t0.third_image AS third_image_15, t0.third_alt AS third_alt_16, t0.fourth_image AS fourth_image_17, t0.fourth_alt AS fourth_alt_18, t0.nb_display AS nb_display_19, t0.sort AS sort_20, t0.show_sub_categories AS show_sub_categories_21, t0.description AS description_22, t0.meta_title AS meta_title_23, t0.parent_id AS parent_id_24 FROM category t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.alt AS alt_5, t0.min_price AS min_price_6, t0.update_at AS update_at_7, t0.title_page AS title_page_8, t0.sub_title_page AS sub_title_page_9, t0.cite_page AS cite_page_10, t0.main_image AS main_image_11, t0.main_alt AS main_alt_12, t0.second_image AS second_image_13, t0.second_alt AS second_alt_14, t0.third_image AS third_image_15, t0.third_alt AS third_alt_16, t0.fourth_image AS fourth_image_17, t0.fourth_alt AS fourth_alt_18, t0.nb_display AS nb_display_19, t0.sort AS sort_20, t0.show_sub_categories AS show_sub_categories_21, t0.description AS description_22, t0.meta_title AS meta_title_23, t0.parent_id AS parent_id_24 FROM category t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.alt AS alt_5, t0.min_price AS min_price_6, t0.update_at AS update_at_7, t0.title_page AS title_page_8, t0.sub_title_page AS sub_title_page_9, t0.cite_page AS cite_page_10, t0.main_image AS main_image_11, t0.main_alt AS main_alt_12, t0.second_image AS second_image_13, t0.second_alt AS second_alt_14, t0.third_image AS third_image_15, t0.third_alt AS third_alt_16, t0.fourth_image AS fourth_image_17, t0.fourth_alt AS fourth_alt_18, t0.nb_display AS nb_display_19, t0.sort AS sort_20, t0.show_sub_categories AS show_sub_categories_21, t0.description AS description_22, t0.meta_title AS meta_title_23, t0.parent_id AS parent_id_24 FROM category t0 WHERE t0.parent_id = ?
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT @@character_set_database, @@collation_database
SELECT DATABASE()
SELECT
       c.TABLE_NAME,
       c.COLUMN_NAME        AS field,
           IF(
        c.DATA_TYPE = 'longtext'
        AND EXISTS(
            SELECT * FROM information_schema.CHECK_CONSTRAINTS i_c
            WHERE i_c.CONSTRAINT_SCHEMA = 'nuip1737_tussor_dev'
            AND i_c.TABLE_NAME = c.TABLE_NAME
            AND i_c.CHECK_CLAUSE = CONCAT(
                'json_valid(`',
                    c.COLUMN_NAME,
                '`)'
            )
        ),
        'json',
        c.DATA_TYPE
    )                   AS type,
       c.COLUMN_TYPE,
       c.CHARACTER_MAXIMUM_LENGTH,
       c.CHARACTER_OCTET_LENGTH,
       c.NUMERIC_PRECISION,
       c.NUMERIC_SCALE,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
 WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ?
   AND t.TABLE_TYPE = 'BASE TABLE'
ORDER BY c.TABLE_NAME,
         c.ORDINAL_POSITION
SELECT DATABASE()
SELECT
        TABLE_NAME,
        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS
WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ?
ORDER BY TABLE_NAME,
         SEQ_IN_INDEX
SELECT DATABASE()
SELECT
            k.TABLE_NAME,
            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION,
            c.UPDATE_RULE,
            c.DELETE_RULE
FROM information_schema.key_column_usage k
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME
WHERE k.TABLE_SCHEMA = ? AND c.CONSTRAINT_SCHEMA = ? AND k.TABLE_NAME = ?
AND k.REFERENCED_COLUMN_NAME IS NOT NULL
ORDER BY k.TABLE_NAME,
         k.CONSTRAINT_NAME,
         k.ORDINAL_POSITION
SELECT DATABASE()
SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
          ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
SELECT * FROM doctrine_migration_versions
SELECT DATABASE()
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ref AS ref_4, t0.alt AS alt_5, t0.position AS position_6, t0.price AS price_7, t0.promo AS promo_8, t0.image AS image_9, t0.stock AS stock_10, t0.create_at AS create_at_11, t0.update_at AS update_at_12, t0.active AS active_13, t0.default_name AS default_name_14, t0.long_description AS long_description_15, t0.short_description AS short_description_16, t0.care AS care_17, t0.category_id AS category_id_18, t19.id AS id_20, t19.name AS name_21, t19.slug AS slug_22, t19.image AS image_23, t19.alt AS alt_24, t19.min_price AS min_price_25, t19.update_at AS update_at_26, t19.title_page AS title_page_27, t19.sub_title_page AS sub_title_page_28, t19.cite_page AS cite_page_29, t19.main_image AS main_image_30, t19.main_alt AS main_alt_31, t19.second_image AS second_image_32, t19.second_alt AS second_alt_33, t19.third_image AS third_image_34, t19.third_alt AS third_alt_35, t19.fourth_image AS fourth_image_36, t19.fourth_alt AS fourth_alt_37, t19.nb_display AS nb_display_38, t19.sort AS sort_39, t19.show_sub_categories AS show_sub_categories_40, t19.description AS description_41, t19.meta_title AS meta_title_42, t19.parent_id AS parent_id_43, t0.field_id AS field_id_44, t0.product_option_id AS product_option_id_45 FROM product t0 LEFT JOIN category t19 ON t0.category_id = t19.id INNER JOIN product_product ON t0.id = product_product.product_target WHERE product_product.product_source = ?
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
App\Entity\Category	22
App\Entity\Product	2
App\Entity\Field	2
App\Entity\ProductAttribute	1
App\Entity\ProductAttributeGroup	1
Entities Mapping

Class	Mapping errors
App\Entity\Product	No errors.
App\Entity\Category	No errors.
App\Entity\Field	No errors.
App\Entity\ProductOption	No errors.
App\Entity\Attachment	No errors.
App\Entity\ProductFeature	No errors.
App\Entity\ProductAttributeGroup	No errors.
App\Entity\ProductAttribute	No errors.
App\Entity\Feature	No errors.
App\Entity\FeatureValue	No errors.
App\Entity\Gift	No errors.
App\Entity\DeliveryMod	No errors.
App\Entity\Order	No errors.
App\Entity\Shop	No errors.
App\Entity\User	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\Event	No errors.
App\Entity\Address	No errors.
App\Entity\ProductOrder	No errors.
Vich\UploaderBundle\Entity\File	No errors.
Symfony Profiler

GET http://v2.tussor.net/boutique/small/produit/canotage-small-olive

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping
