Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

2.74 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
1.66 ms (60.52%)	1	SELECT g0_.id AS id_0, g0_.level AS level_1, g0_.type AS type_2, g0_.primary_source AS primary_source_3, g0_.primary_source_other AS primary_source_other_4, g0_.name AS name_5, g0_.qr_code_path AS qr_code_path_6, g0_.measurement_target AS measurement_target_7, g0_.remote AS remote_8, g0_.remote_as_primary AS remote_as_primary_9, g0_.show_in_output AS show_in_output_10, g0_.data_in_results AS data_in_results_11, g0_.last_sent_notification_at AS last_sent_notification_at_12, g0_.updated_at AS updated_at_13, g0_.created_at AS created_at_14, g0_.disabled_at AS disabled_at_15, g0_.disabled_reason AS disabled_reason_16, g0_.building_id AS building_id_17, g0_.parent AS parent_18, g0_.photo_id AS photo_id_19, g0_.el_dictributor_id AS el_dictributor_id_20, g0_.import_id AS import_id_21, g0_.created_by_id AS created_by_id_22, g0_.updated_by_id AS updated_by_id_23, g0_.disabled_by_id AS disabled_by_id_24 FROM gauges g0_ INNER JOIN consumption_limit_gauge c2_ ON g0_.id = c2_.gauge_id INNER JOIN consumption_limit c1_ ON c1_.id = c2_.consumption_limit_id WHERE g0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c1_.enabled = 1 Parameters: [2122 14607 2150 2140 2143 2157 2158 2156 2160 2159 2111 2207 4332 2239 7776 2236 2146 7777 7779 7778 2161 2225 2102 14606 7673 2134 2135 2097 2098 2218 2166 7812 7619 2171 2201 2183 2232 7671 2107 2108 2222 2202 7809 2115 7672 7811 2191 2197 2190 2121 7674 2125 2126 2215 2152 4333 7678 2153 2209 2210 2133 7618 7621 14003 2090 2224 2216 2138 6702 7775 2177 2208 11824 2112 2228 7726 2235 2120 7728 5928 2172 5927 7749 8446 7834 7761 7764 2205 2095 14589 2185 2195 2186 12343 2145 7808 7677 4330 7765 2234 2099 2139 2193 2198 2187 2117 8837 2184 2109 2162 2091 2219 2110 6694 2203 2103 2168 2167 6695 2211 2151 2147 2148 2137 7573 7664 7665 7781 7667 7668 7670 7666 12474 2096 2238 2223 2173 2130 2129 2131 2188 2189 14645 14605 2104 2105 8449 14604 2164 14603 14602] View formatted query View runnable query Explain query SELECT g0_.id AS id_0, g0_.level AS level_1, g0_.type AS type_2, g0_.primary_source AS primary_source_3, g0_.primary_source_other AS primary_source_other_4, g0_.name AS name_5, g0_.qr_code_path AS qr_code_path_6, g0_.measurement_target AS measurement_target_7, g0_.remote AS remote_8, g0_.remote_as_primary AS remote_as_primary_9, g0_.show_in_output AS show_in_output_10, g0_.data_in_results AS data_in_results_11, g0_.last_sent_notification_at AS last_sent_notification_at_12, g0_.updated_at AS updated_at_13, g0_.created_at AS created_at_14, g0_.disabled_at AS disabled_at_15, g0_.disabled_reason AS disabled_reason_16, g0_.building_id AS building_id_17, g0_.parent AS parent_18, g0_.photo_id AS photo_id_19, g0_.el_dictributor_id AS el_dictributor_id_20, g0_.import_id AS import_id_21, g0_.created_by_id AS created_by_id_22, g0_.updated_by_id AS updated_by_id_23, g0_.disabled_by_id AS disabled_by_id_24 FROM gauges g0_ INNER JOIN consumption_limit_gauge c2_ ON g0_.id = c2_.gauge_id INNER JOIN consumption_limit c1_ ON c1_.id = c2_.consumption_limit_id WHERE g0_.id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND c1_.enabled = 1 SELECT g0_.id AS id_0, g0_.level AS level_1, g0_.type AS type_2, g0_.primary_source AS primary_source_3, g0_.primary_source_other AS primary_source_other_4, g0_.name AS name_5, g0_.qr_code_path AS qr_code_path_6, g0_.measurement_target AS measurement_target_7, g0_.remote AS remote_8, g0_.remote_as_primary AS remote_as_primary_9, g0_.show_in_output AS show_in_output_10, g0_.data_in_results AS data_in_results_11, g0_.last_sent_notification_at AS last_sent_notification_at_12, g0_.updated_at AS updated_at_13, g0_.created_at AS created_at_14, g0_.disabled_at AS disabled_at_15, g0_.disabled_reason AS disabled_reason_16, g0_.building_id AS building_id_17, g0_.parent AS parent_18, g0_.photo_id AS photo_id_19, g0_.el_dictributor_id AS el_dictributor_id_20, g0_.import_id AS import_id_21, g0_.created_by_id AS created_by_id_22, g0_.updated_by_id AS updated_by_id_23, g0_.disabled_by_id AS disabled_by_id_24 FROM gauges g0_ INNER JOIN consumption_limit_gauge c2_ ON g0_.id = c2_.gauge_id INNER JOIN consumption_limit c1_ ON c1_.id = c2_.consumption_limit_id WHERE g0_.id IN (2122, 14607, 2150, 2140, 2143, 2157, 2158, 2156, 2160, 2159, 2111, 2207, 4332, 2239, 7776, 2236, 2146, 7777, 7779, 7778, 2161, 2225, 2102, 14606, 7673, 2134, 2135, 2097, 2098, 2218, 2166, 7812, 7619, 2171, 2201, 2183, 2232, 7671, 2107, 2108, 2222, 2202, 7809, 2115, 7672, 7811, 2191, 2197, 2190, 2121, 7674, 2125, 2126, 2215, 2152, 4333, 7678, 2153, 2209, 2210, 2133, 7618, 7621, 14003, 2090, 2224, 2216, 2138, 6702, 7775, 2177, 2208, 11824, 2112, 2228, 7726, 2235, 2120, 7728, 5928, 2172, 5927, 7749, 8446, 7834, 7761, 7764, 2205, 2095, 14589, 2185, 2195, 2186, 12343, 2145, 7808, 7677, 4330, 7765, 2234, 2099, 2139, 2193, 2198, 2187, 2117, 8837, 2184, 2109, 2162, 2091, 2219, 2110, 6694, 2203, 2103, 2168, 2167, 6695, 2211, 2151, 2147, 2148, 2137, 7573, 7664, 7665, 7781, 7667, 7668, 7670, 7666, 12474, 2096, 2238, 2223, 2173, 2130, 2129, 2131, 2188, 2189, 14645, 14605, 2104, 2105, 8449, 14604, 2164, 14603, 14602) AND c1_.enabled = 1;
1.08 ms (39.48%)	1	SELECT t0.id AS id_1, t0.control_from AS control_from_2, t0.updated_at AS updated_at_3, t0.created_at AS created_at_4, t0.gauge_id AS gauge_id_5 FROM gauge_control_task t0 WHERE t0.gauge_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [2122 14607 2150 2140 2143 2157 2158 2156 2160 2159 2111 2207 4332 2239 7776 2236 2146 7777 7779 7778 2161 2225 2102 14606 7673 2134 2135 2097 2098 2218 2166 7812 7619 2171 2201 2183 2232 7671 2107 2108 2222 2202 7809 2115 7672 7811 2191 2197 2190 2121 7674 2125 2126 2215 2152 4333 7678 2153 2209 2210 2133 7618 7621 14003 2090 2224 2216 2138 6702 7775 2177 2208 11824 2112 2228 7726 2235 2120 7728 5928 2172 5927 7749 8446 7834 7761 7764 2205 2095 14589 2185 2195 2186 12343 2145 7808 7677 4330 7765 2234 2099 2139 2193 2198 2187 2117 8837 2184 2109 2162 2091 2219 2110 6694 2203 2103 2168 2167 6695 2211 2151 2147 2148 2137 7573 7664 7665 7781 7667 7668 7670 7666 12474 2096 2238 2223 2173 2130 2129 2131 2188 2189 14645 14605 2104 2105 8449 14604 2164 14603 14602] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.control_from AS control_from_2, t0.updated_at AS updated_at_3, t0.created_at AS created_at_4, t0.gauge_id AS gauge_id_5 FROM gauge_control_task t0 WHERE t0.gauge_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) SELECT t0.id AS id_1, t0.control_from AS control_from_2, t0.updated_at AS updated_at_3, t0.created_at AS created_at_4, t0.gauge_id AS gauge_id_5 FROM gauge_control_task t0 WHERE t0.gauge_id IN (2122, 14607, 2150, 2140, 2143, 2157, 2158, 2156, 2160, 2159, 2111, 2207, 4332, 2239, 7776, 2236, 2146, 7777, 7779, 7778, 2161, 2225, 2102, 14606, 7673, 2134, 2135, 2097, 2098, 2218, 2166, 7812, 7619, 2171, 2201, 2183, 2232, 7671, 2107, 2108, 2222, 2202, 7809, 2115, 7672, 7811, 2191, 2197, 2190, 2121, 7674, 2125, 2126, 2215, 2152, 4333, 7678, 2153, 2209, 2210, 2133, 7618, 7621, 14003, 2090, 2224, 2216, 2138, 6702, 7775, 2177, 2208, 11824, 2112, 2228, 7726, 2235, 2120, 7728, 5928, 2172, 5927, 7749, 8446, 7834, 7761, 7764, 2205, 2095, 14589, 2185, 2195, 2186, 12343, 2145, 7808, 7677, 4330, 7765, 2234, 2099, 2139, 2193, 2198, 2187, 2117, 8837, 2184, 2109, 2162, 2091, 2219, 2110, 6694, 2203, 2103, 2168, 2167, 6695, 2211, 2151, 2147, 2148, 2137, 7573, 7664, 7665, 7781, 7667, 7668, 7670, 7666, 12474, 2096, 2238, 2223, 2173, 2130, 2129, 2131, 2188, 2189, 14645, 14605, 2104, 2105, 8449, 14604, 2164, 14603, 14602);

Time▼

Count

Info

1.66 ms
(60.52%)

SELECT g0_.id AS id_0, g0_.level AS level_1, g0_.type AS type_2, g0_.primary_source AS primary_source_3, g0_.primary_source_other AS primary_source_other_4, g0_.name AS name_5, g0_.qr_code_path AS qr_code_path_6, g0_.measurement_target AS measurement_target_7, g0_.remote AS remote_8, g0_.remote_as_primary AS remote_as_primary_9, g0_.show_in_output AS show_in_output_10, g0_.data_in_results AS data_in_results_11, g0_.last_sent_notification_at AS last_sent_notification_at_12, g0_.updated_at AS updated_at_13, g0_.created_at AS created_at_14, g0_.disabled_at AS disabled_at_15, g0_.disabled_reason AS disabled_reason_16, g0_.building_id AS building_id_17, g0_.parent AS parent_18, g0_.photo_id AS photo_id_19, g0_.el_dictributor_id AS el_dictributor_id_20, g0_.import_id AS import_id_21, g0_.created_by_id AS created_by_id_22, g0_.updated_by_id AS updated_by_id_23, g0_.disabled_by_id AS disabled_by_id_24 FROM gauges g0_ INNER JOIN consumption_limit_gauge c2_ ON g0_.id = c2_.gauge_id INNER JOIN consumption_limit c1_ ON c1_.id = c2_.consumption_limit_id WHERE g0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c1_.enabled = 1

Parameters:

View formatted query View runnable query Explain query

SELECT
  g0_.id AS id_0,
  g0_.level AS level_1,
  g0_.type AS type_2,
  g0_.primary_source AS primary_source_3,
  g0_.primary_source_other AS primary_source_other_4,
  g0_.name AS name_5,
  g0_.qr_code_path AS qr_code_path_6,
  g0_.measurement_target AS measurement_target_7,
  g0_.remote AS remote_8,
  g0_.remote_as_primary AS remote_as_primary_9,
  g0_.show_in_output AS show_in_output_10,
  g0_.data_in_results AS data_in_results_11,
  g0_.last_sent_notification_at AS last_sent_notification_at_12,
  g0_.updated_at AS updated_at_13,
  g0_.created_at AS created_at_14,
  g0_.disabled_at AS disabled_at_15,
  g0_.disabled_reason AS disabled_reason_16,
  g0_.building_id AS building_id_17,
  g0_.parent AS parent_18,
  g0_.photo_id AS photo_id_19,
  g0_.el_dictributor_id AS el_dictributor_id_20,
  g0_.import_id AS import_id_21,
  g0_.created_by_id AS created_by_id_22,
  g0_.updated_by_id AS updated_by_id_23,
  g0_.disabled_by_id AS disabled_by_id_24
FROM
  gauges g0_
  INNER JOIN consumption_limit_gauge c2_ ON g0_.id = c2_.gauge_id
  INNER JOIN consumption_limit c1_ ON c1_.id = c2_.consumption_limit_id
WHERE
  g0_.id IN (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )
  AND c1_.enabled = 1

SELECT g0_.id AS id_0, g0_.level AS level_1, g0_.type AS type_2, g0_.primary_source AS primary_source_3, g0_.primary_source_other AS primary_source_other_4, g0_.name AS name_5, g0_.qr_code_path AS qr_code_path_6, g0_.measurement_target AS measurement_target_7, g0_.remote AS remote_8, g0_.remote_as_primary AS remote_as_primary_9, g0_.show_in_output AS show_in_output_10, g0_.data_in_results AS data_in_results_11, g0_.last_sent_notification_at AS last_sent_notification_at_12, g0_.updated_at AS updated_at_13, g0_.created_at AS created_at_14, g0_.disabled_at AS disabled_at_15, g0_.disabled_reason AS disabled_reason_16, g0_.building_id AS building_id_17, g0_.parent AS parent_18, g0_.photo_id AS photo_id_19, g0_.el_dictributor_id AS el_dictributor_id_20, g0_.import_id AS import_id_21, g0_.created_by_id AS created_by_id_22, g0_.updated_by_id AS updated_by_id_23, g0_.disabled_by_id AS disabled_by_id_24 FROM gauges g0_ INNER JOIN consumption_limit_gauge c2_ ON g0_.id = c2_.gauge_id INNER JOIN consumption_limit c1_ ON c1_.id = c2_.consumption_limit_id WHERE g0_.id IN (2122, 14607, 2150, 2140, 2143, 2157, 2158, 2156, 2160, 2159, 2111, 2207, 4332, 2239, 7776, 2236, 2146, 7777, 7779, 7778, 2161, 2225, 2102, 14606, 7673, 2134, 2135, 2097, 2098, 2218, 2166, 7812, 7619, 2171, 2201, 2183, 2232, 7671, 2107, 2108, 2222, 2202, 7809, 2115, 7672, 7811, 2191, 2197, 2190, 2121, 7674, 2125, 2126, 2215, 2152, 4333, 7678, 2153, 2209, 2210, 2133, 7618, 7621, 14003, 2090, 2224, 2216, 2138, 6702, 7775, 2177, 2208, 11824, 2112, 2228, 7726, 2235, 2120, 7728, 5928, 2172, 5927, 7749, 8446, 7834, 7761, 7764, 2205, 2095, 14589, 2185, 2195, 2186, 12343, 2145, 7808, 7677, 4330, 7765, 2234, 2099, 2139, 2193, 2198, 2187, 2117, 8837, 2184, 2109, 2162, 2091, 2219, 2110, 6694, 2203, 2103, 2168, 2167, 6695, 2211, 2151, 2147, 2148, 2137, 7573, 7664, 7665, 7781, 7667, 7668, 7670, 7666, 12474, 2096, 2238, 2223, 2173, 2130, 2129, 2131, 2188, 2189, 14645, 14605, 2104, 2105, 8449, 14604, 2164, 14603, 14602) AND c1_.enabled = 1;

1.08 ms
(39.48%)

SELECT t0.id AS id_1, t0.control_from AS control_from_2, t0.updated_at AS updated_at_3, t0.created_at AS created_at_4, t0.gauge_id AS gauge_id_5 FROM gauge_control_task t0 WHERE t0.gauge_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.control_from AS control_from_2,
  t0.updated_at AS updated_at_3,
  t0.created_at AS created_at_4,
  t0.gauge_id AS gauge_id_5
FROM
  gauge_control_task t0
WHERE
  t0.gauge_id IN (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )

SELECT t0.id AS id_1, t0.control_from AS control_from_2, t0.updated_at AS updated_at_3, t0.created_at AS created_at_4, t0.gauge_id AS gauge_id_5 FROM gauge_control_task t0 WHERE t0.gauge_id IN (2122, 14607, 2150, 2140, 2143, 2157, 2158, 2156, 2160, 2159, 2111, 2207, 4332, 2239, 7776, 2236, 2146, 7777, 7779, 7778, 2161, 2225, 2102, 14606, 7673, 2134, 2135, 2097, 2098, 2218, 2166, 7812, 7619, 2171, 2201, 2183, 2232, 7671, 2107, 2108, 2222, 2202, 7809, 2115, 7672, 7811, 2191, 2197, 2190, 2121, 7674, 2125, 2126, 2215, 2152, 4333, 7678, 2153, 2209, 2210, 2133, 7618, 7621, 14003, 2090, 2224, 2216, 2138, 6702, 7775, 2177, 2208, 11824, 2112, 2228, 7726, 2235, 2120, 7728, 5928, 2172, 5927, 7749, 8446, 7834, 7761, 7764, 2205, 2095, 14589, 2185, 2195, 2186, 12343, 2145, 7808, 7677, 4330, 7765, 2234, 2099, 2139, 2193, 2198, 2187, 2117, 8837, 2184, 2109, 2162, 2091, 2219, 2110, 6694, 2203, 2103, 2168, 2167, 6695, 2211, 2151, 2147, 2148, 2137, 7573, 7664, 7665, 7781, 7667, 7668, 7670, 7666, 12474, 2096, 2238, 2223, 2173, 2130, 2129, 2131, 2188, 2189, 14645, 14605, 2104, 2105, 8449, 14604, 2164, 14603, 14602);

Database Connections

Name	Service
default	doctrine.dbal.default_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\Gauge\GaugeControlTask	No errors.
App\Entity\Gauge\Gauge	The field App\Entity\Gauge\Gauge#contracts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ContractPrice\Contract#gauges does not contain the required 'inversedBy="contracts"' attribute.
App\Entity\Gauge\ConsumptionLimit	No errors.
App\Entity\Building\Building	No errors.
App\Entity\File	The field App\Entity\File#contracts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ContractPrice\Contract#file does not contain the required 'inversedBy="contracts"' attribute.
App\Entity\PriceDecision\Distributor	No errors.
App\Entity\Import\DataImport	No errors.
App\Entity\User	No errors.

Symfony Profiler

https://staging.e-manazer.cz/api-internal/remote-data-control

Configuration Settings

Theme