Query Metrics
21
Database Queries
14
Different statements
31.90 ms
Query time
0
Invalid entities
24
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.57 ms (14.31%) |
1 |
SELECT p0_.id AS id_0, p0_.ref AS ref_1, p0_.name AS name_2, p0_.slug AS slug_3, p0_.annonce AS annonce_4, p0_.piece AS piece_5, p0_.room AS room_6, p0_.surface_land AS surface_land_7, p0_.surface_home AS surface_home_8, p0_.dpe_at AS dpe_at_9, p0_.diag_dpe AS diag_dpe_10, p0_.diag_ges AS diag_ges_11, p0_.adress AS adress_12, p0_.complement AS complement_13, p0_.zipcode AS zipcode_14, p0_.city AS city_15, p0_.created_at AS created_at_16, p0_.updated_at AS updated_at_17, p0_.is_increating AS is_increating_18, p0_.reflastnumber AS reflastnumber_19, p0_.refnumdate AS refnumdate_20, p0_.ref_mandat AS ref_mandat_21, p0_.dpe_estimate_energy_down AS dpe_estimate_energy_down_22, p0_.dpe_estimate_energy_up AS dpe_estimate_energy_up_23, p0_.construction_at AS construction_at_24, p0_.price AS price_25, p0_.honoraires AS honoraires_26, p0_.price_fai AS price_fai_27, p0_.eea_year AS eea_year_28, p0_.number_avenant AS number_avenant_29, p0_.date_avenant AS date_avenant_30, p0_.is_with_exclusivity AS is_with_exclusivity_31, p0_.is_without_exclusivity AS is_without_exclusivity_32, p0_.is_semi_exclusivity AS is_semi_exclusivity_33, p0_.projet AS projet_34, p0_.diag_choice AS diag_choice_35, p0_.is_archived AS is_archived_36, p0_.mandat_at AS mandat_at_37, p0_.dup_mandat AS dup_mandat_38, p0_.is_nomandat AS is_nomandat_39, p0_.date_endmandat AS date_endmandat_40, p0_.archived_at AS archived_at_41, p0_.annonce_slug AS annonce_slug_42, p0_.rent AS rent_43, p0_.rent_charge AS rent_charge_44, p0_.is_transaction AS is_transaction_45, p0_.rent_charge_mods_payment AS rent_charge_mods_payment_46, p0_.warranty_deposit AS warranty_deposit_47, p0_.rent_charge_honoraire AS rent_charge_honoraire_48, p0_.commerce_annual_rent_global AS commerce_annual_rent_global_49, p0_.commerce_annual_charge_rent_global AS commerce_annual_charge_rent_global_50, p0_.commerce_annual_rent_meter AS commerce_annual_rent_meter_51, p0_.commerce_annual_charge_rent_meter AS commerce_annual_charge_rent_meter_52, p0_.commerce_charge_rent_month_ht AS commerce_charge_rent_month_ht_53, p0_.commerce_rent_annual_cc AS commerce_rent_annual_cc_54, p0_.commerce_rent_annual_ht AS commerce_rent_annual_ht_55, p0_.commerce_charge_rent_annual_ht AS commerce_charge_rent_annual_ht_56, p0_.commerce_rent_annual_meter_cc AS commerce_rent_annual_meter_cc_57, p0_.commerce_rent_annual_meter_ht AS commerce_rent_annual_meter_ht_58, p0_.commerce_charge_rent_annual_meter_ht AS commerce_charge_rent_annual_meter_ht_59, p0_.commerce_surface_divisible AS commerce_surface_divisible_60, p0_.commerce_surface_divisible_min AS commerce_surface_divisible_min_61, p0_.commerce_surface_divisible_max AS commerce_surface_divisible_max_62, p0_.rent_wall_month AS rent_wall_month_63, p0_.rent_cc AS rent_cc_64, p0_.rent_ht AS rent_ht_65, p0_.rent_honoraire AS rent_honoraire_66, p0_.commerce_rental_annual AS commerce_rental_annual_67, p0_.coord_long AS coord_long_68, p0_.coord_lat AS coord_lat_69, p0_.is_closed_folder AS is_closed_folder_70, p0_.qrcode_url AS qrcode_url_71, p0_.annonce_down AS annonce_down_72, p0_.add_link_auction AS add_link_auction_73, p0_.type_mandat AS type_mandat_74, c1_.other_pieces AS other_pieces_75, v2_.video_name AS video_name_76, v2_.path AS path_77, p0_.qrcode_url AS qrcode_url_78, p3_.name AS name_79, p0_.add_link_auction AS add_link_auction_80, p0_.eea_year AS eea_year_81, p0_.dup_mandat AS dup_mandat_82, p0_.is_archived AS is_archived_83, d4_.name AS name_84, p0_.id AS id_85, p0_.ref AS ref_86, p0_.ref_mandat AS ref_mandat_87, p0_.name AS name_88, p0_.annonce AS annonce_89, p0_.annonce_down AS annonce_down_90, p0_.piece AS piece_91, p0_.room AS room_92, e5_.id AS id_93, e5_.first_name AS first_name_94, e5_.last_name AS last_name_95, e5_.avatar_name AS avatar_name_96, c1_.washroom AS washroom_97, c1_.bathroom AS bathroom_98, c1_.terrace AS terrace_99, c1_.balcony AS balcony_100, c1_.wc AS wc_101, c1_.is_furnished AS is_furnished_102, p0_.surface_home AS surface_home_103, p0_.surface_land AS surface_land_104, p0_.dpe_estimate_energy_down AS dpe_estimate_energy_down_105, p0_.dpe_estimate_energy_up AS dpe_estimate_energy_up_106, p0_.eea_year AS eea_year_107, p0_.construction_at AS construction_at_108, p0_.price_fai AS price_fai_109, p0_.rent AS rent_110, p6_.name AS name_111, p0_.adress AS adress_112, p0_.complement AS complement_113, p0_.zipcode AS zipcode_114, p0_.city AS city_115, p0_.diag_choice AS diag_choice_116, p0_.diag_dpe AS diag_dpe_117, p0_.diag_ges AS diag_ges_118, p7_.name AS name_119, p8_.name AS name_120, p9_.name AS name_121, p10_.name AS name_122, p11_.name AS name_123, c1_.property_tax AS property_tax_124, c1_.disponibility AS disponibility_125, c1_.location AS location_126, c1_.disponibility_at AS disponibility_at_127, c1_.level AS level_128, c1_.coproperty AS coproperty_129, c1_.copropriety_taxe AS copropriety_taxe_130, p0_.created_at AS created_at_131, p0_.updated_at AS updated_at_132, p0_.ref_employed_id AS ref_employed_id_133, p0_.options_id AS options_id_134, p0_.publication_id AS publication_id_135, p0_.property_definition_id AS property_definition_id_136, p0_.sscategory_id AS sscategory_id_137, p0_.family_id AS family_id_138, p0_.rubric_id AS rubric_id_139, p0_.rubricss_id AS rubricss_id_140, p0_.video_id AS video_id_141 FROM property p0_ LEFT JOIN video v2_ ON p0_.video_id = v2_.id LEFT JOIN employed e5_ ON p0_.ref_employed_id = e5_.id LEFT JOIN complement c1_ ON p0_.options_id = c1_.id LEFT JOIN property_banner p12_ ON c1_.banner_id = p12_.id LEFT JOIN property_family p3_ ON p0_.family_id = p3_.id LEFT JOIN property_state p7_ ON c1_.property_state_id = p7_.id LEFT JOIN complement_property_energy c13_ ON c1_.id = c13_.complement_id LEFT JOIN property_energy p8_ ON p8_.id = c13_.property_energy_id LEFT JOIN property_orientation p9_ ON c1_.property_orientation_id = p9_.id LEFT JOIN complement_property_equipement c15_ ON c1_.id = c15_.complement_id LEFT JOIN property_equipement p14_ ON p14_.id = c15_.property_equipement_id LEFT JOIN property_definition p6_ ON p0_.property_definition_id = p6_.id LEFT JOIN property_typology p10_ ON c1_.property_typology_id = p10_.id LEFT JOIN property_family p16_ ON p0_.family_id = p16_.id LEFT JOIN property_rubric p11_ ON p0_.rubric_id = p11_.id LEFT JOIN denomination d4_ ON c1_.denomination_id = d4_.id WHERE p0_.id = ? AND p0_.is_archived = 0 ORDER BY p0_.id ASC
Parameters:
[
402
]
|
|
3.86 ms (12.09%) |
2 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"papsimmodev"
]
|
|
3.45 ms (10.83%) |
1 |
SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters:
[ "papsimmodev" "doctrine_migration_versions" ] |
|
3.08 ms (9.66%) |
1 |
SELECT c.COLUMN_NAME AS field, IF( c.COLUMN_TYPE = 'longtext' AND EXISTS( SELECT * from information_schema.CHECK_CONSTRAINTS i_c WHERE i_c.CONSTRAINT_SCHEMA = 'papsimmodev' AND i_c.TABLE_NAME = c.TABLE_NAME AND i_c.CHECK_CLAUSE = CONCAT( 'json_valid(`', c.COLUMN_NAME, '`)' ) ), 'json', c.COLUMN_TYPE ) AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters:
[ "papsimmodev" "papsimmodev" "doctrine_migration_versions" ] |
|
2.88 ms (9.04%) |
1 |
SELECT t0.id AS id_1, t0.ref AS ref_2, t0.name AS name_3, t0.slug AS slug_4, t0.annonce AS annonce_5, t0.piece AS piece_6, t0.room AS room_7, t0.surface_land AS surface_land_8, t0.surface_home AS surface_home_9, t0.dpe_at AS dpe_at_10, t0.diag_dpe AS diag_dpe_11, t0.diag_ges AS diag_ges_12, t0.adress AS adress_13, t0.complement AS complement_14, t0.zipcode AS zipcode_15, t0.city AS city_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.is_increating AS is_increating_19, t0.reflastnumber AS reflastnumber_20, t0.refnumdate AS refnumdate_21, t0.ref_mandat AS ref_mandat_22, t0.dpe_estimate_energy_down AS dpe_estimate_energy_down_23, t0.dpe_estimate_energy_up AS dpe_estimate_energy_up_24, t0.construction_at AS construction_at_25, t0.price AS price_26, t0.honoraires AS honoraires_27, t0.price_fai AS price_fai_28, t0.eea_year AS eea_year_29, t0.number_avenant AS number_avenant_30, t0.date_avenant AS date_avenant_31, t0.is_with_exclusivity AS is_with_exclusivity_32, t0.is_without_exclusivity AS is_without_exclusivity_33, t0.is_semi_exclusivity AS is_semi_exclusivity_34, t0.projet AS projet_35, t0.diag_choice AS diag_choice_36, t0.is_archived AS is_archived_37, t0.mandat_at AS mandat_at_38, t0.dup_mandat AS dup_mandat_39, t0.is_nomandat AS is_nomandat_40, t0.date_endmandat AS date_endmandat_41, t0.archived_at AS archived_at_42, t0.annonce_slug AS annonce_slug_43, t0.rent AS rent_44, t0.rent_charge AS rent_charge_45, t0.is_transaction AS is_transaction_46, t0.rent_charge_mods_payment AS rent_charge_mods_payment_47, t0.warranty_deposit AS warranty_deposit_48, t0.rent_charge_honoraire AS rent_charge_honoraire_49, t0.commerce_annual_rent_global AS commerce_annual_rent_global_50, t0.commerce_annual_charge_rent_global AS commerce_annual_charge_rent_global_51, t0.commerce_annual_rent_meter AS commerce_annual_rent_meter_52, t0.commerce_annual_charge_rent_meter AS commerce_annual_charge_rent_meter_53, t0.commerce_charge_rent_month_ht AS commerce_charge_rent_month_ht_54, t0.commerce_rent_annual_cc AS commerce_rent_annual_cc_55, t0.commerce_rent_annual_ht AS commerce_rent_annual_ht_56, t0.commerce_charge_rent_annual_ht AS commerce_charge_rent_annual_ht_57, t0.commerce_rent_annual_meter_cc AS commerce_rent_annual_meter_cc_58, t0.commerce_rent_annual_meter_ht AS commerce_rent_annual_meter_ht_59, t0.commerce_charge_rent_annual_meter_ht AS commerce_charge_rent_annual_meter_ht_60, t0.commerce_surface_divisible AS commerce_surface_divisible_61, t0.commerce_surface_divisible_min AS commerce_surface_divisible_min_62, t0.commerce_surface_divisible_max AS commerce_surface_divisible_max_63, t0.rent_wall_month AS rent_wall_month_64, t0.rent_cc AS rent_cc_65, t0.rent_ht AS rent_ht_66, t0.rent_honoraire AS rent_honoraire_67, t0.commerce_rental_annual AS commerce_rental_annual_68, t0.coord_long AS coord_long_69, t0.coord_lat AS coord_lat_70, t0.is_closed_folder AS is_closed_folder_71, t0.qrcode_url AS qrcode_url_72, t0.annonce_down AS annonce_down_73, t0.add_link_auction AS add_link_auction_74, t0.type_mandat AS type_mandat_75, t0.ref_employed_id AS ref_employed_id_76, t0.options_id AS options_id_77, t0.publication_id AS publication_id_78, t0.property_definition_id AS property_definition_id_79, t0.sscategory_id AS sscategory_id_80, t0.family_id AS family_id_81, t0.rubric_id AS rubric_id_82, t0.rubricss_id AS rubricss_id_83, t0.video_id AS video_id_84 FROM property t0 WHERE t0.id = ?
Parameters:
[
"402"
]
|
|
2.52 ms (7.89%) |
1 |
SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /*!50116, c.UPDATE_RULE, c.DELETE_RULE */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'papsimmodev' */ ORDER BY k.ORDINAL_POSITION
Parameters:
[ "papsimmodev" "doctrine_migration_versions" ] |
|
2.49 ms (7.82%) |
6 |
SELECT DATABASE()
Parameters:
[] |
|
2.31 ms (7.23%) |
2 |
SELECT a0_.id AS id_0, a0_.name_site AS name_site_1, a0_.slogan_site AS slogan_site_2, a0_.descr_site AS descr_site_3, a0_.is_online AS is_online_4, a0_.admin_email AS admin_email_5, a0_.admin_webmaster AS admin_webmaster_6, a0_.is_blockmenufluid AS is_blockmenufluid_7, a0_.offline_message AS offline_message_8, a0_.is_showofflinemessage AS is_showofflinemessage_9, a0_.is_showofflinelogo AS is_showofflinelogo_10, a0_.is_showtitlesitehome AS is_showtitlesitehome_11, a0_.url_facebook AS url_facebook_12, a0_.url_instagram AS url_instagram_13, a0_.url_linkedin AS url_linkedin_14, a0_.url_googlebusiness AS url_googlebusiness_15, a0_.logo_file AS logo_file_16, a0_.logo_name AS logo_name_17, a0_.logo_size AS logo_size_18, a0_.favicon_file AS favicon_file_19, a0_.favicon_name AS favicon_name_20, a0_.favicon_size AS favicon_size_21, a0_.created_at AS created_at_22, a0_.updated_at AS updated_at_23 FROM application a0_ LIMIT 1
Parameters:
[] |
|
2.08 ms (6.52%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.galery_front_name AS galery_front_name_4, t0.galery_front_size AS galery_front_size_5, t0.position AS position_6, t0.path AS path_7, t0.property_id AS property_id_8 FROM photo t0 WHERE t0.property_id = ? ORDER BY t0.position ASC
Parameters:
[
402
]
|
|
1.36 ms (4.27%) |
1 |
SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.galery_front_name AS galery_front_name_3, p0_.galery_front_size AS galery_front_size_4, p0_.position AS position_5, p0_.path AS path_6, p0_.property_id AS property_id_7 FROM photo p0_ WHERE p0_.property_id = ? ORDER BY p0_.position ASC LIMIT 1
Parameters:
[
402
]
|
|
1.24 ms (3.88%) |
1 |
SELECT t0.id AS id_1, t0.location AS location_2, t0.disponibility AS disponibility_3, t0.disponibility_at AS disponibility_at_4, t0.level AS level_5, t0.jointness AS jointness_6, t0.washroom AS washroom_7, t0.bathroom AS bathroom_8, t0.wc AS wc_9, t0.terrace AS terrace_10, t0.balcony AS balcony_11, t0.sanitation AS sanitation_12, t0.is_furnished AS is_furnished_13, t0.property_tax AS property_tax_14, t0.coproperty AS coproperty_15, t0.copropriety_taxe AS copropriety_taxe_16, t0.other_pieces AS other_pieces_17, t0.denomination_id AS denomination_id_18, t0.apartment_type_id AS apartment_type_id_19, t0.land_type_id AS land_type_id_20, t0.building_equipment_id AS building_equipment_id_21, t0.house_equipment_id AS house_equipment_id_22, t0.property_state_id AS property_state_id_23, t0.property_typology_id AS property_typology_id_24, t0.property_orientation_id AS property_orientation_id_25, t0.banner_id AS banner_id_26 FROM complement t0 WHERE t0.id = ?
Parameters:
[
439
]
|
|
0.97 ms (3.04%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.state AS state_3, p0_.is_menu AS is_menu_4, p1_.id AS id_5, p0_.position AS position_6 FROM page p0_ LEFT JOIN page p1_ ON p0_.parent_id = p1_.id WHERE p0_.state = ? AND p0_.is_menu = ?
Parameters:
[ "publiée" 1 ] |
|
0.58 ms (1.82%) |
1 |
SELECT * FROM doctrine_migration_versions
Parameters:
[] |
|
0.51 ms (1.60%) |
1 |
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
Parameters:
[ "papsimmodev" "doctrine_migration_versions" ] |
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Gestapp\Photo | 11 |
| App\Entity\Gestapp\Property | 1 |
| App\Entity\Admin\Employed | 1 |
| App\Entity\Gestapp\Complement | 1 |
| App\Entity\Gestapp\Publication | 1 |
| App\Entity\Gestapp\choice\propertyFamily | 1 |
| App\Entity\Gestapp\choice\propertyRubric | 1 |
| App\Entity\Gestapp\choice\propertyRubricss | 1 |
| App\Entity\Gestapp\choice\Denomination | 1 |
| App\Entity\Gestapp\choice\PropertyState | 1 |
| App\Entity\Gestapp\choice\PropertyTypology | 1 |
| App\Entity\Gestapp\choice\PropertyOrientation | 1 |
| App\Entity\Gestapp\choice\PropertyBanner | 1 |
| App\Entity\Admin\Application | 1 |