Query Metrics
4
Database Queries
4
Different statements
2.44 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.27 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.53 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.60 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 7 9 ] |
| 4 | 1.03 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 542 543 629 737 739 955 961 963 964 965 966 967 968 970 971 973 979 980 982 983 984 988 990 991 994 995 996 1000 1001 1003 1004 1006 1007 1008 1009 1010 1011 1790 1860 2049 2050 2051 2052 2053 2451 2455 2457 2460 2718 2720 2722 2724 2725 2726 3014 3015 3016 3052 3053 3054 3055 3058 3059 3061 3063 3067 3068 3070 3184 3190 3227 3327 3988 3990 3994 3997 3998 3999 4000 4001 4009 4011 4114 4116 4118 4119 4120 4124 4125 4126 4129 4138 4159 4469 4470 4549 4552 4553 4762 4800 4845 4852 4854 4889 4901 4930 5050 5111 5112 5113 5581 5584 5591 5593 5594 5595 5596 5597 5598 5599 5602 5603 5605 5606 5607 5609 5611 5612 5613 5614 6772 6773 6775 6777 6780 6781 6816 6823 6826 6828 6838 6849 6850 6851 6852 6861 6887 6890 6904 6958 6977 6979 6984 6985 7000 7017 7020 7041 7066 7089 7090 7092 7093 7106 7111 7121 7123 7135 7136 7137 7139 7140 7142 7196 7213 7214 7238 7261 7262 7744 7747 7748 7750 7752 7753 7756 7757 7759 7760 7762 7764 7766 7767 7773 7777 7779 7785 7792 7793 7802 7807 7813 7819 7821 7831 7832 7833 7837 7842 7847 7874 7892 7908 7915 7918 7919 7936 7949 7952 7953 7958 7964 7965 7993 7997 8007 8022 8037 8049 8078 8079 8080 8120 8121 8126 8144 8166 8167 8187 8188 8206 8207 8222 8224 8232 8235 8244 8247 8250 8256 8257 8294 8302 8308 8314 8318 8326 8359 8361 8376 8382 8387 8393 8395 8398 8399 8400 9224 9226 9231 13693 13696 13732 17076 17086 17087 17092 17131 17133 17134 17136 17139 17147 17299 17301 17305 17306 17315 17325 17336 17338 17340 17341 17344 17346 17355 17358 17363 17367 17368 17369 17370 17371 17372 17382 17398 17400 17401 17404 17405 17406 17416 17418 17420 17421 17422 17424 17426 17427 17435 17441 17453 17454 17463 17476 17484 17490 17492 17497 17504 17510 17511 18951 19041 19052 19057 19062 19063 19064 19065 19810 20021 20206 20207 20228 20496 20556 20557 20833 20835 20837 20857 20874 20883 20886 20887 20890 20891 20892 20893 20896 20908 20911 20925 20926 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 21040 21042 21046 21047 21051 21053 21056 21060 22254 22503 22510 22515 22518 23030 24043 24049 24051 24057 24059 24060 24062 24064 24065 24066 24069 24075 24088 24123 24264 25710 25890 26095 26096 26097 26098 26099 26100 26108 26113 26120 26127 26130 26131 26133 26134 26169 26170 26171 26435 26623 26927 27682 27683 27684 27685 27686 27687 27689 27690 27691 27693 27694 27696 27776 27777 27778 27779 27780 27781 27783 27784 27785 27786 27788 27789 27797 27800 27801 27802 27803 27804 27807 27810 27811 27813 27814 27815 27816 27817 27818 27819 27825 27827 27828 27829 27833 27839 27845 27847 27850 27851 27852 27855 27856 27857 27859 27861 27864 27867 27869 27870 27874 27875 27877 27878 27879 27881 27884 27885 27887 27888 27889 27890 27891 27892 27893 28312 28313 35530 35531 35593 35676 35678 35679 35875 35877 35880 35883 35885 35886 35887 35888 35889 35890 35891 35894 35895 35896 35897 35898 35901 35902 35903 35905 35911 35912 35913 35914 35915 35970 35974 35975 35978 35979 35980 35981 35982 35983 35985 35988 35990 35991 35993 35994 35996 35997 35998 35999 36000 36001 36002 36004 36005 36008 36258 36259 36260 36267 36268 36269 36270 36287 36291 36292 36297 36299 36301 36306 36307 36308 36309 36328 36329 36330 36331 36332 36333 36334 36335 36336 36339 36342 36350 36351 36352 36353 36355 36356 36360 36366 36368 36369 36370 36374 36383 36385 36387 36388 36389 36390 36391 36392 36394 36398 36400 36401 36804 36805 37317 37349 37350 37351 37352 38034 38272 38273 38275 38277 38374 38375 38376 38377 38378 38379 38380 38382 38383 38384 38390 38391 38392 38394 38395 38396 38397 38398 38404 38405 38407 38408 38409 38410 38411 38413 38415 38416 38422 38424 38425 38426 38428 38429 38430 38432 38434 38435 38436 38440 38441 38442 40550 40561 40562 40563 40564 40623 40625 40639 40646 40647 40648 40653 40666 40668 40669 40670 40672 40673 40674 40675 40676 40685 40687 40690 40691 40692 40695 40696 40709 40710 40713 40714 40718 40720 40722 40727 40729 40730 40732 40733 40738 40747 40748 40751 40752 40754 40756 40760 40761 41120 41124 41126 41127 41128 41129 41130 41131 41132 41133 41135 41136 41137 41138 41139 41141 41142 41143 41144 41148 41149 41150 41151 41152 41153 41154 41157 41158 41159 41160 41161 41337 41643 41644 41652 42093 42095 42156 42431 42432 42433 42434 42581 42642 42646 42647 42648 42649 42650 42651 42725 42726 42727 42728 42729 42730 42753 42754 42755 42756 42757 42758 42759 42760 42761 42763 42764 42765 42767 42768 42769 42770 42771 42772 42802 42805 42806 42808 42809 42811 42812 42814 42815 42816 42817 42818 42819 42820 43060 1 2 3 5 7 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. |