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

Query Metrics

58 Database Queries
15 Different statements
83.94 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.74 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/"
]
2 1.59 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:
[
  "home-page"
]
3 0.94 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:
[
  1
]
4 1.60 ms
SELECT -b0_.tarteb AS sclr_0, b0_.id AS id_1, b0_.title AS title_2, b0_.sub_title AS sub_title_3, b0_.placement AS placement_4, b0_.placementName AS placementName_5, b0_.url AS url_6, b0_.text AS text_7, b0_.action_button_name AS action_button_name_8, b0_.action_button_position AS action_button_position_9, b0_.tarteb AS tarteb_10, b0_.publish AS publish_11, b0_.openInNewTab AS openInNewTab_12, b0_.created AS created_13, b0_.creator AS creator_14, b0_.modified AS modified_15, b0_.modified_by AS modified_by_16, i1_.name AS name_17, i1_.base_path AS base_path_18, i1_.alt AS alt_19, i1_.width AS width_20, i1_.height AS height_21, i1_.size AS size_22, i1_.tarteb AS tarteb_23, i1_.image_type AS image_type_24, i1_.created AS created_25, i1_.id AS id_26, b2_.title AS title_27, b2_.sub_title AS sub_title_28, b2_.url AS url_29, b2_.text AS text_30, b2_.actionButton AS actionButton_31, l3_.id AS id_32, l3_.locale AS locale_33, l3_.title AS title_34, l3_.flag_asset AS flag_asset_35, b0_.image_id AS image_id_36, b2_.translatable_id AS translatable_id_37, b2_.language_id AS language_id_38 FROM banner b0_ LEFT JOIN image i1_ ON b0_.image_id = i1_.id LEFT JOIN banner_translations b2_ ON b0_.id = b2_.translatable_id LEFT JOIN language l3_ ON b2_.language_id = l3_.id WHERE b0_.image_id IS NOT NULL AND b0_.placement = ? AND b0_.publish = ? ORDER BY RAND() ASC LIMIT 6
Parameters:
[
  1
  1
]
5 0.95 ms
SELECT DATABASE()
Parameters:
[]
6 2.40 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "esorus_db"
]
7 0.36 ms
SELECT DATABASE()
Parameters:
[]
8 1.84 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "esorus_db"
]
9 0.37 ms
SELECT DATABASE()
Parameters:
[]
10 2.11 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"
]
11 1.05 ms
SELECT DATABASE()
Parameters:
[]
12 3.05 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"
]
13 4.55 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"
]
14 0.74 ms
SELECT DATABASE()
Parameters:
[]
15 1.27 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"
]
16 0.57 ms
SELECT * FROM doctrine_migration_versions
Parameters:
[]
17 2.31 ms
SELECT DATABASE()
Parameters:
[]
18 1.08 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:
[
  8
]
19 2.25 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:
[
  8
]
20 1.16 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 dynamic_content_attribute_image ON t0.id = dynamic_content_attribute_image.image_id WHERE dynamic_content_attribute_image.dynamic_content_attribute_id = ?
Parameters:
[
  8
]
21 2.78 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:
[
  11
]
22 1.13 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:
[
  11
]
23 1.31 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:
[
  12
]
24 0.80 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:
[
  12
]
25 1.17 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 dynamic_content_attribute_image ON t0.id = dynamic_content_attribute_image.image_id WHERE dynamic_content_attribute_image.dynamic_content_attribute_id = ?
Parameters:
[
  12
]
26 2.25 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:
[
  13
]
27 1.76 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:
[
  13
]
28 0.84 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:
[
  14
]
29 0.89 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:
[
  14
]
30 0.80 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:
[
  15
]
31 1.20 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:
[
  15
]
32 1.75 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 dynamic_content_attribute_image ON t0.id = dynamic_content_attribute_image.image_id WHERE dynamic_content_attribute_image.dynamic_content_attribute_id = ?
Parameters:
[
  15
]
33 1.28 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:
[
  16
]
34 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:
[
  16
]
35 1.06 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:
[
  17
]
36 0.65 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:
[
  17
]
37 0.78 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:
[
  18
]
38 0.66 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:
[
  18
]
39 1.10 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 dynamic_content_attribute_image ON t0.id = dynamic_content_attribute_image.image_id WHERE dynamic_content_attribute_image.dynamic_content_attribute_id = ?
Parameters:
[
  18
]
40 1.85 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:
[
  19
]
41 10.71 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:
[
  19
]
42 2.16 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:
[
  20
]
43 0.91 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:
[
  20
]
44 1.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:
[
  2
]
45 0.90 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
]
46 1.18 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
]
47 1.00 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
]
48 0.76 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
]
49 1.16 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
]
50 0.79 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
]
51 0.90 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
]
52 1.31 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
]
53 0.42 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
]
54 0.38 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
]
55 0.76 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
]
56 0.66 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
]
57 0.38 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
]
58 1.54 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.