Symfony Profiler

INSERT INTO gauge_dataset_task (
  dataset, item_class, item_id, date_from,
  created_at, weight, gauge_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO gauge_dataset_task (dataset, item_class, item_id, date_from, created_at, weight, gauge_id) VALUES (2, NULL, NULL, '2026-07-24 21:00:00', '2026-07-26 20:24:21', 1, 6493);

SELECT
  t0.id AS id_1,
  t0.level AS level_2,
  t0.type AS type_3,
  t0.primary_source AS primary_source_4,
  t0.primary_source_other AS primary_source_other_5,
  t0.name AS name_6,
  t0.qr_code_path AS qr_code_path_7,
  t0.measurement_target AS measurement_target_8,
  t0.remote AS remote_9,
  t0.remote_as_primary AS remote_as_primary_10,
  t0.show_in_output AS show_in_output_11,
  t0.data_in_results AS data_in_results_12,
  t0.last_sent_notification_at AS last_sent_notification_at_13,
  t0.updated_at AS updated_at_14,
  t0.created_at AS created_at_15,
  t0.disabled_at AS disabled_at_16,
  t0.disabled_reason AS disabled_reason_17,
  t0.building_id AS building_id_18,
  t0.parent AS parent_19,
  t20.id AS id_21,
  t20.customer_ico AS customer_ico_22,
  t20.customer_name AS customer_name_23,
  t20.customer_email AS customer_email_24,
  t20.customer_bank_account AS customer_bank_account_25,
  t20.identifier AS identifier_26,
  t20.ean_production AS ean_production_27,
  t20.supply_point_number AS supply_point_number_28,
  t20.meter_number AS meter_number_29,
  t20.gid AS gid_30,
  t20.model AS model_31,
  t20.location AS location_32,
  t20.consumption_type AS consumption_type_33,
  t20.measurement_type AS measurement_type_34,
  t20.reserved_power AS reserved_power_35,
  t20.reserved_capacity AS reserved_capacity_36,
  t20.daily_reserved_capacity AS daily_reserved_capacity_37,
  t20.daily_reserved_capacity_unit AS daily_reserved_capacity_unit_38,
  t20.note AS note_39,
  t20.distributor_link AS distributor_link_40,
  t20.invoice_period AS invoice_period_41,
  t20.invoice_deposit_period AS invoice_deposit_period_42,
  t20.involved_in_purchase AS involved_in_purchase_43,
  t20.central_delivery AS central_delivery_44,
  t20.supplier_contract_valid_to AS supplier_contract_valid_to_45,
  t20.payments_range AS payments_range_46,
  t20.costs_in_results AS costs_in_results_47,
  t20.force_low_tariff AS force_low_tariff_48,
  t20.force_special_tariff AS force_special_tariff_49,
  t20.invoice_income_period AS invoice_income_period_50,
  t20.production_buyer AS production_buyer_51,
  t20.supply_point_usage AS supply_point_usage_52,
  t20.annual_consumption AS annual_consumption_53,
  t20.gasometer_rate AS gasometer_rate_54,
  t20.tdd AS tdd_55,
  t20.tdd_el AS tdd_el_56,
  t20.overflow_fve AS overflow_fve_57,
  t20.production_type AS production_type_58,
  t20.electricity_sharing_consumption AS electricity_sharing_consumption_59,
  t20.electricity_sharing_production AS electricity_sharing_production_60,
  t20.gauge_id AS gauge_id_61,
  t20.supplier_id AS supplier_id_62,
  t63.id AS id_64,
  t63.init_date AS init_date_65,
  t63.connection_type AS connection_type_66,
  t63.device_type AS device_type_67,
  t63.data_sending_way AS data_sending_way_68,
  t63.sim_number AS sim_number_69,
  t63.output AS output_70,
  t63.pulse_quantity AS pulse_quantity_71,
  t63.digital_input AS digital_input_72,
  t63.power_input AS power_input_73,
  t63.last_battery_exchange AS last_battery_exchange_74,
  t63.other_info AS other_info_75,
  t63.gauge_id AS gauge_id_76,
  t0.photo_id AS photo_id_77,
  t0.el_dictributor_id AS el_dictributor_id_78,
  t0.import_id AS import_id_79,
  t0.created_by_id AS created_by_id_80,
  t0.updated_by_id AS updated_by_id_81,
  t0.disabled_by_id AS disabled_by_id_82
FROM
  gauges t0
  LEFT JOIN gauge_properties t20 ON t20.gauge_id = t0.id
  LEFT JOIN gauge_remote_properties t63 ON t63.gauge_id = t0.id
WHERE
  t0.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )

SELECT t0.id AS id_1, t0.level AS level_2, t0.type AS type_3, t0.primary_source AS primary_source_4, t0.primary_source_other AS primary_source_other_5, t0.name AS name_6, t0.qr_code_path AS qr_code_path_7, t0.measurement_target AS measurement_target_8, t0.remote AS remote_9, t0.remote_as_primary AS remote_as_primary_10, t0.show_in_output AS show_in_output_11, t0.data_in_results AS data_in_results_12, t0.last_sent_notification_at AS last_sent_notification_at_13, t0.updated_at AS updated_at_14, t0.created_at AS created_at_15, t0.disabled_at AS disabled_at_16, t0.disabled_reason AS disabled_reason_17, t0.building_id AS building_id_18, t0.parent AS parent_19, t20.id AS id_21, t20.customer_ico AS customer_ico_22, t20.customer_name AS customer_name_23, t20.customer_email AS customer_email_24, t20.customer_bank_account AS customer_bank_account_25, t20.identifier AS identifier_26, t20.ean_production AS ean_production_27, t20.supply_point_number AS supply_point_number_28, t20.meter_number AS meter_number_29, t20.gid AS gid_30, t20.model AS model_31, t20.location AS location_32, t20.consumption_type AS consumption_type_33, t20.measurement_type AS measurement_type_34, t20.reserved_power AS reserved_power_35, t20.reserved_capacity AS reserved_capacity_36, t20.daily_reserved_capacity AS daily_reserved_capacity_37, t20.daily_reserved_capacity_unit AS daily_reserved_capacity_unit_38, t20.note AS note_39, t20.distributor_link AS distributor_link_40, t20.invoice_period AS invoice_period_41, t20.invoice_deposit_period AS invoice_deposit_period_42, t20.involved_in_purchase AS involved_in_purchase_43, t20.central_delivery AS central_delivery_44, t20.supplier_contract_valid_to AS supplier_contract_valid_to_45, t20.payments_range AS payments_range_46, t20.costs_in_results AS costs_in_results_47, t20.force_low_tariff AS force_low_tariff_48, t20.force_special_tariff AS force_special_tariff_49, t20.invoice_income_period AS invoice_income_period_50, t20.production_buyer AS production_buyer_51, t20.supply_point_usage AS supply_point_usage_52, t20.annual_consumption AS annual_consumption_53, t20.gasometer_rate AS gasometer_rate_54, t20.tdd AS tdd_55, t20.tdd_el AS tdd_el_56, t20.overflow_fve AS overflow_fve_57, t20.production_type AS production_type_58, t20.electricity_sharing_consumption AS electricity_sharing_consumption_59, t20.electricity_sharing_production AS electricity_sharing_production_60, t20.gauge_id AS gauge_id_61, t20.supplier_id AS supplier_id_62, t63.id AS id_64, t63.init_date AS init_date_65, t63.connection_type AS connection_type_66, t63.device_type AS device_type_67, t63.data_sending_way AS data_sending_way_68, t63.sim_number AS sim_number_69, t63.output AS output_70, t63.pulse_quantity AS pulse_quantity_71, t63.digital_input AS digital_input_72, t63.power_input AS power_input_73, t63.last_battery_exchange AS last_battery_exchange_74, t63.other_info AS other_info_75, t63.gauge_id AS gauge_id_76, t0.photo_id AS photo_id_77, t0.el_dictributor_id AS el_dictributor_id_78, t0.import_id AS import_id_79, t0.created_by_id AS created_by_id_80, t0.updated_by_id AS updated_by_id_81, t0.disabled_by_id AS disabled_by_id_82 FROM gauges t0 LEFT JOIN gauge_properties t20 ON t20.gauge_id = t0.id LEFT JOIN gauge_remote_properties t63 ON t63.gauge_id = t0.id WHERE t0.id IN (6520, 6557, 6643, 8760, 6548, 6533, 6639, 8761, 6525, 6506, 6538, 6543, 6674, 6668, 8477, 6494, 7824, 7825, 6655, 6665, 6637, 6523, 6671, 6661, 6493, 6678, 10411, 8257, 6513, 6552, 6807, 7059, 7195, 6928, 7192, 6913, 7071, 6795, 7065, 6923, 6832, 6924, 7076, 6817, 6515, 6857, 6917, 6840, 6811, 7141, 6738, 7054, 6835, 6828, 6775, 6724, 6741, 6784, 7048, 6871, 6706, 6788, 7170, 7165, 6780, 6709, 6875, 6750, 6850, 7164, 6895, 6720, 6712, 6759, 7119, 6906, 7149, 6755, 7204, 6845, 6889, 6865, 7093, 6854, 7034, 7038, 6822, 7197, 6767, 7061, 7106, 7144, 7060, 7103, 12093, 7166, 12305, 6744, 7096, 6763, 12248, 6902, 7180, 6770, 7186, 14619, 12243);

SELECT
  t0.id AS id_1,
  t0.dataset AS dataset_2,
  t0.item_class AS item_class_3,
  t0.item_id AS item_id_4,
  t0.date_from AS date_from_5,
  t0.created_at AS created_at_6,
  t0.weight AS weight_7,
  t0.gauge_id AS gauge_id_8
FROM
  gauge_dataset_task t0
WHERE
  t0.gauge_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )
  AND t0.dataset = ?

SELECT t0.id AS id_1, t0.dataset AS dataset_2, t0.item_class AS item_class_3, t0.item_id AS item_id_4, t0.date_from AS date_from_5, t0.created_at AS created_at_6, t0.weight AS weight_7, t0.gauge_id AS gauge_id_8 FROM gauge_dataset_task t0 WHERE t0.gauge_id IN (6520, 6557, 6643, 8760, 6548, 6533, 6639, 8761, 6525, 6506, 6538, 6543, 6674, 6668, 8477, 6494, 7824, 7825, 6655, 6665, 6637, 6523, 6671, 6661, 6493, 6678, 10411, 8257, 6513, 6552, 6807, 7059, 7195, 6928, 7192, 6913, 7071, 6795, 7065, 6923, 6832, 6924, 7076, 6817, 6515, 6857, 6917, 6840, 6811, 7141, 6738, 7054, 6835, 6828, 6775, 6724, 6741, 6784, 7048, 6871, 6706, 6788, 7170, 7165, 6780, 6709, 6875, 6750, 6850, 7164, 6895, 6720, 6712, 6759, 7119, 6906, 7149, 6755, 7204, 6845, 6889, 6865, 7093, 6854, 7034, 7038, 6822, 7197, 6767, 7061, 7106, 7144, 7060, 7103, 12093, 7166, 12305, 6744, 7096, 6763, 12248, 6902, 7180, 6770, 7186, 14619, 12243) AND t0.dataset = 2;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";