Query Metrics
32
Database Queries
16
Different statements
10.25 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.71 ms (26.39%) |
10 |
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
]
|
1.19 ms (11.63%) |
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.06 ms (10.29%) |
2 |
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_ LEFT JOIN categories c1_ ON (c0_.root = c1_.id), categories c2_ WHERE c0_.alias = ? AND c0_.lvl = ? AND c1_.alias = ? LIMIT 1
Parameters:
[ "de-vallen" 1 "amsterdam" ] |
0.95 ms (9.23%) |
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.53 ms (5.17%) |
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:
[ "amsterdam" 0 ] |
0.44 ms (4.27%) |
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 = ? ORDER BY n0_.created ASC
Parameters:
[
2
]
|
0.43 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.43 ms (4.20%) |
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.43 ms (4.20%) |
1 |
SELECT t0.id AS id_1, t0.height AS height_2, t0.width AS width_3, t0.weight AS weight_4, t0.image AS image_5, t0.created AS created_6, t0.updated AS updated_7, t0.name AS name_8, t0.alias AS alias_9, t0.description AS description_10, t0.showorder AS showorder_11, t0.status AS status_12, t0.uuid AS uuid_13, t0.quantitative AS quantitative_14, t0.sell_out_of_stock AS sell_out_of_stock_15, t0.presale AS presale_16, t0.publish_at AS publish_at_17, t0.category_id AS category_id_18 FROM parts t0 INNER JOIN nabory_parts ON t0.id = nabory_parts.parts_id WHERE nabory_parts.nabory_id = ?
Parameters:
[
11
]
|
0.41 ms (4.03%) |
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:
[
"amsterdam"
]
|
0.34 ms (3.29%) |
1 |
SELECT t0.id AS id_1, t0.imageincat AS imageincat_2, t0.link AS link_3, t0.itemprice AS itemprice_4, t0.imageonpage AS imageonpage_5, t0.imageslider AS imageslider_6, t0.detailcount AS detailcount_7, t0.detailtext AS detailtext_8, t0.textbeforeslider AS textbeforeslider_9, t0.created AS created_10, t0.updated AS updated_11, t0.name AS name_12, t0.alias AS alias_13, t0.description AS description_14, t0.showorder AS showorder_15, t0.status AS status_16, t0.uuid AS uuid_17, t0.quantitative AS quantitative_18, t0.sell_out_of_stock AS sell_out_of_stock_19, t0.presale AS presale_20, t0.publish_at AS publish_at_21, t0.category_id AS category_id_22 FROM nabory t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
"de-vallen"
]
|
0.32 ms (3.14%) |
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" "material" "material-nabory" ] ] |
0.29 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.ctype_id = ?
Parameters:
[
2
]
|
0.28 ms (2.74%) |
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.26 ms (2.54%) |
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:
[
"amsterdam"
]
|
0.19 ms (1.80%) |
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\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. |
Wart\CmsBundle\Entity\UniconReferenceStorage | No errors. |