Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.32 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection

#▲	Time	Info
1	0.19 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`] View formatted query View runnable query Explain query 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 = ? 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 = 1;
2	0.51 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`] View formatted query View runnable query Explain query 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 (?) 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 (6);
3	0.62 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: [371 453 634 684 713 884 1765 1782 1929 1934 1998 2597 2623 2624 2939 3186 3394 3941 3951 4014 4328 4474 4686 4778 4965 4975 5188 6352 6359 7416 8079 8700 8785 8808 9201 9208 9262 9514 11592 11639 11694 11738 11908 11912 11993 12083 12228 13262 14645 17905 17930 18077 18445 18838 19391 20512 21709 23654 25254 28093 32350 33354 34650 35039 35197 35202 4684 1987 3556 3722 31043 27705 5769 9245 27910 13933 2016 18714 6412 37130 38854 39015 39194 39248 39400 39457 40247 11357 24203 33453 13158 40835 25938 38567 961 4282 40550 22094 11626 11921 27157 1999 35970 28284 5770 5771 5772 20397 20398 20399 9330 19700 36493 3958 19397 42319 788 42309 42320 42344 42342 42359 42357 42363 42362 42368 42367 42366 42369 42352 42376 34203 1986 5054 10716 2327 11861 35674 11252 28281 3442 4693 13792 18749 35661 40007 40081 40325 40433 23996 11891 25205 40431 11748 39778 1132 5119 34255 39762 26070 13162 22413 28090 37924 36287 37670 40405 18101 19163 11852 19376 28283 39802 11311 40409 9239 11601 29561 26914 8166 40495 25941 40666 18002 13931 40783 28865 4586 16842 38575 8881 9388 2134 2583 5121 11368 43052 30012 42641 24422 38301 7317 18834 7434 38186 962 38460 11625 13814 24402 33126 6222 10910 9461 4159 5566 42440 7678 29293 1994 3517 7650 36458 38445 12231 12746 21277 42502 43383 7455 7490 7647 22248 32026 35833 36342 36491 37420 38039 38450 40488 41036 41838 3211 37791 13636 20498 26583 9655 23716 30040 9688 17708 31045 31486 38238 39796 9787 43669 2326 2503 4651 5897 6477 11571 28124 30108 38730 38849 40520 42668 42872 9302 33904 34141 35729 7535 30246 36295 41587 34209 40709 41305 28859 44716 44735 11209 38853 40234 42483 7665 38239 38987 20971 45683 45684 45686 45727 45687 45682 40841 29292 40936 45787 45790 45782 36477 40487 5122 45940 45945 17773 5875 6727 46023 46025 314 43336 46063 45847 38638 40318 8670 36469 40265 42829 11846 22480 40251 2469 39798 37230 45730 2342 11780 17576 17901 25609 40578 46112 29962 21087 2760 18083 17774 26559 23907 8149 42282 46327 8608 39750 41039 4039 11544 35854 18675 17897 25161 40411 54764 6168 4435 52225 50994 51759 44358 18836 10525 25528 36637 38330 44340 50750 48358 48749 49079 29601 52933 55235 55236 13743 19370 43018 24773 32297 12361 17887 24776 51851 1702 32649 35032 35599 12014 36208 19633 38491 55316 3816 53385 30265 55214 9595 35013 26287 4796 28290 40267 11951 24205 38976 11807 22685 34206 44620 44636 38882 38279 31629 38830 10614 2627 48396 52258 37794 46629 23078 30848 55158 12812 50402 19699 20547 42935 25560 34250 2482 30798 54344 4710 11554 29978 34568 41591 54748 30733 38989 188 36464 54793 10967 46086 52401 4617 4549 54795 4955 18416 19703 46315 48032 47331 2023 5075 19718 13689 36050 6740 55412 54479 16850 45675 15005 1576 2741 49280 48566 59322 59323 59324 59325 28117 42202 59326 59327 59328 59329 59330 59332 59333 59334 59335 59336 59337 59338 59339 59340 59341 59342 59343 59344 59345 59346 59347 59348 59349 59350 59351 59352 59353 59354 59355 59356 59357 59358 40050 12497 35846 41622 41086 54792 45788 45791 59603 59604 59605 59606 59607 59608 59609 59611 59612 59613 59614 59615 59616 59617 59618 59619 59620 59621 59622 59623 59624 59625 59626 59627 59628 59629 59630 59631 54363 29299 17550 38093 42136 43499 17284 2505 9998 56971 50357 52259 14829 18013 20082 40027 52804 56949 59793 59794 59795 59796 48748 59801 59802 13686 3642 11604 17949 1899 4417 22076 58262 50383 51428 9687 48664 12780 30723 39992 48565 4424 54329 5422 10720 26067 42235 6] View formatted query View runnable query Explain query 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 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 (371, 453, 634, 684, 713, 884, 1765, 1782, 1929, 1934, 1998, 2597, 2623, 2624, 2939, 3186, 3394, 3941, 3951, 4014, 4328, 4474, 4686, 4778, 4965, 4975, 5188, 6352, 6359, 7416, 8079, 8700, 8785, 8808, 9201, 9208, 9262, 9514, 11592, 11639, 11694, 11738, 11908, 11912, 11993, 12083, 12228, 13262, 14645, 17905, 17930, 18077, 18445, 18838, 19391, 20512, 21709, 23654, 25254, 28093, 32350, 33354, 34650, 35039, 35197, 35202, 4684, 1987, 3556, 3722, 31043, 27705, 5769, 9245, 27910, 13933, 2016, 18714, 6412, 37130, 38854, 39015, 39194, 39248, 39400, 39457, 40247, 11357, 24203, 33453, 13158, 40835, 25938, 38567, 961, 4282, 40550, 22094, 11626, 11921, 27157, 1999, 35970, 28284, 5770, 5771, 5772, 20397, 20398, 20399, 9330, 19700, 36493, 3958, 19397, 42319, 788, 42309, 42320, 42344, 42342, 42359, 42357, 42363, 42362, 42368, 42367, 42366, 42369, 42352, 42376, 34203, 1986, 5054, 10716, 2327, 11861, 35674, 11252, 28281, 3442, 4693, 13792, 18749, 35661, 40007, 40081, 40325, 40433, 23996, 11891, 25205, 40431, 11748, 39778, 1132, 5119, 34255, 39762, 26070, 13162, 22413, 28090, 37924, 36287, 37670, 40405, 18101, 19163, 11852, 19376, 28283, 39802, 11311, 40409, 9239, 11601, 29561, 26914, 8166, 40495, 25941, 40666, 18002, 13931, 40783, 28865, 4586, 16842, 38575, 8881, 9388, 2134, 2583, 5121, 11368, 43052, 30012, 42641, 24422, 38301, 7317, 18834, 7434, 38186, 962, 38460, 11625, 13814, 24402, 33126, 6222, 10910, 9461, 4159, 5566, 42440, 7678, 29293, 1994, 3517, 7650, 36458, 38445, 12231, 12746, 21277, 42502, 43383, 7455, 7490, 7647, 22248, 32026, 35833, 36342, 36491, 37420, 38039, 38450, 40488, 41036, 41838, 3211, 37791, 13636, 20498, 26583, 9655, 23716, 30040, 9688, 17708, 31045, 31486, 38238, 39796, 9787, 43669, 2326, 2503, 4651, 5897, 6477, 11571, 28124, 30108, 38730, 38849, 40520, 42668, 42872, 9302, 33904, 34141, 35729, 7535, 30246, 36295, 41587, 34209, 40709, 41305, 28859, 44716, 44735, 11209, 38853, 40234, 42483, 7665, 38239, 38987, 20971, 45683, 45684, 45686, 45727, 45687, 45682, 40841, 29292, 40936, 45787, 45790, 45782, 36477, 40487, 5122, 45940, 45945, 17773, 5875, 6727, 46023, 46025, 314, 43336, 46063, 45847, 38638, 40318, 8670, 36469, 40265, 42829, 11846, 22480, 40251, 2469, 39798, 37230, 45730, 2342, 11780, 17576, 17901, 25609, 40578, 46112, 29962, 21087, 2760, 18083, 17774, 26559, 23907, 8149, 42282, 46327, 8608, 39750, 41039, 4039, 11544, 35854, 18675, 17897, 25161, 40411, 54764, 6168, 4435, 52225, 50994, 51759, 44358, 18836, 10525, 25528, 36637, 38330, 44340, 50750, 48358, 48749, 49079, 29601, 52933, 55235, 55236, 13743, 19370, 43018, 24773, 32297, 12361, 17887, 24776, 51851, 1702, 32649, 35032, 35599, 12014, 36208, 19633, 38491, 55316, 3816, 53385, 30265, 55214, 9595, 35013, 26287, 4796, 28290, 40267, 11951, 24205, 38976, 11807, 22685, 34206, 44620, 44636, 38882, 38279, 31629, 38830, 10614, 2627, 48396, 52258, 37794, 46629, 23078, 30848, 55158, 12812, 50402, 19699, 20547, 42935, 25560, 34250, 2482, 30798, 54344, 4710, 11554, 29978, 34568, 41591, 54748, 30733, 38989, 188, 36464, 54793, 10967, 46086, 52401, 4617, 4549, 54795, 4955, 18416, 19703, 46315, 48032, 47331, 2023, 5075, 19718, 13689, 36050, 6740, 55412, 54479, 16850, 45675, 15005, 1576, 2741, 49280, 48566, 59322, 59323, 59324, 59325, 28117, 42202, 59326, 59327, 59328, 59329, 59330, 59332, 59333, 59334, 59335, 59336, 59337, 59338, 59339, 59340, 59341, 59342, 59343, 59344, 59345, 59346, 59347, 59348, 59349, 59350, 59351, 59352, 59353, 59354, 59355, 59356, 59357, 59358, 40050, 12497, 35846, 41622, 41086, 54792, 45788, 45791, 59603, 59604, 59605, 59606, 59607, 59608, 59609, 59611, 59612, 59613, 59614, 59615, 59616, 59617, 59618, 59619, 59620, 59621, 59622, 59623, 59624, 59625, 59626, 59627, 59628, 59629, 59630, 59631, 54363, 29299, 17550, 38093, 42136, 43499, 17284, 2505, 9998, 56971, 50357, 52259, 14829, 18013, 20082, 40027, 52804, 56949, 59793, 59794, 59795, 59796, 48748, 59801, 59802, 13686, 3642, 11604, 17949, 1899, 4417, 22076, 58262, 50383, 51428, 9687, 48664, 12780, 30723, 39992, 48565, 4424, 54329, 5422, 10720, 26067, 42235) AND (s0_.stock - s0_.reservation) > 0 AND s0_.supplier_id IN (6) ORDER BY s1_.priority ASC, s0_.purchase_price ASC;

#▲

Time

Info

0.19 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
]

View formatted query View runnable query Explain query

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 = ?

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 = 1;

0.51 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
]

View formatted query View runnable query Explain query

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 (?)

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 (6);

0.62 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:

View formatted query View runnable query Explain query

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

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 (371, 453, 634, 684, 713, 884, 1765, 1782, 1929, 1934, 1998, 2597, 2623, 2624, 2939, 3186, 3394, 3941, 3951, 4014, 4328, 4474, 4686, 4778, 4965, 4975, 5188, 6352, 6359, 7416, 8079, 8700, 8785, 8808, 9201, 9208, 9262, 9514, 11592, 11639, 11694, 11738, 11908, 11912, 11993, 12083, 12228, 13262, 14645, 17905, 17930, 18077, 18445, 18838, 19391, 20512, 21709, 23654, 25254, 28093, 32350, 33354, 34650, 35039, 35197, 35202, 4684, 1987, 3556, 3722, 31043, 27705, 5769, 9245, 27910, 13933, 2016, 18714, 6412, 37130, 38854, 39015, 39194, 39248, 39400, 39457, 40247, 11357, 24203, 33453, 13158, 40835, 25938, 38567, 961, 4282, 40550, 22094, 11626, 11921, 27157, 1999, 35970, 28284, 5770, 5771, 5772, 20397, 20398, 20399, 9330, 19700, 36493, 3958, 19397, 42319, 788, 42309, 42320, 42344, 42342, 42359, 42357, 42363, 42362, 42368, 42367, 42366, 42369, 42352, 42376, 34203, 1986, 5054, 10716, 2327, 11861, 35674, 11252, 28281, 3442, 4693, 13792, 18749, 35661, 40007, 40081, 40325, 40433, 23996, 11891, 25205, 40431, 11748, 39778, 1132, 5119, 34255, 39762, 26070, 13162, 22413, 28090, 37924, 36287, 37670, 40405, 18101, 19163, 11852, 19376, 28283, 39802, 11311, 40409, 9239, 11601, 29561, 26914, 8166, 40495, 25941, 40666, 18002, 13931, 40783, 28865, 4586, 16842, 38575, 8881, 9388, 2134, 2583, 5121, 11368, 43052, 30012, 42641, 24422, 38301, 7317, 18834, 7434, 38186, 962, 38460, 11625, 13814, 24402, 33126, 6222, 10910, 9461, 4159, 5566, 42440, 7678, 29293, 1994, 3517, 7650, 36458, 38445, 12231, 12746, 21277, 42502, 43383, 7455, 7490, 7647, 22248, 32026, 35833, 36342, 36491, 37420, 38039, 38450, 40488, 41036, 41838, 3211, 37791, 13636, 20498, 26583, 9655, 23716, 30040, 9688, 17708, 31045, 31486, 38238, 39796, 9787, 43669, 2326, 2503, 4651, 5897, 6477, 11571, 28124, 30108, 38730, 38849, 40520, 42668, 42872, 9302, 33904, 34141, 35729, 7535, 30246, 36295, 41587, 34209, 40709, 41305, 28859, 44716, 44735, 11209, 38853, 40234, 42483, 7665, 38239, 38987, 20971, 45683, 45684, 45686, 45727, 45687, 45682, 40841, 29292, 40936, 45787, 45790, 45782, 36477, 40487, 5122, 45940, 45945, 17773, 5875, 6727, 46023, 46025, 314, 43336, 46063, 45847, 38638, 40318, 8670, 36469, 40265, 42829, 11846, 22480, 40251, 2469, 39798, 37230, 45730, 2342, 11780, 17576, 17901, 25609, 40578, 46112, 29962, 21087, 2760, 18083, 17774, 26559, 23907, 8149, 42282, 46327, 8608, 39750, 41039, 4039, 11544, 35854, 18675, 17897, 25161, 40411, 54764, 6168, 4435, 52225, 50994, 51759, 44358, 18836, 10525, 25528, 36637, 38330, 44340, 50750, 48358, 48749, 49079, 29601, 52933, 55235, 55236, 13743, 19370, 43018, 24773, 32297, 12361, 17887, 24776, 51851, 1702, 32649, 35032, 35599, 12014, 36208, 19633, 38491, 55316, 3816, 53385, 30265, 55214, 9595, 35013, 26287, 4796, 28290, 40267, 11951, 24205, 38976, 11807, 22685, 34206, 44620, 44636, 38882, 38279, 31629, 38830, 10614, 2627, 48396, 52258, 37794, 46629, 23078, 30848, 55158, 12812, 50402, 19699, 20547, 42935, 25560, 34250, 2482, 30798, 54344, 4710, 11554, 29978, 34568, 41591, 54748, 30733, 38989, 188, 36464, 54793, 10967, 46086, 52401, 4617, 4549, 54795, 4955, 18416, 19703, 46315, 48032, 47331, 2023, 5075, 19718, 13689, 36050, 6740, 55412, 54479, 16850, 45675, 15005, 1576, 2741, 49280, 48566, 59322, 59323, 59324, 59325, 28117, 42202, 59326, 59327, 59328, 59329, 59330, 59332, 59333, 59334, 59335, 59336, 59337, 59338, 59339, 59340, 59341, 59342, 59343, 59344, 59345, 59346, 59347, 59348, 59349, 59350, 59351, 59352, 59353, 59354, 59355, 59356, 59357, 59358, 40050, 12497, 35846, 41622, 41086, 54792, 45788, 45791, 59603, 59604, 59605, 59606, 59607, 59608, 59609, 59611, 59612, 59613, 59614, 59615, 59616, 59617, 59618, 59619, 59620, 59621, 59622, 59623, 59624, 59625, 59626, 59627, 59628, 59629, 59630, 59631, 54363, 29299, 17550, 38093, 42136, 43499, 17284, 2505, 9998, 56971, 50357, 52259, 14829, 18013, 20082, 40027, 52804, 56949, 59793, 59794, 59795, 59796, 48748, 59801, 59802, 13686, 3642, 11604, 17949, 1899, 4417, 22076, 58262, 50383, 51428, 9687, 48664, 12780, 30723, 39992, 48565, 4424, 54329, 5422, 10720, 26067, 42235) AND (s0_.stock - s0_.reservation) > 0 AND s0_.supplier_id IN (6) ORDER BY s1_.priority ASC, s0_.purchase_price ASC;

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.

Symfony Profiler

GET https://core.relaxmoma.cz/feeds/baselinker-d-0-stock

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping