Query Metrics
4
Database Queries
4
Different statements
3.93 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.ms5_id AS ms5_id_3, t0.code AS code_4, t0.type AS type_5, t0.priority AS priority_6, t0.webpage AS webpage_7, t0.feed_url AS feed_url_8, t0.is_active AS is_active_9, t0.to_feed AS to_feed_10, t0.logo AS logo_11, t0.external_url AS external_url_12, t0.note AS note_13, t0.reloadts AS reloadts_14, t0.createts AS createts_15, t0.editts AS editts_16, t0.create_user_id AS create_user_id_17, t0.edit_user_id AS edit_user_id_18 FROM supplier t0 WHERE t0.to_feed = ?
Parameters:
[
1
]
|
| 2 | 0.81 ms |
SELECT DISTINCT (v0_.id) AS sclr_0 FROM variant v0_ LEFT JOIN stock s1_ ON v0_.id = s1_.variant_id LEFT JOIN product p2_ ON v0_.product_id = p2_.id WHERE (s1_.stock - s1_.reservation) > 0 AND p2_.to_export = 1 AND s1_.supplier_id IN (?)
Parameters:
[
6
]
|
| 3 | 0.82 ms |
SELECT DISTINCT (v0_.id) AS sclr_0 FROM variant v0_ LEFT JOIN stock s1_ ON v0_.id = s1_.variant_id LEFT JOIN product p2_ ON v0_.product_id = p2_.id WHERE (s1_.stock - s1_.reservation) > 0 AND p2_.to_export = 1 AND s1_.supplier_id IN (?, ?, ?, ?, ?) AND p2_.amazon_status = 1
Parameters:
[ 1 2 3 5 9 ] |
| 4 | 2.10 ms |
SELECT s0_.id AS id_0, s0_.variant_id AS sclr_1, (s0_.stock - s0_.reservation) AS sclr_2, s0_.purchase_price AS purchase_price_3, s0_.code AS code_4 FROM stock s0_ LEFT JOIN supplier s1_ ON s0_.supplier_id = s1_.id WHERE s0_.variant_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND (s0_.stock - s0_.reservation) > 0 AND s0_.supplier_id IN (?, ?, ?, ?, ?) ORDER BY s1_.priority ASC, s0_.purchase_price ASC
Parameters:
[ 531 536 542 543 629 737 739 955 958 961 962 963 964 965 966 967 968 970 971 973 974 979 980 982 983 984 985 986 988 990 991 994 995 996 1000 1001 1004 1008 1009 1012 1799 2049 2050 2051 2052 2053 2407 2451 2454 2455 2457 2718 2719 2720 2722 2725 2726 3013 3014 3015 3039 3053 3054 3055 3058 3059 3061 3062 3063 3066 3067 3068 3069 3070 3071 3074 3130 3137 3188 3197 3198 3227 3327 3987 3988 3994 3997 3998 3999 4000 4001 4002 4009 4011 4104 4107 4114 4118 4119 4120 4124 4129 4138 4469 4470 4549 4551 4552 4553 4762 4800 4845 4852 4889 4930 5052 5107 5111 5112 5579 5581 5584 5591 5593 5596 5598 5599 5600 5602 5603 5605 5606 5607 5608 5609 5611 5612 5613 5614 6772 6773 6775 6779 6780 6805 6823 6825 6826 6827 6828 6830 6843 6849 6851 6852 6854 6855 6856 6857 6861 6890 6904 6944 6951 6952 6958 6972 6977 6979 6984 6985 6991 7000 7014 7017 7019 7020 7021 7040 7041 7042 7066 7088 7089 7090 7092 7104 7106 7110 7111 7120 7121 7123 7129 7135 7136 7137 7139 7140 7142 7182 7196 7199 7202 7213 7214 7237 7238 7261 7744 7747 7748 7749 7750 7751 7752 7753 7756 7757 7759 7760 7764 7766 7767 7773 7775 7777 7779 7780 7785 7793 7799 7801 7805 7807 7811 7813 7814 7819 7821 7826 7827 7832 7833 7837 7842 7843 7847 7866 7874 7892 7915 7918 7919 7936 7939 7943 7949 7952 7953 7958 7964 7965 7969 7976 7993 7997 8005 8007 8037 8049 8050 8052 8078 8079 8080 8117 8120 8121 8126 8137 8142 8144 8166 8167 8187 8206 8207 8222 8224 8226 8232 8244 8247 8250 8252 8256 8282 8291 8294 8302 8308 8314 8318 8326 8359 8361 8376 8382 8387 8393 8395 8398 8399 8400 8401 9224 9226 9231 1003 1007 1010 1011 1790 1860 3016 3184 4159 4854 4900 743 987 993 3052 5051 13693 13696 13732 13785 17074 17076 17077 17079 17087 17092 17093 17104 17111 17116 17131 17133 17134 17135 17136 17139 17146 17147 17148 17299 17301 17302 17303 17305 17306 17315 17336 17338 17339 17340 17341 17344 17346 17355 17358 17363 17367 17368 17369 17370 17371 17372 17382 17383 17384 17398 17400 17404 17405 17406 17416 17420 17421 17422 17424 17426 17427 17429 17435 17441 17452 17453 17454 17463 17475 17476 17477 17484 17490 17492 17493 17504 17511 18951 19039 19041 19043 19044 19055 19057 19060 19061 19062 19063 19064 19065 19810 20021 20204 20207 20228 20496 20556 20557 20833 20835 20837 20857 20864 20874 20883 20886 20887 20889 20890 20891 20892 20893 20908 20911 20925 20926 20933 20934 20939 20940 20942 20943 20947 20952 20953 20954 20955 20956 20961 20962 20964 20966 20969 20971 20972 20974 20992 20993 21003 21005 21014 21017 21021 21025 21027 21037 21039 21040 21042 21046 21047 21051 21053 21056 21058 21060 5050 5604 22254 22500 22502 22503 22510 22511 22518 22524 22529 22542 23030 23661 23667 24043 24047 24049 24051 24057 24059 24060 24062 24064 24065 24066 24069 24072 24075 24088 24090 24123 24254 24258 25710 25890 26084 26095 26096 26097 26098 26099 26100 26107 26108 26110 26112 26113 26114 26115 26120 26130 26131 26133 26134 26170 26171 26435 26623 26927 27682 27683 27684 27686 27687 27689 27690 27691 27693 27694 27696 27777 27778 27779 27780 27781 27782 27783 27784 27785 27786 27789 27790 27793 27797 27798 27800 27801 27803 27804 27805 27806 27807 27810 27813 27815 27816 27817 27818 27819 27823 27825 27826 27827 27828 27829 27830 27833 27836 27837 27839 27840 27845 27847 27849 27851 27852 27853 27855 27856 27857 27859 27861 27864 27865 27867 27869 27870 27874 27877 27878 27879 27881 27883 27884 27885 27886 27887 27888 27889 27891 28241 28312 28313 35530 35531 35593 35594 35676 35678 35679 35875 35877 35880 35883 35884 35885 35886 35887 35888 35889 35890 35891 35893 35894 35895 35896 35897 35898 35899 35900 35901 35902 35903 35904 35905 35906 35908 35911 35912 35913 35914 35915 35973 35974 35975 35977 35978 35979 35980 35981 35983 35985 35988 35989 35991 35993 35994 35996 35997 35998 35999 36000 36001 36002 36004 36005 36006 36008 36019 36258 36259 36260 36267 36268 36269 36270 36280 36287 36289 36291 36292 36297 36299 36301 36302 36306 36307 36308 36309 36328 36329 36330 36331 36332 36333 36334 36335 36336 36342 36346 36350 36351 36352 36353 36355 36356 36360 36366 36368 36370 36383 36385 36387 36388 36389 36390 36391 36392 36394 36398 36399 36400 36401 36804 36805 37317 37349 37350 37351 37352 38272 38273 38274 38275 38277 38374 38375 38377 38378 38379 38380 38381 38382 38383 38384 38386 38390 38392 38393 38394 38395 38396 38397 38398 38399 38401 38403 38404 38405 38406 38407 38408 38409 38410 38411 38412 38413 38414 38415 38416 38417 38420 38422 38423 38424 38425 38426 38427 38428 38429 38430 38431 38432 38434 38435 38436 38437 38438 38440 38441 38442 38443 38612 40561 40562 40563 40564 40639 40640 40645 40646 40647 40648 40653 40666 40668 40669 40670 40672 40673 40674 40675 40676 40685 40687 40689 40690 40691 40695 40696 40709 40710 40713 40714 40718 40722 40727 40730 40732 40733 40738 40747 40748 40751 40752 40754 40758 40760 40761 41120 41122 41123 41124 41125 41126 41127 41128 41130 41131 41132 41133 41134 41135 41136 41137 41138 41139 41140 41141 41142 41143 41144 41145 41147 41148 41149 41150 41151 41152 41153 41154 41157 41158 41159 41160 41161 41337 41643 41644 41652 42092 42093 42095 42156 3190 2724 26102 26101 26128 42431 42432 4126 42433 3990 26127 42434 26169 5597 5595 5594 42581 42583 42640 42642 42646 42647 42648 42649 42650 42651 42652 42725 42727 42728 42729 42730 42731 42753 42754 42755 42756 42757 42758 1006 42759 42760 42761 42763 42764 42765 42766 42767 42768 42769 42770 42772 42802 42803 42804 42805 42806 42807 42808 42809 42810 42811 42812 42814 42815 42816 42817 42818 42819 42820 43059 43060 43067 2460 4116 1 2 3 5 9 ] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| ms5 | doctrine.dbal.ms5_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\Supplier | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Stock | No errors. |
| App\Entity\StockHistory | No errors. |
| App\Entity\ImportLog | No errors. |
| App\Entity\OrderItem | No errors. |
| App\Entity\Variant | No errors. |
| App\Entity\Product | No errors. |