https://esorus-shop.woodenizr.com/en/category/tools-accessories

Query Metrics

33 Database Queries
16 Different statements
38.60 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.86 ms
SELECT t0.id AS id_1, t0.`from` AS from_2, t0.`to` AS to_3, t0.created AS created_4, t0.creator AS creator_5, t0.modified AS modified_6, t0.modified_by AS modified_by_7 FROM redirect_404 t0 WHERE t0.`from` = ? LIMIT 1
Parameters:
[
  "https://esorus-shop.woodenizr.com/en/category/tools-accessories"
]
2 2.18 ms
SELECT s0_.title AS title_0, s0_.slug AS slug_1, s0_.meta_description AS meta_description_2, s0_.focus_keyword AS focus_keyword_3, s0_.meta_keyword AS meta_keyword_4, s0_.meta_tags AS meta_tags_5, s0_.state AS state_6, s0_.last_modified AS last_modified_7, s0_.deleted AS deleted_8, s0_.id AS id_9, s1_.title AS title_10, s1_.slug AS slug_11, s1_.meta_description AS meta_description_12, s1_.focus_keyword AS focus_keyword_13, s1_.meta_keyword AS meta_keyword_14, s1_.meta_tags AS meta_tags_15, s1_.state AS state_16, s2_.id AS id_17, s2_.entity_name AS entity_name_18, s2_.base_route AS base_route_19, s2_.created AS created_20, s2_.creator AS creator_21, s2_.modified AS modified_22, s2_.modified_by AS modified_by_23, l3_.id AS id_24, l3_.locale AS locale_25, l3_.title AS title_26, l3_.flag_asset AS flag_asset_27, s0_.seo_base_route_id AS seo_base_route_id_28, s1_.translatable_id AS translatable_id_29, s1_.language_id AS language_id_30 FROM seo s0_ LEFT JOIN seo_translations s1_ ON s0_.id = s1_.translatable_id LEFT JOIN seo_base_route s2_ ON s0_.seo_base_route_id = s2_.id LEFT JOIN language l3_ ON s1_.language_id = l3_.id WHERE s0_.slug = ? AND (s2_.entity_name = ? OR s2_.entity_name = ?) AND s0_.deleted = 0 LIMIT 1
Parameters:
[
  "tools-accessories"
  "App\ProductBundle\Entity\Category"
  "Category"
]
3 1.54 ms
SELECT -c0_.tarteb AS sclr_0, c0_.id AS id_1, c0_.title AS title_2, c0_.concatIds AS concatIds_3, c0_.tarteb AS tarteb_4, c0_.depth AS depth_5, c0_.no_of_images AS no_of_images_6, c0_.no_of_products AS no_of_products_7, c0_.no_of_publish_products AS no_of_publish_products_8, c0_.parentConcatIds AS parentConcatIds_9, c0_.publish AS publish_10, c0_.featured AS featured_11, c0_.deleted AS deleted_12, c0_.deleted_by AS deleted_by_13, c0_.created AS created_14, c0_.creator AS creator_15, c0_.modified AS modified_16, c0_.modified_by AS modified_by_17, i1_.name AS name_18, i1_.base_path AS base_path_19, i1_.alt AS alt_20, i1_.width AS width_21, i1_.height AS height_22, i1_.size AS size_23, i1_.tarteb AS tarteb_24, i1_.image_type AS image_type_25, i1_.created AS created_26, i1_.id AS id_27, c2_.title AS title_28, s3_.title AS title_29, s3_.slug AS slug_30, s3_.meta_description AS meta_description_31, s3_.focus_keyword AS focus_keyword_32, s3_.meta_keyword AS meta_keyword_33, s3_.meta_tags AS meta_tags_34, s3_.state AS state_35, s3_.last_modified AS last_modified_36, s3_.deleted AS deleted_37, s3_.id AS id_38, s4_.title AS title_39, s4_.slug AS slug_40, s4_.meta_description AS meta_description_41, s4_.focus_keyword AS focus_keyword_42, s4_.meta_keyword AS meta_keyword_43, s4_.meta_tags AS meta_tags_44, s4_.state AS state_45, p5_.content AS content_46, p5_.id AS id_47, p6_.content AS content_48, c0_.image_id AS image_id_49, c0_.post_id AS post_id_50, c0_.seo_id AS seo_id_51, c0_.parent_id AS parent_id_52, c0_.level_one_id AS level_one_id_53, c2_.translatable_id AS translatable_id_54, c2_.language_id AS language_id_55, s3_.seo_base_route_id AS seo_base_route_id_56, s4_.translatable_id AS translatable_id_57, s4_.language_id AS language_id_58, p6_.translatable_id AS translatable_id_59, p6_.language_id AS language_id_60 FROM category c0_ LEFT JOIN image i1_ ON c0_.image_id = i1_.id LEFT JOIN category_translations c2_ ON c0_.id = c2_.translatable_id LEFT JOIN seo s3_ ON c0_.seo_id = s3_.id LEFT JOIN seo_translations s4_ ON s3_.id = s4_.translatable_id LEFT JOIN post p5_ ON c0_.post_id = p5_.id LEFT JOIN post_translations p6_ ON p5_.id = p6_.translatable_id WHERE c0_.seo_id = ? GROUP BY c0_.id LIMIT 1
Parameters:
[
  15
]
4 1.22 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.concatIds AS concatIds_3, t0.tarteb AS tarteb_4, t0.depth AS depth_5, t0.no_of_images AS no_of_images_6, t0.no_of_products AS no_of_products_7, t0.no_of_publish_products AS no_of_publish_products_8, t0.parentConcatIds AS parentConcatIds_9, t0.publish AS publish_10, t0.featured AS featured_11, t0.deleted AS deleted_12, t0.deleted_by AS deleted_by_13, t0.created AS created_14, t0.creator AS creator_15, t0.modified AS modified_16, t0.modified_by AS modified_by_17, t0.image_id AS image_id_18, t0.post_id AS post_id_19, t0.seo_id AS seo_id_20, t0.parent_id AS parent_id_21, t0.level_one_id AS level_one_id_22 FROM category t0 WHERE (t0.deleted IS NULL AND t0.parent_id = ?) ORDER BY t0.tarteb ASC
Parameters:
[
  1
]
5 1.00 ms
SELECT t0.title AS title_1, t0.translatable_id AS translatable_id_2, t0.language_id AS language_id_3 FROM category_translations t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
6 1.11 ms
SELECT t0.title AS title_1, t0.translatable_id AS translatable_id_2, t0.language_id AS language_id_3 FROM category_translations t0 WHERE t0.translatable_id = ?
Parameters:
[
  3
]
7 0.56 ms
SELECT t0.title AS title_1, t0.translatable_id AS translatable_id_2, t0.language_id AS language_id_3 FROM category_translations t0 WHERE t0.translatable_id = ?
Parameters:
[
  4
]
8 0.97 ms
SELECT t0.title AS title_1, t0.translatable_id AS translatable_id_2, t0.language_id AS language_id_3 FROM category_translations t0 WHERE t0.translatable_id = ?
Parameters:
[
  5
]
9 0.31 ms
SELECT t0.title AS title_1, t0.translatable_id AS translatable_id_2, t0.language_id AS language_id_3 FROM category_translations t0 WHERE t0.translatable_id = ?
Parameters:
[
  7
]
10 0.39 ms
SELECT t0.title AS title_1, t0.translatable_id AS translatable_id_2, t0.language_id AS language_id_3 FROM category_translations t0 WHERE t0.translatable_id = ?
Parameters:
[
  6
]
11 1.05 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image_url AS image_url_4, t0.social_network AS social_network_5 FROM seo_social t0 INNER JOIN seo_seo_social ON t0.id = seo_seo_social.seo_social_id WHERE seo_seo_social.seo_id = ?
Parameters:
[
  15
]
12 0.70 ms
SELECT DATABASE()
Parameters:
[]
13 3.93 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "esorus_db"
]
14 0.54 ms
SELECT DATABASE()
Parameters:
[]
15 2.02 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "esorus_db"
]
16 0.52 ms
SELECT DATABASE()
Parameters:
[]
17 1.63 ms
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.FULL_COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters:
[
  "esorus_db"
  "doctrine_migration_versions"
]
18 0.41 ms
SELECT DATABASE()
Parameters:
[]
19 2.61 ms
SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
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 k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'esorus_db' */ ORDER BY k.ORDINAL_POSITION
Parameters:
[
  "esorus_db"
  "doctrine_migration_versions"
]
20 4.11 ms
SELECT       c.COLUMN_NAME        AS field,
           IF(
        c.COLUMN_TYPE = 'longtext'
        AND EXISTS(
            SELECT * from information_schema.CHECK_CONSTRAINTS i_c
            WHERE i_c.CONSTRAINT_SCHEMA = 'esorus_db'
            AND i_c.TABLE_NAME = c.TABLE_NAME
            AND i_c.CHECK_CLAUSE = CONCAT(
                'json_valid(`',
                    c.COLUMN_NAME,
                '`)'
            )
        ),
        'json',
        c.COLUMN_TYPE
    )       AS type,
       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_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters:
[
  "esorus_db"
  "esorus_db"
  "doctrine_migration_versions"
]
21 0.62 ms
SELECT DATABASE()
Parameters:
[]
22 0.77 ms
SELECT        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 SEQ_IN_INDEX
Parameters:
[
  "esorus_db"
  "doctrine_migration_versions"
]
23 0.54 ms
SELECT * FROM doctrine_migration_versions
Parameters:
[]
24 0.53 ms
SELECT DATABASE()
Parameters:
[]
25 2.80 ms
SELECT t0.name AS name_1, t0.base_path AS base_path_2, t0.alt AS alt_3, t0.width AS width_4, t0.height AS height_5, t0.size AS size_6, t0.tarteb AS tarteb_7, t0.image_type AS image_type_8, t0.created AS created_9, t0.id AS id_10 FROM image t0 INNER JOIN post_image ON t0.id = post_image.image_id WHERE post_image.post_id = ? ORDER BY t0.id ASC, t0.tarteb ASC
Parameters:
[
  2
]
26 0.93 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.type AS type_4, t0.hint AS hint_5, t0.image_width AS image_width_6, t0.image_height AS image_height_7, t0.dynamic_content_id AS dynamic_content_id_8 FROM dynamic_content_attribute t0 WHERE t0.id = ?
Parameters:
[
  2
]
27 0.72 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.type AS type_4, t0.hint AS hint_5, t0.image_width AS image_width_6, t0.image_height AS image_height_7, t0.dynamic_content_id AS dynamic_content_id_8 FROM dynamic_content_attribute t0 WHERE t0.id = ?
Parameters:
[
  1
]
28 1.09 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.type AS type_4, t0.hint AS hint_5, t0.image_width AS image_width_6, t0.image_height AS image_height_7, t0.dynamic_content_id AS dynamic_content_id_8 FROM dynamic_content_attribute t0 WHERE t0.id = ?
Parameters:
[
  3
]
29 0.54 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.type AS type_4, t0.hint AS hint_5, t0.image_width AS image_width_6, t0.image_height AS image_height_7, t0.dynamic_content_id AS dynamic_content_id_8 FROM dynamic_content_attribute t0 WHERE t0.id = ?
Parameters:
[
  4
]
30 0.45 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.type AS type_4, t0.hint AS hint_5, t0.image_width AS image_width_6, t0.image_height AS image_height_7, t0.dynamic_content_id AS dynamic_content_id_8 FROM dynamic_content_attribute t0 WHERE t0.id = ?
Parameters:
[
  5
]
31 0.34 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.type AS type_4, t0.hint AS hint_5, t0.image_width AS image_width_6, t0.image_height AS image_height_7, t0.dynamic_content_id AS dynamic_content_id_8 FROM dynamic_content_attribute t0 WHERE t0.id = ?
Parameters:
[
  6
]
32 0.41 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.value AS value_3, t0.type AS type_4, t0.hint AS hint_5, t0.image_width AS image_width_6, t0.image_height AS image_height_7, t0.dynamic_content_id AS dynamic_content_id_8 FROM dynamic_content_attribute t0 WHERE t0.id = ?
Parameters:
[
  7
]
33 1.23 ms
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.code AS code_2, c0_.symbol AS symbol_3, c0_.`default` AS default_4, c0_.deleted AS deleted_5, c0_.deleted_by AS deleted_by_6, c0_.created AS created_7, c0_.creator AS creator_8, c0_.modified AS modified_9, c0_.modified_by AS modified_by_10, c1_.title AS title_11, c1_.symbol AS symbol_12, l2_.id AS id_13, l2_.locale AS locale_14, l2_.title AS title_15, l2_.flag_asset AS flag_asset_16, c1_.translatable_id AS translatable_id_17, c1_.language_id AS language_id_18 FROM currency c0_ LEFT JOIN currency_translation c1_ ON c0_.id = c1_.translatable_id LEFT JOIN language l2_ ON c1_.language_id = l2_.id WHERE c0_.`default` = ? AND c0_.deleted IS NULL GROUP BY c0_.id LIMIT 1
Parameters:
[
  1
]

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
PN\SeoBundle\Entity\Redirect404 No errors.
App\SeoBundle\Entity\Seo No errors.
PN\SeoBundle\Entity\Translation\SeoTranslation No errors.
App\SeoBundle\Entity\Translation\SeoTranslation No errors.
PN\SeoBundle\Entity\SeoBaseRoute No errors.
PN\LocaleBundle\Entity\Language No errors.
PN\SeoBundle\Entity\SeoSocial No errors.
App\ProductBundle\Entity\Category No errors.
App\MediaBundle\Entity\Image No errors.
App\ProductBundle\Entity\Translation\CategoryTranslation No errors.
PN\ContentBundle\Entity\Post No errors.
App\ContentBundle\Entity\Post No errors.
PN\ContentBundle\Entity\Translation\PostTranslation No errors.
App\ContentBundle\Entity\Translation\PostTranslation No errors.
App\ProductBundle\Entity\Attribute No errors.
PN\SeoBundle\Entity\Translation\SeoSocialTranslation No errors.
App\ProductBundle\Entity\Translation\AttributeTranslation No errors.
App\ProductBundle\Entity\SubAttribute No errors.
App\ProductBundle\Entity\ProductHasAttribute No errors.
App\ProductBundle\Entity\Translation\SubAttributeTranslation No errors.
App\ProductBundle\Entity\Product No errors.
App\VendorBundle\Entity\Vendor No errors.
App\VendorBundle\Entity\StoreAddress No errors.
App\ProductBundle\Entity\Brand No errors.
App\CurrencyBundle\Entity\Currency No errors.
App\ThreeSixtyViewBundle\Entity\ThreeSixtyView No errors.
App\ProductBundle\Entity\ProductPrice No errors.
App\ProductBundle\Entity\ProductFavorite No errors.
App\ProductBundle\Entity\Translation\ProductTranslation No errors.
App\ProductBundle\Entity\ProductDetails No errors.
App\ProductBundle\Entity\ProductHasCollection No errors.
App\ProductBundle\Entity\ProductHasOccasion No errors.
App\ECommerceBundle\Entity\CouponHasProduct No errors.
PN\ContentBundle\Entity\DynamicContentAttribute No errors.
PN\ContentBundle\Entity\DynamicContent No errors.
PN\ContentBundle\Entity\Translation\DynamicContentAttributeTranslation No errors.
App\MediaBundle\Entity\Document No errors.
App\VendorBundle\Entity\Translation\VendorTranslation No errors.
App\NewShippingBundle\Entity\Zone No errors.
App\ProductBundle\Entity\Translation\BrandTranslation No errors.
App\CurrencyBundle\Entity\Translation\CurrencyTranslation No errors.
App\UserBundle\Entity\User No errors.
App\ProductBundle\Entity\Collection No errors.
App\ProductBundle\Entity\Occasion No errors.
App\ECommerceBundle\Entity\Coupon No errors.
App\NewShippingBundle\Entity\ShippingZone No errors.
App\NewShippingBundle\Entity\Translation\ZoneTranslation No errors.
App\ProductBundle\Entity\Translation\CollectionTranslation No errors.
App\ProductBundle\Entity\Translation\OccasionTranslation No errors.