Query Metrics
8
Database Queries
8
Different statements
4.72 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.67 ms (35.35%) |
1 |
SELECT f0_.art_nr AS art_nr_0, f0_.name AS name_1, f0_.id AS id_2, f0_.producer_id AS producer_id_3 FROM fireplace f0_ INNER JOIN scheme s1_ ON (s1_.fireplace_id = f0_.id) WHERE s1_.hidden = ?
Parameters:
[
0
]
|
0.74 ms (15.59%) |
1 |
SELECT p0_.hidden AS hidden_0, p0_.name AS name_1, p0_.id AS id_2 FROM producer p0_ WHERE p0_.hidden = ?
Parameters:
[
0
]
|
0.61 ms (12.92%) |
1 |
SELECT m0_.art_nr AS art_nr_0, m0_.nobb_nr AS nobb_nr_1, m0_.name AS name_2, m0_.price_ex_vat AS price_ex_vat_3, m0_.min_degrees_coverboards AS min_degrees_coverboards_4, m0_.max_degrees_coverboards AS max_degrees_coverboards_5, m0_.min_degrees_square_overlay AS min_degrees_square_overlay_6, m0_.max_degrees_square_overlay AS max_degrees_square_overlay_7, m0_.min_degrees_square_fittings AS min_degrees_square_fittings_8, m0_.max_degrees_square_fittings AS max_degrees_square_fittings_9, m0_.min_degrees_round_pipe AS min_degrees_round_pipe_10, m0_.max_degrees_round_pipe AS max_degrees_round_pipe_11, m0_.degrees_on_ceilings_not_in_use AS degrees_on_ceilings_not_in_use_12, m0_.degrees_angle AS degrees_angle_13, m0_.min_degrees_could_be_seized_round AS min_degrees_could_be_seized_round_14, m0_.max_degrees_could_be_seized_round AS max_degrees_could_be_seized_round_15, m0_.building_length AS building_length_16, m0_.alt_building_length AS alt_building_length_17, m0_.building_width AS building_width_18, m0_.horizontal_length AS horizontal_length_19, m0_.managed_by_fireplace AS managed_by_fireplace_20, m0_.start_module AS start_module_21, m0_.always AS always_22, m0_.a_gt_23 AS a_gt_23_23, m0_.a_lt_23 AS a_lt_23_24, m0_.min_h AS min_h_25, m0_.max_h AS max_h_26, m0_.id AS id_27, m0_.color_id AS color_id_28, m0_.format_id AS format_id_29, m0_.module_from_id AS module_from_id_30, m0_.module_to_id AS module_to_id_31, m0_.module_category_id AS module_category_id_32, m0_.type_id AS type_id_33, m0_.pipe_id AS pipe_id_34, m0_.cover_plate_id AS cover_plate_id_35 FROM module m0_ WHERE m0_.managed_by_fireplace = ? AND m0_.module_category_id = ?
Parameters:
[ 1 6 ] |
0.40 ms (8.47%) |
1 |
SELECT t0.diameter AS diameter_1, t0.id AS id_2 FROM pipe t0
Parameters:
[] |
0.38 ms (8.03%) |
1 |
SELECT t0.category AS category_1, t0.id AS id_2 FROM module_category t0 WHERE t0.category = ? LIMIT 1
Parameters:
[
"Ventilation2"
]
|
0.31 ms (6.63%) |
1 |
SELECT t0.name AS name_1, t0.num_floors AS num_floors_2, t0.has_attic AS has_attic_3, t0.id AS id_4 FROM floor t0
Parameters:
[] |
0.31 ms (6.52%) |
1 |
SELECT t0.type AS type_1, t0.id AS id_2 FROM roof_type t0
Parameters:
[] |
0.31 ms (6.48%) |
1 |
SELECT t0.color AS color_1, t0.id AS id_2 FROM color t0
Parameters:
[] |
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 |
---|---|
Nordpeis\Bundle\CalculatorBundle\Entity\Producer | No errors. |
Nordpeis\Bundle\CalculatorBundle\Entity\Fireplace | No errors. |
Nordpeis\Bundle\CalculatorBundle\Entity\Scheme | No errors. |
Nordpeis\Bundle\CalculatorBundle\Entity\Pipe | No errors. |
Nordpeis\Bundle\CalculatorBundle\Entity\Floor | No errors. |
Nordpeis\Bundle\CalculatorBundle\Entity\RoofType | No errors. |
Nordpeis\Bundle\CalculatorBundle\Entity\Module | No errors. |
Nordpeis\Bundle\CalculatorBundle\Entity\Color | No errors. |
Nordpeis\Bundle\CalculatorBundle\Entity\ModuleCategory | No errors. |
Nordpeis\Bundle\CalculatorBundle\Entity\Format | No errors. |
Nordpeis\Bundle\CalculatorBundle\Entity\Type | No errors. |
Nordpeis\Bundle\CalculatorBundle\Entity\CoverPlate | No errors. |