Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.91 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection

#▲	Time	Info
1	0.29 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.47 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	1.14 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: [537 634 684 713 1934 1998 2006 2597 2623 2624 2939 3394 4474 4686 4965 5188 6352 6359 7416 8079 8700 8785 8808 9201 9208 9262 11540 11639 11738 11908 11994 12228 12296 14645 18445 18838 20512 21709 23654 25254 27730 28093 32350 33354 34553 34650 34757 35197 11462 5769 1930 2016 6412 38854 39015 39194 39248 39400 39457 39733 8796 24203 30416 17552 33453 13158 40835 25938 2038 38567 4973 36827 40550 3552 29286 22094 27159 32548 11626 11664 38659 35970 5770 5772 20397 20398 20399 9330 20592 3958 42319 42315 42314 42313 42316 788 42309 42320 42344 42342 42359 42357 42363 42362 42368 42367 42366 42369 42352 42376 42374 42372 5054 11985 31413 10716 42509 2327 11252 28282 39722 3442 4693 17605 40007 40081 40325 40433 23996 11891 25205 40431 39778 1132 34048 5119 10917 28270 39762 26070 13162 28090 37924 37670 40405 19163 28283 43132 39802 11311 29561 8166 11770 16477 34168 40495 41451 41472 42134 25941 9293 40666 18002 13931 40783 28865 4586 16842 38575 8881 29945 9388 31414 37926 2583 11607 43052 30012 37815 42641 22557 33375 24422 9290 38229 38301 7317 18834 7434 38186 962 4852 38460 11625 13814 18069 24402 33126 42413 6222 3069 10910 4003 4115 9461 5566 42440 7678 29293 30038 34807 35598 3517 25618 33398 4776 6131 7650 9600 11605 36458 36492 38445 11172 12746 13620 21234 21277 23963 42502 43383 7455 7482 7490 7647 12515 22248 24412 28307 32026 32866 36342 36491 37420 38039 38450 40488 40492 41036 41838 3211 33027 37791 11220 13636 20498 26426 26583 32109 9655 30040 32415 9688 965 4553 17585 17708 20094 20543 31045 31486 38238 39796 9787 13866 2326 4651 5897 6477 6669 9216 9241 9541 10529 11667 24896 28124 29104 30172 31857 34035 38730 38849 39004 40520 42668 9302 33904 35729 987 7535 30246 36295 41587 34209 40709 41305 28859 44716 44717 44735 44726 8912 12206 38853 40234 42483 7665 14103 28627 38239 38515 38839 38987 45095 20971 23655 45683 45684 4002 15942 45686 45726 45727 40115 45687 45682 45783 8612 40841 29292 40936 45787 45790 45782 36477 45805 40487 45828 45829 45830 38453 45940 45945 17773 5875 43774 6727 41648 46022 46023 46025 314 43336 1085 46063 38338 45847 38638 37096 40318 8670 1171 9466 9543 23584 23586 35685 36469 40265 11846 22480 32856 40251 11759 43894 35956 2469 39798 37230 45730 13735 2342 11780 17576 17592 17901 25609 40578 46112 44346 29962 30028 33807 21087 1574 2760 3994 18083 42979 17774 21693 26559 8149 42282 46327 664 8608 11519 12073 18662 25525 39750 41039 43426 4039 11544 42152 18675 2799 17897 22427 25161 40411 54764 6168 19128 4435 28050 48695 54516 3055 52225 50992 50994 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 (537, 634, 684, 713, 1934, 1998, 2006, 2597, 2623, 2624, 2939, 3394, 4474, 4686, 4965, 5188, 6352, 6359, 7416, 8079, 8700, 8785, 8808, 9201, 9208, 9262, 11540, 11639, 11738, 11908, 11994, 12228, 12296, 14645, 18445, 18838, 20512, 21709, 23654, 25254, 27730, 28093, 32350, 33354, 34553, 34650, 34757, 35197, 11462, 5769, 1930, 2016, 6412, 38854, 39015, 39194, 39248, 39400, 39457, 39733, 8796, 24203, 30416, 17552, 33453, 13158, 40835, 25938, 2038, 38567, 4973, 36827, 40550, 3552, 29286, 22094, 27159, 32548, 11626, 11664, 38659, 35970, 5770, 5772, 20397, 20398, 20399, 9330, 20592, 3958, 42319, 42315, 42314, 42313, 42316, 788, 42309, 42320, 42344, 42342, 42359, 42357, 42363, 42362, 42368, 42367, 42366, 42369, 42352, 42376, 42374, 42372, 5054, 11985, 31413, 10716, 42509, 2327, 11252, 28282, 39722, 3442, 4693, 17605, 40007, 40081, 40325, 40433, 23996, 11891, 25205, 40431, 39778, 1132, 34048, 5119, 10917, 28270, 39762, 26070, 13162, 28090, 37924, 37670, 40405, 19163, 28283, 43132, 39802, 11311, 29561, 8166, 11770, 16477, 34168, 40495, 41451, 41472, 42134, 25941, 9293, 40666, 18002, 13931, 40783, 28865, 4586, 16842, 38575, 8881, 29945, 9388, 31414, 37926, 2583, 11607, 43052, 30012, 37815, 42641, 22557, 33375, 24422, 9290, 38229, 38301, 7317, 18834, 7434, 38186, 962, 4852, 38460, 11625, 13814, 18069, 24402, 33126, 42413, 6222, 3069, 10910, 4003, 4115, 9461, 5566, 42440, 7678, 29293, 30038, 34807, 35598, 3517, 25618, 33398, 4776, 6131, 7650, 9600, 11605, 36458, 36492, 38445, 11172, 12746, 13620, 21234, 21277, 23963, 42502, 43383, 7455, 7482, 7490, 7647, 12515, 22248, 24412, 28307, 32026, 32866, 36342, 36491, 37420, 38039, 38450, 40488, 40492, 41036, 41838, 3211, 33027, 37791, 11220, 13636, 20498, 26426, 26583, 32109, 9655, 30040, 32415, 9688, 965, 4553, 17585, 17708, 20094, 20543, 31045, 31486, 38238, 39796, 9787, 13866, 2326, 4651, 5897, 6477, 6669, 9216, 9241, 9541, 10529, 11667, 24896, 28124, 29104, 30172, 31857, 34035, 38730, 38849, 39004, 40520, 42668, 9302, 33904, 35729, 987, 7535, 30246, 36295, 41587, 34209, 40709, 41305, 28859, 44716, 44717, 44735, 44726, 8912, 12206, 38853, 40234, 42483, 7665, 14103, 28627, 38239, 38515, 38839, 38987, 45095, 20971, 23655, 45683, 45684, 4002, 15942, 45686, 45726, 45727, 40115, 45687, 45682, 45783, 8612, 40841, 29292, 40936, 45787, 45790, 45782, 36477, 45805, 40487, 45828, 45829, 45830, 38453, 45940, 45945, 17773, 5875, 43774, 6727, 41648, 46022, 46023, 46025, 314, 43336, 1085, 46063, 38338, 45847, 38638, 37096, 40318, 8670, 1171, 9466, 9543, 23584, 23586, 35685, 36469, 40265, 11846, 22480, 32856, 40251, 11759, 43894, 35956, 2469, 39798, 37230, 45730, 13735, 2342, 11780, 17576, 17592, 17901, 25609, 40578, 46112, 44346, 29962, 30028, 33807, 21087, 1574, 2760, 3994, 18083, 42979, 17774, 21693, 26559, 8149, 42282, 46327, 664, 8608, 11519, 12073, 18662, 25525, 39750, 41039, 43426, 4039, 11544, 42152, 18675, 2799, 17897, 22427, 25161, 40411, 54764, 6168, 19128, 4435, 28050, 48695, 54516, 3055, 52225, 50992, 50994) AND (s0_.stock - s0_.reservation) > 0 AND s0_.supplier_id IN (6) ORDER BY s1_.priority ASC, s0_.purchase_price ASC;

#▲

Time

Info

0.29 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.47 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);

1.14 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 (537, 634, 684, 713, 1934, 1998, 2006, 2597, 2623, 2624, 2939, 3394, 4474, 4686, 4965, 5188, 6352, 6359, 7416, 8079, 8700, 8785, 8808, 9201, 9208, 9262, 11540, 11639, 11738, 11908, 11994, 12228, 12296, 14645, 18445, 18838, 20512, 21709, 23654, 25254, 27730, 28093, 32350, 33354, 34553, 34650, 34757, 35197, 11462, 5769, 1930, 2016, 6412, 38854, 39015, 39194, 39248, 39400, 39457, 39733, 8796, 24203, 30416, 17552, 33453, 13158, 40835, 25938, 2038, 38567, 4973, 36827, 40550, 3552, 29286, 22094, 27159, 32548, 11626, 11664, 38659, 35970, 5770, 5772, 20397, 20398, 20399, 9330, 20592, 3958, 42319, 42315, 42314, 42313, 42316, 788, 42309, 42320, 42344, 42342, 42359, 42357, 42363, 42362, 42368, 42367, 42366, 42369, 42352, 42376, 42374, 42372, 5054, 11985, 31413, 10716, 42509, 2327, 11252, 28282, 39722, 3442, 4693, 17605, 40007, 40081, 40325, 40433, 23996, 11891, 25205, 40431, 39778, 1132, 34048, 5119, 10917, 28270, 39762, 26070, 13162, 28090, 37924, 37670, 40405, 19163, 28283, 43132, 39802, 11311, 29561, 8166, 11770, 16477, 34168, 40495, 41451, 41472, 42134, 25941, 9293, 40666, 18002, 13931, 40783, 28865, 4586, 16842, 38575, 8881, 29945, 9388, 31414, 37926, 2583, 11607, 43052, 30012, 37815, 42641, 22557, 33375, 24422, 9290, 38229, 38301, 7317, 18834, 7434, 38186, 962, 4852, 38460, 11625, 13814, 18069, 24402, 33126, 42413, 6222, 3069, 10910, 4003, 4115, 9461, 5566, 42440, 7678, 29293, 30038, 34807, 35598, 3517, 25618, 33398, 4776, 6131, 7650, 9600, 11605, 36458, 36492, 38445, 11172, 12746, 13620, 21234, 21277, 23963, 42502, 43383, 7455, 7482, 7490, 7647, 12515, 22248, 24412, 28307, 32026, 32866, 36342, 36491, 37420, 38039, 38450, 40488, 40492, 41036, 41838, 3211, 33027, 37791, 11220, 13636, 20498, 26426, 26583, 32109, 9655, 30040, 32415, 9688, 965, 4553, 17585, 17708, 20094, 20543, 31045, 31486, 38238, 39796, 9787, 13866, 2326, 4651, 5897, 6477, 6669, 9216, 9241, 9541, 10529, 11667, 24896, 28124, 29104, 30172, 31857, 34035, 38730, 38849, 39004, 40520, 42668, 9302, 33904, 35729, 987, 7535, 30246, 36295, 41587, 34209, 40709, 41305, 28859, 44716, 44717, 44735, 44726, 8912, 12206, 38853, 40234, 42483, 7665, 14103, 28627, 38239, 38515, 38839, 38987, 45095, 20971, 23655, 45683, 45684, 4002, 15942, 45686, 45726, 45727, 40115, 45687, 45682, 45783, 8612, 40841, 29292, 40936, 45787, 45790, 45782, 36477, 45805, 40487, 45828, 45829, 45830, 38453, 45940, 45945, 17773, 5875, 43774, 6727, 41648, 46022, 46023, 46025, 314, 43336, 1085, 46063, 38338, 45847, 38638, 37096, 40318, 8670, 1171, 9466, 9543, 23584, 23586, 35685, 36469, 40265, 11846, 22480, 32856, 40251, 11759, 43894, 35956, 2469, 39798, 37230, 45730, 13735, 2342, 11780, 17576, 17592, 17901, 25609, 40578, 46112, 44346, 29962, 30028, 33807, 21087, 1574, 2760, 3994, 18083, 42979, 17774, 21693, 26559, 8149, 42282, 46327, 664, 8608, 11519, 12073, 18662, 25525, 39750, 41039, 43426, 4039, 11544, 42152, 18675, 2799, 17897, 22427, 25161, 40411, 54764, 6168, 19128, 4435, 28050, 48695, 54516, 3055, 52225, 50992, 50994) 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