GET https://mua.greendot.cz/en/publikace/knihy

Query Metrics

1747 Database Queries
19 Different statements
359.40 ms Query time
11 Invalid entities

Grouped Statements

Show all queries

Time Count Info
115.90 ms
(32.25%)
601
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:
[
  "106"
  "en"
  "App\Entity\Project\Category"
]
95.79 ms
(26.65%)
491
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:
[
  49
]
93.89 ms
(26.12%)
491
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:
[
  590
]
12.63 ms
(3.51%)
1
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:
[
  106
  149
  163
  164
  165
  166
  167
  168
  169
  170
  171
  172
  162
  161
  160
  150
  151
  152
  153
  154
  155
  156
  157
  158
  159
  173
  1
]
10.48 ms
(2.92%)
53
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.id = ?
Parameters:
[
  149
]
5.61 ms
(1.56%)
1
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"
  1169
  1166
  1165
  1164
  1163
  1162
  1161
  1160
  1154
  1153
  1152
  1141
  1140
  1139
  1138
  1155
  1151
  1150
  1148
  1145
  1144
  1137
  1136
  1134
  1120
  1119
  1118
  1117
  1115
  1114
  1113
  1112
  1110
  1108
  1104
  1103
  1146
  1116
  1109
  1101
  1147
  1111
  1107
  1102
  1100
  1099
  1098
  1097
  1096
  1095
  1094
  1093
  1092
  1090
  1087
  1085
  1084
  1083
  1053
  1050
  1049
  1040
  1091
  1052
  1086
  1032
  1088
  1067
  1055
  1054
  1051
  1047
  1046
  1045
  1044
  1043
  1042
  1041
  1039
  1037
  1036
  1035
  1034
  1033
  1031
  1030
  1029
  1028
  1024
  1020
  1017
  1016
  1015
  1014
  1013
  1023
  1019
  1022
  1005
  1149
  1068
  1027
  1026
  1012
  1011
  1010
  1009
  1008
  1007
  1004
  1002
  1001
  1000
  999
  995
  993
  998
  980
  1082
  1069
  994
  992
  991
  990
  989
  988
  987
  986
  984
  983
  982
  981
  978
  977
  976
  974
  971
  966
  944
  972
  964
  963
  962
  960
  959
  958
  957
  956
  955
  954
  953
  952
  951
  950
  949
  948
  947
  946
  945
  943
  942
  937
  931
  906
  970
  941
  940
  939
  935
  934
  932
  930
  929
  928
  927
  926
  925
  923
  922
  917
  916
  909
  908
  907
  905
  902
  900
  899
  898
  743
  745
  708
  915
  904
  903
  897
  896
  895
  881
  860
  847
  810
  804
  799
  774
  752
  751
  749
  748
  747
  746
  744
  742
  741
  740
  737
  713
  701
  849
  813
  812
  811
  802
  801
  718
  717
  715
  714
  712
  711
  709
  654
  653
  622
  607
  590
  699
  698
  973
  889
  888
  880
  845
  844
  818
  817
  816
  815
  814
  806
  805
  803
  727
  726
  723
  720
  655
  640
  637
  623
  595
  591
  693
  700
  702
  921
  920
  901
  894
  867
  820
  819
  754
  753
  733
  730
  719
  706
  661
  656
  647
  641
  624
  613
  596
  694
  703
  696
  871
  870
  859
  858
  762
  761
  760
  759
  758
  757
  756
  755
  705
  671
  670
  652
  642
  638
  636
  630
  629
  628
  603
  600
  704
  695
  877
  869
  848
  807
  764
  649
  648
  645
  631
  710
  697
  890
  887
  850
  808
  763
  725
  724
  633
  632
  616
  612
  597
  912
  875
  874
  873
  872
  864
  666
  650
  643
  598
  592
  878
  766
  765
  673
  664
  644
  625
  919
  918
  879
  868
  866
  822
  731
  707
  646
  617
  856
  865
  862
  861
  824
  823
  679
  667
  626
  611
  599
  1080
  876
  831
  830
  732
  729
  676
  675
  651
  639
  634
  618
  608
  601
  886
  839
  736
  728
  665
  635
  614
  1048
  891
  767
  683
  669
  627
  1079
  892
  863
  843
  836
  833
  793
  674
  672
  668
  609
  602
  1081
  1078
  893
  840
  832
  825
  800
  792
  768
  660
  658
  657
  619
  610
  910
  842
  841
  838
  837
  827
  783
  769
  1077
  1070
  846
  834
  777
  677
  782
  770
  662
  620
  1076
  791
  771
  681
  680
  659
  938
  835
  798
  772
  682
  615
  1075
  913
  829
  790
  773
  663
  911
  828
  789
  776
  678
  621
  1072
  914
  781
  1074
  1073
  797
  796
  795
  794
  775
  780
  779
  778
  1071
  788
  787
  785
  786
  784
  968
]
5.11 ms
(1.42%)
24
SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.upload_group_id AS upload_group_id_14 FROM upload t0 WHERE t0.upload_group_id = ? ORDER BY t0.sequence ASC
Parameters:
[
  2340
]
4.38 ms
(1.22%)
24
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.upload_group_id AS upload_group_id_3, t0.product_variant_id AS product_variant_id_4 FROM product_variant_upload_group t0 WHERE t0.product_variant_id = ?
Parameters:
[
  648
]
3.97 ms
(1.10%)
24
SELECT t0.id AS id_1, t0.type AS type_2 FROM upload_group t0 WHERE t0.id = ?
Parameters:
[
  2340
]
3.18 ms
(0.89%)
5
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
]
1.67 ms
(0.46%)
10
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:
[
  6
]
1.64 ms
(0.46%)
7
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
]
1.49 ms
(0.42%)
7
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:
[
  106
]
1.34 ms
(0.37%)
2
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
]
0.74 ms
(0.20%)
1
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
]
0.55 ms
(0.15%)
1
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 p_category_category p1_ ON p0_.id = p1_.category_sub_id WHERE p0_.id >= ? AND p0_.is_active = ? AND p0_.is_menu = ? AND p1_.id IS NULL ORDER BY p0_.sequence ASC
Parameters:
[
  2
  1
  3
]
0.43 ms
(0.12%)
2
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"
]
0.31 ms
(0.09%)
1
SELECT p0_.id AS id_0, p0_.sequence AS sequence_1, p0_.is_menu_item AS is_menu_item_2, p0_.category_super_id AS category_super_id_3, p0_.category_sub_id AS category_sub_id_4 FROM p_category_category p0_ WHERE p0_.category_sub_id = ? ORDER BY p0_.id ASC
Parameters:
[
  106
]
0.29 ms
(0.08%)
1
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:
[
  "knihy"
]

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
  • The mappings App\Entity\Project\Product#productUploadGroup and App\Entity\Project\ProductUploadGroup#Product are inconsistent with each other.
App\Entity\Project\Producer No errors.
App\Entity\Project\ProductType No errors.
App\Entity\Project\ProductVariant
  • The mappings App\Entity\Project\ProductVariant#purchaseProductVariant and App\Entity\Project\PurchaseProductVariant#ProductVariant are inconsistent with each other.
App\Entity\Project\Review No errors.
App\Entity\Project\ProductUploadGroup
  • The association App\Entity\Project\ProductUploadGroup#UploadGroup refers to the inverse side field App\Entity\Project\UploadGroup#productUploadGroups which does not exist.
  • The association App\Entity\Project\ProductUploadGroup#Product refers to the inverse side field App\Entity\Project\Product#productUploadGroups which does not exist.
App\Entity\Project\Colour No errors.
App\Entity\Project\Availability No errors.
App\Entity\Project\PurchaseProductVariant
  • The association App\Entity\Project\PurchaseProductVariant#ProductVariant refers to the inverse side field App\Entity\Project\ProductVariant#orderProductVariants which does not exist.
App\Entity\Project\Video No errors.
App\Entity\Project\ProductVariantUploadGroup No errors.
App\Entity\Project\Price
  • The association App\Entity\Project\Price#event refers to the inverse side field App\Entity\Project\Event#price which is not defined as association.
  • The association App\Entity\Project\Price#event refers to the inverse side field App\Entity\Project\Event#price which does not exist.
App\Entity\Project\ParameterGroup
  • The association App\Entity\Project\ParameterGroup#type refers to the inverse side field App\Entity\Project\ParameterGroupType#parameterGroups which does not exist.
App\Entity\Project\Person No errors.
App\Entity\Project\ParameterGroupType
  • The association App\Entity\Project\ParameterGroupType#type refers to the owning side field App\Entity\Project\ParameterGroup#parameterGroups which does not exist.
App\Entity\Project\UploadGroup
  • The mappings App\Entity\Project\UploadGroup#productUploadGroup and App\Entity\Project\ProductUploadGroup#UploadGroup are inconsistent with each other.
App\Entity\Project\File No errors.
App\Entity\Project\Client
  • The mappings App\Entity\Project\Client#orders and App\Entity\Project\Purchase#Client are inconsistent with each other.
App\Entity\Project\Event No errors.
App\Entity\Project\Purchase
  • The mappings App\Entity\Project\Purchase#PaymentType and App\Entity\Project\PaymentType#purchases are inconsistent with each other.
  • The association App\Entity\Project\Purchase#Client refers to the inverse side field App\Entity\Project\Client#purchases which does not exist.
App\Entity\Project\PersonUploadGroup No errors.
App\Entity\Project\EventUploadGroup No errors.
App\Entity\Project\ClientDiscount No errors.
App\Entity\Project\EventType No errors.
App\Entity\Project\PurchaseEvent No errors.
App\Entity\Project\PaymentType
  • The association App\Entity\Project\PaymentType#purchases refers to the owning side field App\Entity\Project\Purchase#Payment which does not exist.
App\Entity\Project\Transportation No errors.
App\Entity\Project\Note No errors.
App\Entity\Project\Payment No errors.