Query Metrics
107
Database Queries
13
Different statements
24.51 ms
Query time
10
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.69 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.conversion_rate AS conversion_rate_4, t0.rounding AS rounding_5, t0.is_default AS is_default_6 FROM currency t0 WHERE t0.is_default = ? LIMIT 1
Parameters:
[
1
]
|
2 | 0.42 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.html AS html_5, t0.title AS title_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.javascript AS javascript_9, t0.sequence AS sequence_10, t0.is_menu AS is_menu_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.state AS state_14, t0.has_comments AS has_comments_15, t0.is_indexable AS is_indexable_16, t0.is_xml_exportable AS is_xml_exportable_17, t0.created_at AS created_at_18, t0.category_type_id AS category_type_id_19, t0.upload_id AS upload_id_20 FROM p_category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"protektorat-cechy-a-morava-19391945"
]
|
3 | 0.31 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "154" "cs" "App\Entity\Project\Category" ] |
4 | 0.25 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.category_super_id AS category_super_id_4, t0.category_sub_id AS category_sub_id_5 FROM p_category_category t0 WHERE t0.category_super_id = ? ORDER BY t0.sequence ASC
Parameters:
[
154
]
|
5 | 0.92 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.title AS title_4, p0_.slug AS slug_5, p0_.is_active AS is_active_6, p0_.sequence AS sequence_7, p0_.javascript AS javascript_8, p0_.text_general AS text_general_9, p0_.state AS state_10, p0_.is_indexable AS is_indexable_11, p0_.external_id AS external_id_12, p0_.producer_id AS producer_id_13, p0_.upload_id AS upload_id_14, p0_.product_type_id AS product_type_id_15 FROM product p0_ LEFT JOIN category_product c1_ ON p0_.id = c1_.product_id WHERE (c1_.category_id IN (?) AND p0_.is_active = ?) AND (p0_.is_active = 1)
Parameters:
[ 154 1 ] |
6 | 0.25 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "1104" "cs" "App\Entity\Project\Product" ] |
7 | 0.24 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "1084" "cs" "App\Entity\Project\Product" ] |
8 | 0.24 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "1042" "cs" "App\Entity\Project\Product" ] |
9 | 0.24 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "1040" "cs" "App\Entity\Project\Product" ] |
10 | 0.21 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "1007" "cs" "App\Entity\Project\Product" ] |
11 | 0.21 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "740" "cs" "App\Entity\Project\Product" ] |
12 | 0.20 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "973" "cs" "App\Entity\Project\Product" ] |
13 | 0.20 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "930" "cs" "App\Entity\Project\Product" ] |
14 | 0.20 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "925" "cs" "App\Entity\Project\Product" ] |
15 | 0.20 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "922" "cs" "App\Entity\Project\Product" ] |
16 | 0.19 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "811" "cs" "App\Entity\Project\Product" ] |
17 | 0.19 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "807" "cs" "App\Entity\Project\Product" ] |
18 | 0.23 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "777" "cs" "App\Entity\Project\Product" ] |
19 | 0.23 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "774" "cs" "App\Entity\Project\Product" ] |
20 | 0.20 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "772" "cs" "App\Entity\Project\Product" ] |
21 | 0.20 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "766" "cs" "App\Entity\Project\Product" ] |
22 | 0.20 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "762" "cs" "App\Entity\Project\Product" ] |
23 | 0.20 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "711" "cs" "App\Entity\Project\Product" ] |
24 | 0.21 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "638" "cs" "App\Entity\Project\Product" ] |
25 | 0.20 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "898" "cs" "App\Entity\Project\Product" ] |
26 | 0.21 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "1154" "cs" "App\Entity\Project\Product" ] |
27 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.is_active AS is_active_6, t0.product_id AS product_id_7, t0.colour_id AS colour_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10, t0.product_type_id AS product_type_id_11 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
1104
]
|
28 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.is_active AS is_active_6, t0.product_id AS product_id_7, t0.colour_id AS colour_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10, t0.product_type_id AS product_type_id_11 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
811
]
|
29 | 0.21 ms |
SELECT t0.id AS id_1, t0.data AS data_2, t0.sequence AS sequence_3, t0.parameter_group_id AS parameter_group_id_4, t0.category_id AS category_id_5, t0.product_variant_id AS product_variant_id_6, t0.person_id AS person_id_7 FROM parameter t0 WHERE t0.product_variant_id = ?
Parameters:
[
563
]
|
30 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.is_product_parameter AS is_product_parameter_4, t0.is_filter AS is_filter_5, t0.type_id AS type_id_6 FROM parameter_group t0 WHERE t0.id = ?
Parameters:
[
1
]
|
31 | 0.22 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "1" "cs" "App\Entity\Project\ParameterGroup" ] |
32 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.is_product_parameter AS is_product_parameter_4, t0.is_filter AS is_filter_5, t0.type_id AS type_id_6 FROM parameter_group t0 WHERE t0.id = ?
Parameters:
[
2
]
|
33 | 0.21 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "2" "cs" "App\Entity\Project\ParameterGroup" ] |
34 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.is_product_parameter AS is_product_parameter_4, t0.is_filter AS is_filter_5, t0.type_id AS type_id_6 FROM parameter_group t0 WHERE t0.id = ?
Parameters:
[
28
]
|
35 | 0.20 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "28" "cs" "App\Entity\Project\ParameterGroup" ] |
36 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.is_product_parameter AS is_product_parameter_4, t0.is_filter AS is_filter_5, t0.type_id AS type_id_6 FROM parameter_group t0 WHERE t0.id = ?
Parameters:
[
27
]
|
37 | 0.21 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "27" "cs" "App\Entity\Project\ParameterGroup" ] |
38 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.is_product_parameter AS is_product_parameter_4, t0.is_filter AS is_filter_5, t0.type_id AS type_id_6 FROM parameter_group t0 WHERE t0.id = ?
Parameters:
[
32
]
|
39 | 0.21 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "32" "cs" "App\Entity\Project\ParameterGroup" ] |
40 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.is_product_parameter AS is_product_parameter_4, t0.is_filter AS is_filter_5, t0.type_id AS type_id_6 FROM parameter_group t0 WHERE t0.id = ?
Parameters:
[
31
]
|
41 | 0.22 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "31" "cs" "App\Entity\Project\ParameterGroup" ] |
42 | 0.19 ms |
SELECT t0.id AS id_1, t0.data AS data_2, t0.sequence AS sequence_3, t0.parameter_group_id AS parameter_group_id_4, t0.category_id AS category_id_5, t0.product_variant_id AS product_variant_id_6, t0.person_id AS person_id_7 FROM parameter t0 WHERE t0.product_variant_id = ?
Parameters:
[
270
]
|
43 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.is_product_parameter AS is_product_parameter_4, t0.is_filter AS is_filter_5, t0.type_id AS type_id_6 FROM parameter_group t0 WHERE t0.id = ?
Parameters:
[
8
]
|
44 | 0.21 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "8" "cs" "App\Entity\Project\ParameterGroup" ] |
45 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.is_active AS is_active_6, t0.product_id AS product_id_7, t0.colour_id AS colour_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10, t0.product_type_id AS product_type_id_11 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
1154
]
|
46 | 0.19 ms |
SELECT t0.id AS id_1, t0.data AS data_2, t0.sequence AS sequence_3, t0.parameter_group_id AS parameter_group_id_4, t0.category_id AS category_id_5, t0.product_variant_id AS product_variant_id_6, t0.person_id AS person_id_7 FROM parameter t0 WHERE t0.product_variant_id = ?
Parameters:
[
632
]
|
47 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.is_active AS is_active_6, t0.product_id AS product_id_7, t0.colour_id AS colour_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10, t0.product_type_id AS product_type_id_11 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
1042
]
|
48 | 0.20 ms |
SELECT t0.id AS id_1, t0.data AS data_2, t0.sequence AS sequence_3, t0.parameter_group_id AS parameter_group_id_4, t0.category_id AS category_id_5, t0.product_variant_id AS product_variant_id_6, t0.person_id AS person_id_7 FROM parameter t0 WHERE t0.product_variant_id = ?
Parameters:
[
501
]
|
49 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.is_active AS is_active_6, t0.product_id AS product_id_7, t0.colour_id AS colour_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10, t0.product_type_id AS product_type_id_11 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
1040
]
|
50 | 0.18 ms |
SELECT t0.id AS id_1, t0.data AS data_2, t0.sequence AS sequence_3, t0.parameter_group_id AS parameter_group_id_4, t0.category_id AS category_id_5, t0.product_variant_id AS product_variant_id_6, t0.person_id AS person_id_7 FROM parameter t0 WHERE t0.product_variant_id = ?
Parameters:
[
499
]
|
51 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.is_product_parameter AS is_product_parameter_4, t0.is_filter AS is_filter_5, t0.type_id AS type_id_6 FROM parameter_group t0 WHERE t0.id = ?
Parameters:
[
3
]
|
52 | 0.21 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "3" "cs" "App\Entity\Project\ParameterGroup" ] |
53 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.is_active AS is_active_6, t0.product_id AS product_id_7, t0.colour_id AS colour_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10, t0.product_type_id AS product_type_id_11 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
1007
]
|
54 | 0.20 ms |
SELECT t0.id AS id_1, t0.data AS data_2, t0.sequence AS sequence_3, t0.parameter_group_id AS parameter_group_id_4, t0.category_id AS category_id_5, t0.product_variant_id AS product_variant_id_6, t0.person_id AS person_id_7 FROM parameter t0 WHERE t0.product_variant_id = ?
Parameters:
[
466
]
|
55 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.is_active AS is_active_6, t0.product_id AS product_id_7, t0.colour_id AS colour_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10, t0.product_type_id AS product_type_id_11 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
740
]
|
56 | 0.19 ms |
SELECT t0.id AS id_1, t0.data AS data_2, t0.sequence AS sequence_3, t0.parameter_group_id AS parameter_group_id_4, t0.category_id AS category_id_5, t0.product_variant_id AS product_variant_id_6, t0.person_id AS person_id_7 FROM parameter t0 WHERE t0.product_variant_id = ?
Parameters:
[
199
]
|
57 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.is_active AS is_active_6, t0.product_id AS product_id_7, t0.colour_id AS colour_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10, t0.product_type_id AS product_type_id_11 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
973
]
|
58 | 0.19 ms |
SELECT t0.id AS id_1, t0.data AS data_2, t0.sequence AS sequence_3, t0.parameter_group_id AS parameter_group_id_4, t0.category_id AS category_id_5, t0.product_variant_id AS product_variant_id_6, t0.person_id AS person_id_7 FROM parameter t0 WHERE t0.product_variant_id = ?
Parameters:
[
432
]
|
59 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.is_active AS is_active_6, t0.product_id AS product_id_7, t0.colour_id AS colour_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10, t0.product_type_id AS product_type_id_11 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
930
]
|
60 | 0.19 ms |
SELECT t0.id AS id_1, t0.data AS data_2, t0.sequence AS sequence_3, t0.parameter_group_id AS parameter_group_id_4, t0.category_id AS category_id_5, t0.product_variant_id AS product_variant_id_6, t0.person_id AS person_id_7 FROM parameter t0 WHERE t0.product_variant_id = ?
Parameters:
[
389
]
|
61 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.is_active AS is_active_6, t0.product_id AS product_id_7, t0.colour_id AS colour_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10, t0.product_type_id AS product_type_id_11 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
925
]
|
62 | 0.19 ms |
SELECT t0.id AS id_1, t0.data AS data_2, t0.sequence AS sequence_3, t0.parameter_group_id AS parameter_group_id_4, t0.category_id AS category_id_5, t0.product_variant_id AS product_variant_id_6, t0.person_id AS person_id_7 FROM parameter t0 WHERE t0.product_variant_id = ?
Parameters:
[
384
]
|
63 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.is_active AS is_active_6, t0.product_id AS product_id_7, t0.colour_id AS colour_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10, t0.product_type_id AS product_type_id_11 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
922
]
|
64 | 0.19 ms |
SELECT t0.id AS id_1, t0.data AS data_2, t0.sequence AS sequence_3, t0.parameter_group_id AS parameter_group_id_4, t0.category_id AS category_id_5, t0.product_variant_id AS product_variant_id_6, t0.person_id AS person_id_7 FROM parameter t0 WHERE t0.product_variant_id = ?
Parameters:
[
381
]
|
65 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.is_active AS is_active_6, t0.product_id AS product_id_7, t0.colour_id AS colour_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10, t0.product_type_id AS product_type_id_11 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
1084
]
|
66 | 0.19 ms |
SELECT t0.id AS id_1, t0.data AS data_2, t0.sequence AS sequence_3, t0.parameter_group_id AS parameter_group_id_4, t0.category_id AS category_id_5, t0.product_variant_id AS product_variant_id_6, t0.person_id AS person_id_7 FROM parameter t0 WHERE t0.product_variant_id = ?
Parameters:
[
543
]
|
67 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.is_active AS is_active_6, t0.product_id AS product_id_7, t0.colour_id AS colour_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10, t0.product_type_id AS product_type_id_11 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
807
]
|
68 | 0.19 ms |
SELECT t0.id AS id_1, t0.data AS data_2, t0.sequence AS sequence_3, t0.parameter_group_id AS parameter_group_id_4, t0.category_id AS category_id_5, t0.product_variant_id AS product_variant_id_6, t0.person_id AS person_id_7 FROM parameter t0 WHERE t0.product_variant_id = ?
Parameters:
[
266
]
|
69 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.is_active AS is_active_6, t0.product_id AS product_id_7, t0.colour_id AS colour_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10, t0.product_type_id AS product_type_id_11 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
777
]
|
70 | 0.19 ms |
SELECT t0.id AS id_1, t0.data AS data_2, t0.sequence AS sequence_3, t0.parameter_group_id AS parameter_group_id_4, t0.category_id AS category_id_5, t0.product_variant_id AS product_variant_id_6, t0.person_id AS person_id_7 FROM parameter t0 WHERE t0.product_variant_id = ?
Parameters:
[
236
]
|
71 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.is_active AS is_active_6, t0.product_id AS product_id_7, t0.colour_id AS colour_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10, t0.product_type_id AS product_type_id_11 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
774
]
|
72 | 0.19 ms |
SELECT t0.id AS id_1, t0.data AS data_2, t0.sequence AS sequence_3, t0.parameter_group_id AS parameter_group_id_4, t0.category_id AS category_id_5, t0.product_variant_id AS product_variant_id_6, t0.person_id AS person_id_7 FROM parameter t0 WHERE t0.product_variant_id = ?
Parameters:
[
233
]
|
73 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.is_active AS is_active_6, t0.product_id AS product_id_7, t0.colour_id AS colour_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10, t0.product_type_id AS product_type_id_11 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
772
]
|
74 | 0.19 ms |
SELECT t0.id AS id_1, t0.data AS data_2, t0.sequence AS sequence_3, t0.parameter_group_id AS parameter_group_id_4, t0.category_id AS category_id_5, t0.product_variant_id AS product_variant_id_6, t0.person_id AS person_id_7 FROM parameter t0 WHERE t0.product_variant_id = ?
Parameters:
[
231
]
|
75 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.is_active AS is_active_6, t0.product_id AS product_id_7, t0.colour_id AS colour_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10, t0.product_type_id AS product_type_id_11 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
766
]
|
76 | 0.19 ms |
SELECT t0.id AS id_1, t0.data AS data_2, t0.sequence AS sequence_3, t0.parameter_group_id AS parameter_group_id_4, t0.category_id AS category_id_5, t0.product_variant_id AS product_variant_id_6, t0.person_id AS person_id_7 FROM parameter t0 WHERE t0.product_variant_id = ?
Parameters:
[
225
]
|
77 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.is_active AS is_active_6, t0.product_id AS product_id_7, t0.colour_id AS colour_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10, t0.product_type_id AS product_type_id_11 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
762
]
|
78 | 0.19 ms |
SELECT t0.id AS id_1, t0.data AS data_2, t0.sequence AS sequence_3, t0.parameter_group_id AS parameter_group_id_4, t0.category_id AS category_id_5, t0.product_variant_id AS product_variant_id_6, t0.person_id AS person_id_7 FROM parameter t0 WHERE t0.product_variant_id = ?
Parameters:
[
221
]
|
79 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.is_active AS is_active_6, t0.product_id AS product_id_7, t0.colour_id AS colour_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10, t0.product_type_id AS product_type_id_11 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
711
]
|
80 | 0.19 ms |
SELECT t0.id AS id_1, t0.data AS data_2, t0.sequence AS sequence_3, t0.parameter_group_id AS parameter_group_id_4, t0.category_id AS category_id_5, t0.product_variant_id AS product_variant_id_6, t0.person_id AS person_id_7 FROM parameter t0 WHERE t0.product_variant_id = ?
Parameters:
[
170
]
|
81 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.is_active AS is_active_6, t0.product_id AS product_id_7, t0.colour_id AS colour_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10, t0.product_type_id AS product_type_id_11 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
638
]
|
82 | 0.22 ms |
SELECT t0.id AS id_1, t0.data AS data_2, t0.sequence AS sequence_3, t0.parameter_group_id AS parameter_group_id_4, t0.category_id AS category_id_5, t0.product_variant_id AS product_variant_id_6, t0.person_id AS person_id_7 FROM parameter t0 WHERE t0.product_variant_id = ?
Parameters:
[
97
]
|
83 | 0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.stock AS stock_3, t0.external_id AS external_id_4, t0.avg_restock_days AS avg_restock_days_5, t0.is_active AS is_active_6, t0.product_id AS product_id_7, t0.colour_id AS colour_id_8, t0.availability_id AS availability_id_9, t0.upload_id AS upload_id_10, t0.product_type_id AS product_type_id_11 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
898
]
|
84 | 0.23 ms |
SELECT t0.id AS id_1, t0.data AS data_2, t0.sequence AS sequence_3, t0.parameter_group_id AS parameter_group_id_4, t0.category_id AS category_id_5, t0.product_variant_id AS product_variant_id_6, t0.person_id AS person_id_7 FROM parameter t0 WHERE t0.product_variant_id = ?
Parameters:
[
357
]
|
85 | 0.50 ms |
SELECT COUNT(p0_.id) AS sclr_0 FROM parameter p0_ LEFT JOIN parameter_group p1_ ON p0_.parameter_group_id = p1_.id LEFT JOIN product_variant p2_ ON p0_.product_variant_id = p2_.id WHERE p1_.name = ? AND p2_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "Číslo svazku" 1154 1104 1040 1084 1042 1007 898 922 925 930 774 740 711 811 973 638 762 807 766 777 772 ] |
86 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3, t0.controller_name AS controller_name_4 FROM menu_type t0 WHERE t0.id = ?
Parameters:
[
"4"
]
|
87 | 0.58 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.is_xml_exportable AS is_xml_exportable_16, p0_.created_at AS created_at_17, p0_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN category_menu_type c2_ ON p0_.id = c2_.category_id LEFT JOIN menu_type m1_ ON m1_.id = c2_.menu_type_id LEFT JOIN p_category_category p3_ ON p0_.id = p3_.category_sub_id WHERE p0_.is_active = ? AND p0_.id >= ? AND m1_.id = ? AND p3_.id IS NULL ORDER BY p0_.sequence ASC
Parameters:
[ 1 2 4 ] |
88 | 0.21 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "2" "cs" "App\Entity\Project\Category" ] |
89 | 0.20 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "655" "cs" "App\Entity\Project\Category" ] |
90 | 0.23 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "72" "cs" "App\Entity\Project\Category" ] |
91 | 0.23 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "190" "cs" "App\Entity\Project\Category" ] |
92 | 0.20 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "73" "cs" "App\Entity\Project\Category" ] |
93 | 0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3, t0.controller_name AS controller_name_4 FROM menu_type t0 WHERE t0.id = ?
Parameters:
[
"1"
]
|
94 | 0.68 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.is_xml_exportable AS is_xml_exportable_16, p0_.created_at AS created_at_17, p0_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN category_menu_type c2_ ON p0_.id = c2_.category_id LEFT JOIN menu_type m1_ ON m1_.id = c2_.menu_type_id LEFT JOIN p_category_category p3_ ON p0_.id = p3_.category_sub_id WHERE p0_.is_active = ? AND p0_.id >= ? AND m1_.id = ? AND p3_.id IS NULL ORDER BY p0_.sequence ASC
Parameters:
[ 1 2 1 ] |
95 | 0.21 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "67" "cs" "App\Entity\Project\Category" ] |
96 | 0.21 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "55" "cs" "App\Entity\Project\Category" ] |
97 | 0.25 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "133" "cs" "App\Entity\Project\Category" ] |
98 | 0.21 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "65" "cs" "App\Entity\Project\Category" ] |
99 | 0.24 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "64" "cs" "App\Entity\Project\Category" ] |
100 | 0.25 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "48" "cs" "App\Entity\Project\Category" ] |
101 | 0.24 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "68" "cs" "App\Entity\Project\Category" ] |
102 | 0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3, t0.controller_name AS controller_name_4 FROM sub_menu_type t0 INNER JOIN category_sub_menu_type ON t0.id = category_sub_menu_type.sub_menu_type_id WHERE category_sub_menu_type.category_id = ?
Parameters:
[
67
]
|
103 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3, t0.controller_name AS controller_name_4 FROM sub_menu_type t0 INNER JOIN category_sub_menu_type ON t0.id = category_sub_menu_type.sub_menu_type_id WHERE category_sub_menu_type.category_id = ?
Parameters:
[
55
]
|
104 | 0.53 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.is_xml_exportable AS is_xml_exportable_16, p0_.created_at AS created_at_17, p0_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 FROM p_category p0_ LEFT JOIN category_menu_type c2_ ON p0_.id = c2_.category_id LEFT JOIN menu_type m1_ ON m1_.id = c2_.menu_type_id LEFT JOIN p_category_category p3_ ON p0_.id = p3_.category_sub_id WHERE p0_.is_active = ? AND p0_.id >= ? AND p0_.id <> ? AND p3_.category_super_id = ? AND m1_.id = ? ORDER BY p0_.sequence ASC
Parameters:
[ 1 2 55 55 1 ] |
105 | 0.21 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "56" "cs" "App\Entity\Project\Category" ] |
106 | 0.23 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "84" "cs" "App\Entity\Project\Category" ] |
107 | 0.20 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "127" "cs" "App\Entity\Project\Category" ] |
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 |
---|---|
App\Entity\Project\Currency | No errors. |
App\Entity\Project\Category | No errors. |
App\Entity\Project\CategoryType | No errors. |
App\Entity\Project\Upload | No errors. |
App\Entity\Project\Label | No errors. |
App\Entity\Project\CategoryFile | No errors. |
App\Entity\Project\CategoryCategory | No errors. |
App\Entity\Project\Parameter | No errors. |
App\Entity\Project\CategoryProduct | No errors. |
App\Entity\Project\Comment | No errors. |
App\Entity\Project\CategoryPerson | No errors. |
App\Entity\Project\CategoryEvent | No errors. |
App\Entity\Project\CategoryUploadGroup | No errors. |
App\Entity\Project\MenuType | No errors. |
App\Entity\Project\SubMenuType | No errors. |
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
Gedmo\Translatable\Entity\Translation | No errors. |
App\Entity\Project\Product |
|
App\Entity\Project\Producer | No errors. |
App\Entity\Project\ProductType | No errors. |
App\Entity\Project\ProductVariant |
|
App\Entity\Project\Review | No errors. |
App\Entity\Project\ProductUploadGroup |
|
App\Entity\Project\Colour | No errors. |
App\Entity\Project\Availability | No errors. |
App\Entity\Project\PurchaseProductVariant |
|
App\Entity\Project\Video | No errors. |
App\Entity\Project\ProductVariantUploadGroup | No errors. |
App\Entity\Project\Price |
|
App\Entity\Project\ParameterGroup |
|
App\Entity\Project\Person | No errors. |
App\Entity\Project\ParameterGroupType |
|
App\Entity\Project\UploadGroup |
|
App\Entity\Project\File | No errors. |
App\Entity\Project\Client |
|
App\Entity\Project\Event | No errors. |
App\Entity\Project\Purchase |
|
App\Entity\Project\PersonUploadGroup | No errors. |