Query Metrics
1493
Database Queries
15
Different statements
308.00 ms
Query time
11
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
106.33 ms (34.52%) |
540 |
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:
[ "108" "en" "App\Entity\Project\Category" ] |
83.85 ms (27.22%) |
432 |
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:
[
54
]
|
82.24 ms (26.70%) |
432 |
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:
[
595
]
|
10.44 ms (3.39%) |
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
]
|
8.94 ms (2.90%) |
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:
[ 108 120 121 122 204 205 206 207 208 209 210 211 212 213 214 215 216 218 219 220 123 423 667 1 ] |
4.88 ms (1.58%) |
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" 1171 1166 1165 1164 1163 1162 1161 1160 1154 1153 1152 1140 1139 1138 1141 1155 1151 1150 1148 1118 1117 1110 1120 1136 1145 1119 1144 1137 1134 1115 1114 1113 1112 1108 1104 1103 1096 1097 1040 1092 1147 1050 1102 1093 1094 1111 1107 1100 1099 1098 1090 1087 1085 1084 1083 1053 1049 1088 1020 1016 1039 1013 1024 1044 1042 1017 1067 1055 1054 1046 1045 1043 1041 1037 1036 1035 1034 1033 1031 1030 1029 1028 1015 1149 1007 1009 1002 999 1012 1068 1027 1026 1011 1010 1008 1004 1001 1000 995 993 994 984 981 1082 976 1069 974 982 983 992 991 990 989 987 986 985 978 977 971 951 949 947 964 957 950 948 942 958 972 963 962 961 960 959 956 955 954 953 946 945 943 937 933 923 916 907 928 970 926 902 925 900 941 922 898 932 940 939 935 934 930 929 917 909 905 899 915 897 860 747 740 742 799 809 881 804 810 903 896 895 847 774 752 751 749 748 744 741 737 717 714 813 802 812 801 849 811 718 712 711 709 654 653 622 607 606 605 604 803 845 818 844 806 805 816 888 815 727 814 726 880 889 723 817 720 655 640 637 623 595 753 754 901 820 819 894 730 867 733 719 661 656 647 624 613 596 759 870 755 760 821 756 761 757 762 871 859 858 671 670 652 642 638 636 630 629 628 603 600 807 848 869 877 649 648 645 631 763 890 850 808 724 887 725 633 632 616 612 597 874 875 864 873 872 666 650 643 598 855 854 853 765 766 878 673 664 644 625 822 731 868 866 879 646 617 823 824 861 862 865 852 679 667 626 611 599 876 831 830 732 851 729 676 675 651 639 634 618 608 601 839 886 736 885 728 665 635 614 891 1048 767 683 669 627 826 843 863 892 793 836 833 674 672 668 609 602 893 800 1081 792 840 825 884 832 768 660 658 657 619 610 883 882 842 841 827 838 837 783 769 846 834 777 677 782 770 662 620 791 771 681 680 659 835 798 772 682 615 790 829 773 663 828 789 776 678 621 781 797 796 795 794 775 780 779 778 787 788 785 786 784 968 969 ] |
3.27 ms (1.06%) |
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.74 ms (0.57%) |
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.55 ms (0.50%) |
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:
[
108
]
|
1.39 ms (0.45%) |
8 |
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
]
|
1.32 ms (0.43%) |
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.69 ms (0.22%) |
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.59 ms (0.19%) |
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.47 ms (0.15%) |
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.10%) |
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:
[
"edicny-rady"
]
|
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. |
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 |
|
App\Entity\Project\Transportation | No errors. |
App\Entity\Project\Note | No errors. |
App\Entity\Project\Payment | No errors. |