Query Metrics
27
Database Queries
16
Different statements
8.41 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.94 ms (23.11%) |
6 |
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
]
|
1.03 ms (12.24%) |
3 |
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
]
|
1.00 ms (11.91%) |
4 |
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"
]
|
0.90 ms (10.74%) |
2 |
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.alias = ? AND t0.lvl = ? LIMIT 1
Parameters:
[ "kamelot" 0 ] |
0.45 ms (5.39%) |
1 |
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_.category_id = ? AND n0_.id IN (?) ORDER BY n0_.showorder ASC
Parameters:
[ 4 [ 14 16 17 15 ] ] |
0.42 ms (5.03%) |
1 |
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"
]
|
0.36 ms (4.23%) |
1 |
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"
]
|
0.34 ms (4.02%) |
1 |
SELECT count(DISTINCT n0_.id) AS sclr_0 FROM nabory n0_ WHERE n0_.status = 1 AND n0_.category_id = ?
Parameters:
[
4
]
|
0.27 ms (3.27%) |
1 |
SELECT t0.id AS id_1, t0.slider AS slider_2, t0.banner AS banner_3, t0.textbeforeslider AS textbeforeslider_4, t0.created AS created_5, t0.updated AS updated_6, t0.category_id AS category_id_7 FROM nabory_category_extension t0 WHERE t0.category_id = ? LIMIT 1
Parameters:
[
4
]
|
0.27 ms (3.23%) |
1 |
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
]
|
0.27 ms (3.16%) |
1 |
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:
[
"kamelot"
]
|
0.25 ms (2.97%) |
1 |
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.id = ?
Parameters:
[
2
]
|
0.25 ms (2.97%) |
1 |
SELECT DISTINCT n0_.id AS id_0, n0_.showorder AS showorder_1 FROM nabory n0_ WHERE n0_.status = 1 AND n0_.category_id = ? ORDER BY n0_.showorder ASC LIMIT 12
Parameters:
[
4
]
|
0.24 ms (2.84%) |
1 |
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.alias = ? LIMIT 1
Parameters:
[
"kamelot"
]
|
0.23 ms (2.69%) |
1 |
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" "rootcat" "rootcat-nabory" "category" "category-nabory" ] ] |
0.19 ms (2.20%) |
1 |
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:
[] |
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\ContentType | No errors. |
Wart\CmsBundle\Entity\BaseField | No errors. |
Wart\CmsBundle\Entity\UniconField | No errors. |
App\Entity\Nabory | No errors. |
App\Entity\NaboryCategoryExtension | No errors. |
App\Entity\Parts | No errors. |
Wart\CmsBundle\Entity\Setting | No errors. |
Wart\CmsBundle\Entity\PageConstructorStorage | No errors. |
App\Entity\Feedback | No errors. |
App\Entity\Pagesliders | No errors. |