Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

0.88 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection

#▲	Time	Info
1	0.22 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.22 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.45 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 537 634 684 713 1765 1782 1929 1934 1998 2006 2597 2623 2624 2939 3394 3951 4014 4474 4686 4778 4965 5188 6352 6359 7416 8079 8700 8785 8808 9201 9208 9262 11639 11738 11908 11912 11994 12083 12228 12719 13190 13262 13660 13684 14645 17905 17930 18445 18838 19391 20512 21709 23654 25254 28093 30704 32350 33354 34650 35197 4684 31043 5769 27910 1930 2016 6412 37130 38854 39015 39194 39248 39400 39457 39733 8796 11357 24203 17552 33453 13158 40835 25938 38567 4973 40550 29286 22094 32548 11626 11921 11664 27157 38659 35970 5770 5772 20397 20398 20399 9330 19700 3958 42319 788 42309 42320 42344 42342 42359 42357 42363 42362 42368 42367 42366 42369 42352 42376 1986 5054 31413 10716 2327 11252 3442 4693 13792 40007 40081 40325 40433 23996 11891 25205 40431 11748 39778 1132 5119 34255 39762 26070 13162 28090 37924 36287 37670 40405 24770 18101 19163 19376 43132 39802 11311 40409 11601 29561 8166 40495 41472 42134 25941 40666 18002 13931 40783 11495 28865 4586 16842 38575 8881 9388 31414 2583 11368 11607 43052 30012 42641 33375 24422 38301 7317 18834 7434 38186 962 38460 11625 13814 24402 33126 6222 3069 10910 9461 4159 5566 42440 7678 29293 35598 3517 33398 7650 11605 36458 38445 11731 12558 12746 12849 21277 23963 42502 43383 7455 7482 7490 7647 22248 24412 32026 35833 36342 36491 37420 38039 40488 41036 41838 10841 3211 33027 37791 13636 20498 26426 26583 9655 21732 30040 9688 4553 17708 31045 31486 38238 39796 9787 2326 2400 4651 5897 6477 6669 9541 11571 11667 18821 28124 30108 31857 32777 34035 38730 38849 40520 40924 42668 42872 9302 20635 33904 35729 7535 30246 36295 41587 34209 40709 41305 28859 44716 44735 38853 42483 7665 14103 38239 38515 38987 20971 23655 45683 45684 45686 45727 45687 45682 45783 45784 10639 40841 29292 40936 45787 45790 45782 40487 45828 5122 45940 45942 45945 17773 5875 43774 6727 41648 46023 46025 314 43336 46063 38338 45847 38638 8670 9466 9543 23584 23586 36469 40265 22480 32856 28118 40251 35956 2469 39798 37230 45730 9476 13735 11780 17576 17901 25609 46112 29962 33807 21087 2760 3994 18083 17774 26559 8149 42282 46327 664 8608 11519 39750 4039 11544 42152 35854 17897 40411 54764 6168 4435 28050 52225 50994 51759 44358 18836 4464 10525 36637 38330 44340 50750 48749 49079 29601 47790 52933 28252 55235 55236 13743 19370 19704 22377 41620 24773 32297 12361 17887 24776 51851 1702 42223 32649 34172 35032 35599 12014 36208 19633 38762 38491 55316 3816 53385 13804 30265 4416 23867 55214 9595 35013 43763 4796 28290 40267 11951 24205 38976 46546 11807 22685 34206 44620 44636 51411 38882 38279 31629 38830 10614 23920 11983 26285 48396 52258 9206 31719 37794 23078 30848 13455 11312 12812 21266 24170 48619 50402 19699 20547 42935 25560 46132 34250 2482 30798 40233 54344 4710 1008 2722 11554 29978 36874 36876 44343 34568 41591 54748 30733 4421 38989 188 4420 25075 36464 42327 44150 51557 54793 9499 10967 46086 52401 58350 25742 35603 4617 3119 4549 54795 4543 4955 18416 19703 45943 46315 48032 54747 47331 47958 51889 53502 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, 537, 634, 684, 713, 1765, 1782, 1929, 1934, 1998, 2006, 2597, 2623, 2624, 2939, 3394, 3951, 4014, 4474, 4686, 4778, 4965, 5188, 6352, 6359, 7416, 8079, 8700, 8785, 8808, 9201, 9208, 9262, 11639, 11738, 11908, 11912, 11994, 12083, 12228, 12719, 13190, 13262, 13660, 13684, 14645, 17905, 17930, 18445, 18838, 19391, 20512, 21709, 23654, 25254, 28093, 30704, 32350, 33354, 34650, 35197, 4684, 31043, 5769, 27910, 1930, 2016, 6412, 37130, 38854, 39015, 39194, 39248, 39400, 39457, 39733, 8796, 11357, 24203, 17552, 33453, 13158, 40835, 25938, 38567, 4973, 40550, 29286, 22094, 32548, 11626, 11921, 11664, 27157, 38659, 35970, 5770, 5772, 20397, 20398, 20399, 9330, 19700, 3958, 42319, 788, 42309, 42320, 42344, 42342, 42359, 42357, 42363, 42362, 42368, 42367, 42366, 42369, 42352, 42376, 1986, 5054, 31413, 10716, 2327, 11252, 3442, 4693, 13792, 40007, 40081, 40325, 40433, 23996, 11891, 25205, 40431, 11748, 39778, 1132, 5119, 34255, 39762, 26070, 13162, 28090, 37924, 36287, 37670, 40405, 24770, 18101, 19163, 19376, 43132, 39802, 11311, 40409, 11601, 29561, 8166, 40495, 41472, 42134, 25941, 40666, 18002, 13931, 40783, 11495, 28865, 4586, 16842, 38575, 8881, 9388, 31414, 2583, 11368, 11607, 43052, 30012, 42641, 33375, 24422, 38301, 7317, 18834, 7434, 38186, 962, 38460, 11625, 13814, 24402, 33126, 6222, 3069, 10910, 9461, 4159, 5566, 42440, 7678, 29293, 35598, 3517, 33398, 7650, 11605, 36458, 38445, 11731, 12558, 12746, 12849, 21277, 23963, 42502, 43383, 7455, 7482, 7490, 7647, 22248, 24412, 32026, 35833, 36342, 36491, 37420, 38039, 40488, 41036, 41838, 10841, 3211, 33027, 37791, 13636, 20498, 26426, 26583, 9655, 21732, 30040, 9688, 4553, 17708, 31045, 31486, 38238, 39796, 9787, 2326, 2400, 4651, 5897, 6477, 6669, 9541, 11571, 11667, 18821, 28124, 30108, 31857, 32777, 34035, 38730, 38849, 40520, 40924, 42668, 42872, 9302, 20635, 33904, 35729, 7535, 30246, 36295, 41587, 34209, 40709, 41305, 28859, 44716, 44735, 38853, 42483, 7665, 14103, 38239, 38515, 38987, 20971, 23655, 45683, 45684, 45686, 45727, 45687, 45682, 45783, 45784, 10639, 40841, 29292, 40936, 45787, 45790, 45782, 40487, 45828, 5122, 45940, 45942, 45945, 17773, 5875, 43774, 6727, 41648, 46023, 46025, 314, 43336, 46063, 38338, 45847, 38638, 8670, 9466, 9543, 23584, 23586, 36469, 40265, 22480, 32856, 28118, 40251, 35956, 2469, 39798, 37230, 45730, 9476, 13735, 11780, 17576, 17901, 25609, 46112, 29962, 33807, 21087, 2760, 3994, 18083, 17774, 26559, 8149, 42282, 46327, 664, 8608, 11519, 39750, 4039, 11544, 42152, 35854, 17897, 40411, 54764, 6168, 4435, 28050, 52225, 50994, 51759, 44358, 18836, 4464, 10525, 36637, 38330, 44340, 50750, 48749, 49079, 29601, 47790, 52933, 28252, 55235, 55236, 13743, 19370, 19704, 22377, 41620, 24773, 32297, 12361, 17887, 24776, 51851, 1702, 42223, 32649, 34172, 35032, 35599, 12014, 36208, 19633, 38762, 38491, 55316, 3816, 53385, 13804, 30265, 4416, 23867, 55214, 9595, 35013, 43763, 4796, 28290, 40267, 11951, 24205, 38976, 46546, 11807, 22685, 34206, 44620, 44636, 51411, 38882, 38279, 31629, 38830, 10614, 23920, 11983, 26285, 48396, 52258, 9206, 31719, 37794, 23078, 30848, 13455, 11312, 12812, 21266, 24170, 48619, 50402, 19699, 20547, 42935, 25560, 46132, 34250, 2482, 30798, 40233, 54344, 4710, 1008, 2722, 11554, 29978, 36874, 36876, 44343, 34568, 41591, 54748, 30733, 4421, 38989, 188, 4420, 25075, 36464, 42327, 44150, 51557, 54793, 9499, 10967, 46086, 52401, 58350, 25742, 35603, 4617, 3119, 4549, 54795, 4543, 4955, 18416, 19703, 45943, 46315, 48032, 54747, 47331, 47958, 51889, 53502) AND (s0_.stock - s0_.reservation) > 0 AND s0_.supplier_id IN (6) ORDER BY s1_.priority ASC, s0_.purchase_price ASC;

#▲

Time

Info

0.22 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.22 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.45 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, 537, 634, 684, 713, 1765, 1782, 1929, 1934, 1998, 2006, 2597, 2623, 2624, 2939, 3394, 3951, 4014, 4474, 4686, 4778, 4965, 5188, 6352, 6359, 7416, 8079, 8700, 8785, 8808, 9201, 9208, 9262, 11639, 11738, 11908, 11912, 11994, 12083, 12228, 12719, 13190, 13262, 13660, 13684, 14645, 17905, 17930, 18445, 18838, 19391, 20512, 21709, 23654, 25254, 28093, 30704, 32350, 33354, 34650, 35197, 4684, 31043, 5769, 27910, 1930, 2016, 6412, 37130, 38854, 39015, 39194, 39248, 39400, 39457, 39733, 8796, 11357, 24203, 17552, 33453, 13158, 40835, 25938, 38567, 4973, 40550, 29286, 22094, 32548, 11626, 11921, 11664, 27157, 38659, 35970, 5770, 5772, 20397, 20398, 20399, 9330, 19700, 3958, 42319, 788, 42309, 42320, 42344, 42342, 42359, 42357, 42363, 42362, 42368, 42367, 42366, 42369, 42352, 42376, 1986, 5054, 31413, 10716, 2327, 11252, 3442, 4693, 13792, 40007, 40081, 40325, 40433, 23996, 11891, 25205, 40431, 11748, 39778, 1132, 5119, 34255, 39762, 26070, 13162, 28090, 37924, 36287, 37670, 40405, 24770, 18101, 19163, 19376, 43132, 39802, 11311, 40409, 11601, 29561, 8166, 40495, 41472, 42134, 25941, 40666, 18002, 13931, 40783, 11495, 28865, 4586, 16842, 38575, 8881, 9388, 31414, 2583, 11368, 11607, 43052, 30012, 42641, 33375, 24422, 38301, 7317, 18834, 7434, 38186, 962, 38460, 11625, 13814, 24402, 33126, 6222, 3069, 10910, 9461, 4159, 5566, 42440, 7678, 29293, 35598, 3517, 33398, 7650, 11605, 36458, 38445, 11731, 12558, 12746, 12849, 21277, 23963, 42502, 43383, 7455, 7482, 7490, 7647, 22248, 24412, 32026, 35833, 36342, 36491, 37420, 38039, 40488, 41036, 41838, 10841, 3211, 33027, 37791, 13636, 20498, 26426, 26583, 9655, 21732, 30040, 9688, 4553, 17708, 31045, 31486, 38238, 39796, 9787, 2326, 2400, 4651, 5897, 6477, 6669, 9541, 11571, 11667, 18821, 28124, 30108, 31857, 32777, 34035, 38730, 38849, 40520, 40924, 42668, 42872, 9302, 20635, 33904, 35729, 7535, 30246, 36295, 41587, 34209, 40709, 41305, 28859, 44716, 44735, 38853, 42483, 7665, 14103, 38239, 38515, 38987, 20971, 23655, 45683, 45684, 45686, 45727, 45687, 45682, 45783, 45784, 10639, 40841, 29292, 40936, 45787, 45790, 45782, 40487, 45828, 5122, 45940, 45942, 45945, 17773, 5875, 43774, 6727, 41648, 46023, 46025, 314, 43336, 46063, 38338, 45847, 38638, 8670, 9466, 9543, 23584, 23586, 36469, 40265, 22480, 32856, 28118, 40251, 35956, 2469, 39798, 37230, 45730, 9476, 13735, 11780, 17576, 17901, 25609, 46112, 29962, 33807, 21087, 2760, 3994, 18083, 17774, 26559, 8149, 42282, 46327, 664, 8608, 11519, 39750, 4039, 11544, 42152, 35854, 17897, 40411, 54764, 6168, 4435, 28050, 52225, 50994, 51759, 44358, 18836, 4464, 10525, 36637, 38330, 44340, 50750, 48749, 49079, 29601, 47790, 52933, 28252, 55235, 55236, 13743, 19370, 19704, 22377, 41620, 24773, 32297, 12361, 17887, 24776, 51851, 1702, 42223, 32649, 34172, 35032, 35599, 12014, 36208, 19633, 38762, 38491, 55316, 3816, 53385, 13804, 30265, 4416, 23867, 55214, 9595, 35013, 43763, 4796, 28290, 40267, 11951, 24205, 38976, 46546, 11807, 22685, 34206, 44620, 44636, 51411, 38882, 38279, 31629, 38830, 10614, 23920, 11983, 26285, 48396, 52258, 9206, 31719, 37794, 23078, 30848, 13455, 11312, 12812, 21266, 24170, 48619, 50402, 19699, 20547, 42935, 25560, 46132, 34250, 2482, 30798, 40233, 54344, 4710, 1008, 2722, 11554, 29978, 36874, 36876, 44343, 34568, 41591, 54748, 30733, 4421, 38989, 188, 4420, 25075, 36464, 42327, 44150, 51557, 54793, 9499, 10967, 46086, 52401, 58350, 25742, 35603, 4617, 3119, 4549, 54795, 4543, 4955, 18416, 19703, 45943, 46315, 48032, 54747, 47331, 47958, 51889, 53502) 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