https://esorus-shop.woodenizr.com/ar/category

Query Metrics

32 Database Queries
14 Different statements
50.30 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.47 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/ar/category"
]
2 1.42 ms
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.brief AS brief_2, s0_.type AS type_3, s0_.created AS created_4, s0_.creator AS creator_5, s0_.modified AS modified_6, s0_.modified_by AS modified_by_7, s1_.title AS title_8, s1_.slug AS slug_9, s1_.meta_description AS meta_description_10, s1_.focus_keyword AS focus_keyword_11, s1_.meta_keyword AS meta_keyword_12, s1_.meta_tags AS meta_tags_13, s1_.state AS state_14, s1_.last_modified AS last_modified_15, s1_.deleted AS deleted_16, s1_.id AS id_17, s2_.title AS title_18, s2_.slug AS slug_19, s2_.meta_description AS meta_description_20, s2_.focus_keyword AS focus_keyword_21, s2_.meta_keyword AS meta_keyword_22, s2_.meta_tags AS meta_tags_23, s2_.state AS state_24, l3_.id AS id_25, l3_.locale AS locale_26, l3_.title AS title_27, l3_.flag_asset AS flag_asset_28, s4_.id AS id_29, s4_.title AS title_30, s4_.description AS description_31, s4_.image_url AS image_url_32, s4_.social_network AS social_network_33, s0_.seo_id AS seo_id_34, s1_.seo_base_route_id AS seo_base_route_id_35, s2_.translatable_id AS translatable_id_36, s2_.language_id AS language_id_37 FROM seo_page s0_ LEFT JOIN seo s1_ ON s0_.seo_id = s1_.id LEFT JOIN seo_translations s2_ ON s1_.id = s2_.translatable_id LEFT JOIN language l3_ ON s2_.language_id = l3_.id LEFT JOIN seo_seo_social s5_ ON s1_.id = s5_.seo_id LEFT JOIN seo_social s4_ ON s4_.id = s5_.seo_social_id WHERE s0_.type = ?
Parameters:
[
  "categories"
]
3 1.59 ms
SELECT t0.brief AS brief_1, t0.translatable_id AS translatable_id_2, t0.language_id AS language_id_3 FROM seo_page_translations t0 WHERE t0.translatable_id = ?
Parameters:
[
  4
]
4 0.88 ms
SELECT DATABASE()
Parameters:
[]
5 2.30 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "esorus_db"
]
6 0.75 ms
SELECT DATABASE()
Parameters:
[]
7 3.23 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "esorus_db"
]
8 0.67 ms
SELECT DATABASE()
Parameters:
[]
9 2.06 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"
]
10 0.90 ms
SELECT DATABASE()
Parameters:
[]
11 9.44 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"
]
12 5.23 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"
]
13 0.57 ms
SELECT DATABASE()
Parameters:
[]
14 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"
]
15 1.20 ms
SELECT * FROM doctrine_migration_versions
Parameters:
[]
16 1.34 ms
SELECT DATABASE()
Parameters:
[]
17 1.84 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
]
18 1.28 ms
SELECT COUNT(DISTINCT p0_.product_id) AS sclr_0 FROM product_search p0_ LEFT JOIN product p1_ ON p0_.product_id = p1_.id LEFT JOIN product_collection p2_ ON p1_.id = p2_.product_id LEFT JOIN collection c3_ ON p2_.collection_id = c3_.id LEFT JOIN product_occasion p4_ ON p1_.id = p4_.product_id LEFT JOIN occasion o5_ ON p4_.occasion_id = o5_.id LEFT JOIN product_details p6_ ON p1_.id = p6_.product_id LEFT JOIN seo s7_ ON p1_.seo_id = s7_.id LEFT JOIN seo_translations s8_ ON s7_.id = s8_.translatable_id LEFT JOIN product_translations p9_ ON p1_.id = p9_.translatable_id LEFT JOIN post p10_ ON p1_.post_id = p10_.id LEFT JOIN category c11_ ON p1_.category_id = c11_.id LEFT JOIN brand b12_ ON p1_.brand_id = b12_.id LEFT JOIN exchange_rate e13_ ON (e13_.source_currency_id = p0_.currency_id AND e13_.target_currency_id = ?) WHERE p0_.has_offer = ? LIMIT 1
Parameters:
[
  1
  1
]
19 1.56 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
]
20 1.29 ms
SELECT t0.value AS value_1, t0.translatable_id AS translatable_id_2, t0.language_id AS language_id_3 FROM dynamic_content_attribute_translations t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
21 0.92 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
]
22 0.82 ms
SELECT t0.value AS value_1, t0.translatable_id AS translatable_id_2, t0.language_id AS language_id_3 FROM dynamic_content_attribute_translations t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
23 0.67 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
]
24 1.51 ms
SELECT t0.value AS value_1, t0.translatable_id AS translatable_id_2, t0.language_id AS language_id_3 FROM dynamic_content_attribute_translations t0 WHERE t0.translatable_id = ?
Parameters:
[
  3
]
25 1.24 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
]
26 0.45 ms
SELECT t0.value AS value_1, t0.translatable_id AS translatable_id_2, t0.language_id AS language_id_3 FROM dynamic_content_attribute_translations t0 WHERE t0.translatable_id = ?
Parameters:
[
  4
]
27 0.58 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
]
28 0.37 ms
SELECT t0.value AS value_1, t0.translatable_id AS translatable_id_2, t0.language_id AS language_id_3 FROM dynamic_content_attribute_translations t0 WHERE t0.translatable_id = ?
Parameters:
[
  5
]
29 1.53 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
]
30 0.92 ms
SELECT t0.value AS value_1, t0.translatable_id AS translatable_id_2, t0.language_id AS language_id_3 FROM dynamic_content_attribute_translations t0 WHERE t0.translatable_id = ?
Parameters:
[
  6
]
31 0.91 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
]
32 0.58 ms
SELECT t0.value AS value_1, t0.translatable_id AS translatable_id_2, t0.language_id AS language_id_3 FROM dynamic_content_attribute_translations t0 WHERE t0.translatable_id = ?
Parameters:
[
  7
]

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