Query Metrics
23
Database Queries
9
Different statements
7.31 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.value2 AS value2_4 FROM setting t0
Parameters:
[] |
2 | 0.35 ms |
SELECT t0.id AS id_1, t0.page AS page_2, t0.variable AS variable_3, t0.method AS method_4, t0.params AS params_5 FROM page_constructor_storage t0 WHERE t0.page IN (?)
Parameters:
[ [ "all" "main" ] ] |
3 | 0.29 ms |
SELECT t0.id AS id_1, t0.alias AS alias_2, t0.name AS name_3, t0.seo_enabled AS seo_enabled_4, t0.ordered AS ordered_5, t0.status AS status_6, t0.catalog AS catalog_7, t0.paginated AS paginated_8, t0.inpage AS inpage_9, t0.accent AS accent_10, t0.public_api AS public_api_11, t0.sellable AS sellable_12, t0.commentable AS commentable_13, t0.quantitative AS quantitative_14, t0.sort_by_stock AS sort_by_stock_15, t0.category_fields AS category_fields_16, t0.uuid AS uuid_17 FROM content_type t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
"nabory"
]
|
4 | 0.44 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.field_type AS field_type_4, t0.length AS length_5, t0.multiple AS multiple_6, t0.assign_id AS assign_id_7, t0.reference AS reference_8, t0.choice_value AS choice_value_9, t0.sortable AS sortable_10, t0.required AS required_11, t0.property AS property_12, t0.admin_order AS admin_order_13, t0.uuid AS uuid_14, t0.ctype_id AS ctype_id_15, t0.field_entity_type FROM unicon_field t0 WHERE t0.ctype_id = ? AND t0.field_entity_type IN ('unicon') ORDER BY t0.admin_order ASC, t0.id ASC
Parameters:
[
2
]
|
5 | 0.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.lft AS lft_4, t0.lvl AS lvl_5, t0.rgt AS rgt_6, t0.root AS root_7, t0.text AS text_8, t0.addtext AS addtext_9, t0.image AS image_10, t0.seotitle AS seotitle_11, t0.seodescription AS seodescription_12, t0.seokeywords AS seokeywords_13, t0.showorder AS showorder_14, t0.created AS created_15, t0.updated AS updated_16, t0.order_field AS order_field_17, t0.order_direction AS order_direction_18, t0.uuid AS uuid_19, t0.ctype_id AS ctype_id_20, t0.parent_id AS parent_id_21 FROM categories t0 WHERE t0.ctype_id = ?
Parameters:
[
2
]
|
6 | 0.23 ms |
SELECT t0.id AS id_1, t0.alias AS alias_2, t0.name AS name_3, t0.seo_enabled AS seo_enabled_4, t0.ordered AS ordered_5, t0.status AS status_6, t0.catalog AS catalog_7, t0.paginated AS paginated_8, t0.inpage AS inpage_9, t0.accent AS accent_10, t0.public_api AS public_api_11, t0.sellable AS sellable_12, t0.commentable AS commentable_13, t0.quantitative AS quantitative_14, t0.sort_by_stock AS sort_by_stock_15, t0.category_fields AS category_fields_16, t0.uuid AS uuid_17 FROM content_type t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
"nabory"
]
|
7 | 0.49 ms |
SELECT n0_.id AS id_0, n0_.imageincat AS imageincat_1, n0_.link AS link_2, n0_.itemprice AS itemprice_3, n0_.imageonpage AS imageonpage_4, n0_.imageslider AS imageslider_5, n0_.detailcount AS detailcount_6, n0_.detailtext AS detailtext_7, n0_.textbeforeslider AS textbeforeslider_8, n0_.created AS created_9, n0_.updated AS updated_10, n0_.name AS name_11, n0_.alias AS alias_12, n0_.description AS description_13, n0_.showorder AS showorder_14, n0_.status AS status_15, n0_.uuid AS uuid_16, n0_.quantitative AS quantitative_17, n0_.sell_out_of_stock AS sell_out_of_stock_18, n0_.presale AS presale_19, n0_.publish_at AS publish_at_20, n0_.category_id AS category_id_21 FROM nabory n0_ WHERE n0_.status = 1 AND n0_.status = ? ORDER BY n0_.created ASC
Parameters:
[
"1"
]
|
8 | 0.26 ms |
SELECT t0.id AS id_1, t0.alias AS alias_2, t0.name AS name_3, t0.seo_enabled AS seo_enabled_4, t0.ordered AS ordered_5, t0.status AS status_6, t0.catalog AS catalog_7, t0.paginated AS paginated_8, t0.inpage AS inpage_9, t0.accent AS accent_10, t0.public_api AS public_api_11, t0.sellable AS sellable_12, t0.commentable AS commentable_13, t0.quantitative AS quantitative_14, t0.sort_by_stock AS sort_by_stock_15, t0.category_fields AS category_fields_16, t0.uuid AS uuid_17 FROM content_type t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
"feedback"
]
|
9 | 0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.field_type AS field_type_4, t0.length AS length_5, t0.multiple AS multiple_6, t0.assign_id AS assign_id_7, t0.reference AS reference_8, t0.choice_value AS choice_value_9, t0.sortable AS sortable_10, t0.required AS required_11, t0.property AS property_12, t0.admin_order AS admin_order_13, t0.uuid AS uuid_14, t0.ctype_id AS ctype_id_15, t0.field_entity_type FROM unicon_field t0 WHERE t0.ctype_id = ? AND t0.field_entity_type IN ('unicon') ORDER BY t0.admin_order ASC, t0.id ASC
Parameters:
[
5
]
|
10 | 0.39 ms |
SELECT f0_.id AS id_0, f0_.avatar AS avatar_1, f0_.image AS image_2, f0_.created AS created_3, f0_.updated AS updated_4, f0_.name AS name_5, f0_.alias AS alias_6, f0_.description AS description_7, f0_.showorder AS showorder_8, f0_.status AS status_9, f0_.uuid AS uuid_10, f0_.quantitative AS quantitative_11, f0_.sell_out_of_stock AS sell_out_of_stock_12, f0_.presale AS presale_13, f0_.publish_at AS publish_at_14, f0_.category_id AS category_id_15 FROM feedback f0_ WHERE f0_.status = 1 AND f0_.status = ? ORDER BY f0_.created ASC
Parameters:
[
"1"
]
|
11 | 0.43 ms |
SELECT t0.id AS id_1, t0.alias AS alias_2, t0.name AS name_3, t0.seo_enabled AS seo_enabled_4, t0.ordered AS ordered_5, t0.status AS status_6, t0.catalog AS catalog_7, t0.paginated AS paginated_8, t0.inpage AS inpage_9, t0.accent AS accent_10, t0.public_api AS public_api_11, t0.sellable AS sellable_12, t0.commentable AS commentable_13, t0.quantitative AS quantitative_14, t0.sort_by_stock AS sort_by_stock_15, t0.category_fields AS category_fields_16, t0.uuid AS uuid_17 FROM content_type t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
"pagesliders"
]
|
12 | 0.39 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.field_type AS field_type_4, t0.length AS length_5, t0.multiple AS multiple_6, t0.assign_id AS assign_id_7, t0.reference AS reference_8, t0.choice_value AS choice_value_9, t0.sortable AS sortable_10, t0.required AS required_11, t0.property AS property_12, t0.admin_order AS admin_order_13, t0.uuid AS uuid_14, t0.ctype_id AS ctype_id_15, t0.field_entity_type FROM unicon_field t0 WHERE t0.ctype_id = ? AND t0.field_entity_type IN ('unicon') ORDER BY t0.admin_order ASC, t0.id ASC
Parameters:
[
3
]
|
13 | 0.41 ms |
SELECT p0_.id AS id_0, p0_.gallery AS gallery_1, p0_.refalias AS refalias_2, p0_.created AS created_3, p0_.updated AS updated_4, p0_.name AS name_5, p0_.alias AS alias_6, p0_.description AS description_7, p0_.showorder AS showorder_8, p0_.status AS status_9, p0_.uuid AS uuid_10, p0_.quantitative AS quantitative_11, p0_.sell_out_of_stock AS sell_out_of_stock_12, p0_.presale AS presale_13, p0_.publish_at AS publish_at_14, p0_.category_id AS category_id_15 FROM pagesliders p0_ WHERE p0_.status = 1 AND p0_.refalias = ? ORDER BY p0_.created ASC
Parameters:
[
"mainpage"
]
|
14 | 0.33 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.alias AS alias_2, c0_.lft AS lft_3, c0_.lvl AS lvl_4, c0_.rgt AS rgt_5, c0_.root AS root_6, c0_.text AS text_7, c0_.addtext AS addtext_8, c0_.image AS image_9, c0_.seotitle AS seotitle_10, c0_.seodescription AS seodescription_11, c0_.seokeywords AS seokeywords_12, c0_.showorder AS showorder_13, c0_.created AS created_14, c0_.updated AS updated_15, c0_.order_field AS order_field_16, c0_.order_direction AS order_direction_17, c0_.uuid AS uuid_18, c0_.ctype_id AS ctype_id_19, c0_.parent_id AS parent_id_20 FROM categories c0_ WHERE c0_.lft <= 1 AND c0_.rgt >= 2 AND c0_.root = ? ORDER BY c0_.lft ASC
Parameters:
[
2
]
|
15 | 0.29 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.alias AS alias_2, c0_.lft AS lft_3, c0_.lvl AS lvl_4, c0_.rgt AS rgt_5, c0_.root AS root_6, c0_.text AS text_7, c0_.addtext AS addtext_8, c0_.image AS image_9, c0_.seotitle AS seotitle_10, c0_.seodescription AS seodescription_11, c0_.seokeywords AS seokeywords_12, c0_.showorder AS showorder_13, c0_.created AS created_14, c0_.updated AS updated_15, c0_.order_field AS order_field_16, c0_.order_direction AS order_direction_17, c0_.uuid AS uuid_18, c0_.ctype_id AS ctype_id_19, c0_.parent_id AS parent_id_20 FROM categories c0_ WHERE c0_.lft <= 1 AND c0_.rgt >= 2 AND c0_.root = ? ORDER BY c0_.lft ASC
Parameters:
[
2
]
|
16 | 0.27 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.alias AS alias_2, c0_.lft AS lft_3, c0_.lvl AS lvl_4, c0_.rgt AS rgt_5, c0_.root AS root_6, c0_.text AS text_7, c0_.addtext AS addtext_8, c0_.image AS image_9, c0_.seotitle AS seotitle_10, c0_.seodescription AS seodescription_11, c0_.seokeywords AS seokeywords_12, c0_.showorder AS showorder_13, c0_.created AS created_14, c0_.updated AS updated_15, c0_.order_field AS order_field_16, c0_.order_direction AS order_direction_17, c0_.uuid AS uuid_18, c0_.ctype_id AS ctype_id_19, c0_.parent_id AS parent_id_20 FROM categories c0_ WHERE c0_.lft <= 1 AND c0_.rgt >= 2 AND c0_.root = ? ORDER BY c0_.lft ASC
Parameters:
[
2
]
|
17 | 0.30 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.alias AS alias_2, c0_.lft AS lft_3, c0_.lvl AS lvl_4, c0_.rgt AS rgt_5, c0_.root AS root_6, c0_.text AS text_7, c0_.addtext AS addtext_8, c0_.image AS image_9, c0_.seotitle AS seotitle_10, c0_.seodescription AS seodescription_11, c0_.seokeywords AS seokeywords_12, c0_.showorder AS showorder_13, c0_.created AS created_14, c0_.updated AS updated_15, c0_.order_field AS order_field_16, c0_.order_direction AS order_direction_17, c0_.uuid AS uuid_18, c0_.ctype_id AS ctype_id_19, c0_.parent_id AS parent_id_20 FROM categories c0_ WHERE c0_.lft <= 1 AND c0_.rgt >= 2 AND c0_.root = ? ORDER BY c0_.lft ASC
Parameters:
[
2
]
|
18 | 0.27 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.alias AS alias_2, c0_.lft AS lft_3, c0_.lvl AS lvl_4, c0_.rgt AS rgt_5, c0_.root AS root_6, c0_.text AS text_7, c0_.addtext AS addtext_8, c0_.image AS image_9, c0_.seotitle AS seotitle_10, c0_.seodescription AS seodescription_11, c0_.seokeywords AS seokeywords_12, c0_.showorder AS showorder_13, c0_.created AS created_14, c0_.updated AS updated_15, c0_.order_field AS order_field_16, c0_.order_direction AS order_direction_17, c0_.uuid AS uuid_18, c0_.ctype_id AS ctype_id_19, c0_.parent_id AS parent_id_20 FROM categories c0_ WHERE c0_.lft <= 1 AND c0_.rgt >= 2 AND c0_.root = ? ORDER BY c0_.lft ASC
Parameters:
[
3
]
|
19 | 0.27 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.alias AS alias_2, c0_.lft AS lft_3, c0_.lvl AS lvl_4, c0_.rgt AS rgt_5, c0_.root AS root_6, c0_.text AS text_7, c0_.addtext AS addtext_8, c0_.image AS image_9, c0_.seotitle AS seotitle_10, c0_.seodescription AS seodescription_11, c0_.seokeywords AS seokeywords_12, c0_.showorder AS showorder_13, c0_.created AS created_14, c0_.updated AS updated_15, c0_.order_field AS order_field_16, c0_.order_direction AS order_direction_17, c0_.uuid AS uuid_18, c0_.ctype_id AS ctype_id_19, c0_.parent_id AS parent_id_20 FROM categories c0_ WHERE c0_.lft <= 1 AND c0_.rgt >= 2 AND c0_.root = ? ORDER BY c0_.lft ASC
Parameters:
[
3
]
|
20 | 0.27 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.alias AS alias_2, c0_.lft AS lft_3, c0_.lvl AS lvl_4, c0_.rgt AS rgt_5, c0_.root AS root_6, c0_.text AS text_7, c0_.addtext AS addtext_8, c0_.image AS image_9, c0_.seotitle AS seotitle_10, c0_.seodescription AS seodescription_11, c0_.seokeywords AS seokeywords_12, c0_.showorder AS showorder_13, c0_.created AS created_14, c0_.updated AS updated_15, c0_.order_field AS order_field_16, c0_.order_direction AS order_direction_17, c0_.uuid AS uuid_18, c0_.ctype_id AS ctype_id_19, c0_.parent_id AS parent_id_20 FROM categories c0_ WHERE c0_.lft <= 1 AND c0_.rgt >= 2 AND c0_.root = ? ORDER BY c0_.lft ASC
Parameters:
[
4
]
|
21 | 0.25 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.alias AS alias_2, c0_.lft AS lft_3, c0_.lvl AS lvl_4, c0_.rgt AS rgt_5, c0_.root AS root_6, c0_.text AS text_7, c0_.addtext AS addtext_8, c0_.image AS image_9, c0_.seotitle AS seotitle_10, c0_.seodescription AS seodescription_11, c0_.seokeywords AS seokeywords_12, c0_.showorder AS showorder_13, c0_.created AS created_14, c0_.updated AS updated_15, c0_.order_field AS order_field_16, c0_.order_direction AS order_direction_17, c0_.uuid AS uuid_18, c0_.ctype_id AS ctype_id_19, c0_.parent_id AS parent_id_20 FROM categories c0_ WHERE c0_.lft <= 1 AND c0_.rgt >= 2 AND c0_.root = ? ORDER BY c0_.lft ASC
Parameters:
[
4
]
|
22 | 0.26 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.alias AS alias_2, c0_.lft AS lft_3, c0_.lvl AS lvl_4, c0_.rgt AS rgt_5, c0_.root AS root_6, c0_.text AS text_7, c0_.addtext AS addtext_8, c0_.image AS image_9, c0_.seotitle AS seotitle_10, c0_.seodescription AS seodescription_11, c0_.seokeywords AS seokeywords_12, c0_.showorder AS showorder_13, c0_.created AS created_14, c0_.updated AS updated_15, c0_.order_field AS order_field_16, c0_.order_direction AS order_direction_17, c0_.uuid AS uuid_18, c0_.ctype_id AS ctype_id_19, c0_.parent_id AS parent_id_20 FROM categories c0_ WHERE c0_.lft <= 1 AND c0_.rgt >= 2 AND c0_.root = ? ORDER BY c0_.lft ASC
Parameters:
[
4
]
|
23 | 0.25 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.alias AS alias_2, c0_.lft AS lft_3, c0_.lvl AS lvl_4, c0_.rgt AS rgt_5, c0_.root AS root_6, c0_.text AS text_7, c0_.addtext AS addtext_8, c0_.image AS image_9, c0_.seotitle AS seotitle_10, c0_.seodescription AS seodescription_11, c0_.seokeywords AS seokeywords_12, c0_.showorder AS showorder_13, c0_.created AS created_14, c0_.updated AS updated_15, c0_.order_field AS order_field_16, c0_.order_direction AS order_direction_17, c0_.uuid AS uuid_18, c0_.ctype_id AS ctype_id_19, c0_.parent_id AS parent_id_20 FROM categories c0_ WHERE c0_.lft <= 1 AND c0_.rgt >= 2 AND c0_.root = ? ORDER BY c0_.lft ASC
Parameters:
[
4
]
|
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 |
---|---|
Wart\CmsBundle\Entity\Category | No errors. |
Wart\CmsBundle\Entity\Setting | No errors. |
Wart\CmsBundle\Entity\PageConstructorStorage | No errors. |
Wart\CmsBundle\Entity\ContentType | No errors. |
Wart\CmsBundle\Entity\BaseField | No errors. |
Wart\CmsBundle\Entity\UniconField | No errors. |
App\Entity\Nabory | No errors. |
App\Entity\Parts | No errors. |
App\Entity\Feedback | No errors. |
App\Entity\Pagesliders | No errors. |