Query Metrics
14
Database Queries
4
Different statements
76.79 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 7.52 ms |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, name_2 FROM (SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.name AS name_2, p0_.description AS description_3, p0_.presentation AS presentation_4, p0_.is_wholesaler AS is_wholesaler_5, p0_.publicSale AS publicSale_6, p0_.active AS active_7, p0_.isDeleted AS isDeleted_8, p0_.recommended AS recommended_9, p0_.tax AS tax_10, p0_.base_price AS base_price_11, p0_.price AS price_12, p0_.thumbnail AS thumbnail_13, p0_.image AS image_14 FROM product p0_ WHERE p0_.active = ?) dctrn_result_inner ORDER BY name_2 ASC, id_0 ASC) dctrn_result LIMIT 1000
Parameters:
[
1
]
|
| 2 | 56.71 ms |
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.name AS name_2, p0_.description AS description_3, p0_.presentation AS presentation_4, p0_.is_wholesaler AS is_wholesaler_5, p0_.publicSale AS publicSale_6, p0_.active AS active_7, p0_.isDeleted AS isDeleted_8, p0_.recommended AS recommended_9, p0_.tax AS tax_10, p0_.base_price AS base_price_11, p0_.price AS price_12, p0_.thumbnail AS thumbnail_13, p0_.image AS image_14, p0_.idCategory AS idCategory_15, p0_.idSize AS idSize_16, p0_.unit_of_measurement_id AS unit_of_measurement_id_17 FROM product p0_ WHERE p0_.active = ? AND p0_.id IN (?) ORDER BY p0_.name ASC, p0_.id ASC
Parameters:
[ 1 [ 63 826 224 225 49 422 419 160 838 953 835 162 45 180 771 631 451 136 157 827 178 619 367 103 537 919 805 806 792 793 921 920 796 795 751 382 99 194 861 784 870 794 785 797 786 798 799 800 787 801 803 802 804 228 62 55 850 448 935 936 937 938 939 655 570 50 984 820 818 819 823 825 824 326 353 327 328 868 840 869 891 853 855 748 753 954 757 749 846 348 385 859 649 845 987 968 871 867 988 654 633 375 755 278 280 294 354 759 282 551 279 281 346 418 417 283 284 426 338 866 674 402 650 647 863 862 986 843 976 865 975 635 974 844 651 634 643 384 653 340 376 391 298 374 271 395 881 947 101 51 440 441 380 873 365 648 209 257 394 511 183 444 46 808 831 830 829 810 972 933 112 111 545 344 413 856 857 858 841 437 481 92 64 918 210 828 107 38 791 460 98 960 961 962 362 393 964 839 967 370 427 447 477 533 958 956 886 898 942 916 901 899 943 955 907 917 902 951 908 909 885 895 894 957 890 892 893 897 944 945 946 896 906 903 904 905 941 940 887 900 931 932 135 250 860 408 421 410 412 409 420 431 355 950 854 264 876 89 625 624 433 453 872 772 912 515 769 922 970 773 923 512 774 924 516 775 914 521 776 925 741 777 913 522 977 978 770 915 513 778 926 517 779 927 519 780 928 518 781 929 523 930 514 435 450 526 877 48 292 220 949 245 880 874 875 57 93 196 272 965 574 139 372 750 197 207 244 193 739 276 550 208 277 345 416 415 275 254 56 59 504 979 88 849 700 836 822 821 404 878 879 37 397 192 76 390 188 541 816 191 544 985 229 814 815 812 811 851 813 736 85 274 969 807 77 423 424 722 723 724 725 726 729 727 730 731 732 733 734 728 363 952 179 852 47 401 959 884 888 911 449 165 910 963 948 301 369 200 144 790 527 528 621 529 834 622 973 889 366 990 980 989 981 991 982 256 300 983 96 186 97 532 457 377 378 966 817 754 187 147 90 652 211 273 456 832 833 623 214 53 166 971 190 540 934 52 864 379 992 189 542 295 251 461 161 842 613 215 216 217 546 218 837 478 434 104 400 882 185 40 847 883 142 381 403 360 41 848 ] ] |
| 3 | 6.28 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.name AS name_2, p0_.description AS description_3, p0_.presentation AS presentation_4, p0_.is_wholesaler AS is_wholesaler_5, p0_.publicSale AS publicSale_6, p0_.active AS active_7, p0_.isDeleted AS isDeleted_8, p0_.recommended AS recommended_9, p0_.tax AS tax_10, p0_.base_price AS base_price_11, p0_.price AS price_12, p0_.thumbnail AS thumbnail_13, p0_.image AS image_14 FROM product p0_ WHERE p0_.active = ? ORDER BY p0_.name ASC, p0_.id ASC) dctrn_result) dctrn_table
Parameters:
[
1
]
|
| 4 | 0.69 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.display AS display_3, t0.parent AS parent_4 FROM productCategories t0 WHERE t0.id = ?
Parameters:
[
16
]
|
| 5 | 0.52 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.display AS display_3, t0.parent AS parent_4 FROM productCategories t0 WHERE t0.id = ?
Parameters:
[
15
]
|
| 6 | 0.44 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.display AS display_3, t0.parent AS parent_4 FROM productCategories t0 WHERE t0.id = ?
Parameters:
[
18
]
|
| 7 | 0.43 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.display AS display_3, t0.parent AS parent_4 FROM productCategories t0 WHERE t0.id = ?
Parameters:
[
21
]
|
| 8 | 0.36 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.display AS display_3, t0.parent AS parent_4 FROM productCategories t0 WHERE t0.id = ?
Parameters:
[
13
]
|
| 9 | 0.52 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.display AS display_3, t0.parent AS parent_4 FROM productCategories t0 WHERE t0.id = ?
Parameters:
[
23
]
|
| 10 | 0.71 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.display AS display_3, t0.parent AS parent_4 FROM productCategories t0 WHERE t0.id = ?
Parameters:
[
20
]
|
| 11 | 0.56 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.display AS display_3, t0.parent AS parent_4 FROM productCategories t0 WHERE t0.id = ?
Parameters:
[
22
]
|
| 12 | 0.53 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.display AS display_3, t0.parent AS parent_4 FROM productCategories t0 WHERE t0.id = ?
Parameters:
[
17
]
|
| 13 | 0.83 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.display AS display_3, t0.parent AS parent_4 FROM productCategories t0 WHERE t0.id = ?
Parameters:
[
10
]
|
| 14 | 0.69 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.display AS display_3, t0.parent AS parent_4 FROM productCategories t0 WHERE t0.id = ?
Parameters:
[
19
]
|
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\Product\Entity\Product | No errors. |
| App\Product\Entity\ProductCategory | No errors. |
| App\Product\Entity\ProductSize | No errors. |
| App\Product\Entity\UnitOfMeasurement | No errors. |