Query Metrics
1506
Database Queries
11
Different statements
306.06 ms
Query time
7
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
95.79 ms (31.30%) |
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
]
|
94.36 ms (30.83%) |
507 |
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" ] |
93.89 ms (30.68%) |
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 (4.13%) |
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 ] |
5.61 ms (1.83%) |
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 ] |
1.67 ms (0.54%) |
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
]
|
0.74 ms (0.24%) |
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.61 ms (0.20%) |
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 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.29 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:
[
"knihy"
]
|
0.29 ms (0.09%) |
1 |
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
]
|
0.20 ms (0.06%) |
1 |
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"
]
|
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 |
|