GET https://backoffice.softlabel.nl/api/v1/projects?limit=30&page=1

Response
200 OK
IP
93.170.44.80
Profiled on
Token
f22e12

Query Metrics

4 Database Queries
4 Different statements
10.47 ms Query time
0 Invalid entities
35 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.02 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name_prefix AS last_name_prefix_4, t0.last_name AS last_name_5, t0.professional_competence_number AS professional_competence_number_6, t0.calendar_token AS calendar_token_7, t0.booking_lead_hours AS booking_lead_hours_8, t0.subscription AS subscription_9, t0.roles AS roles_10, t0.password AS password_11, t0.company_id AS company_id_12 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters: 
[
  "adviseur@bedrijfx.com"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 1.14 ms 
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, updated_at_23, created_at_22 FROM (SELECT p0_.id AS id_0, p0_.postcode AS postcode_1, p0_.huisnummer AS huisnummer_2, p0_.toevoeging AS toevoeging_3, p0_.straat AS straat_4, p0_.plaats AS plaats_5, p0_.bag_id AS bag_id_6, p0_.bouwjaar AS bouwjaar_7, p0_.oppervlakte AS oppervlakte_8, p0_.gebruikdsdoel AS gebruikdsdoel_9, p0_.standpipe_penetrations AS standpipe_penetrations_10, p0_.vabi_general_source AS vabi_general_source_11, p0_.remarks AS remarks_12, p0_.lat AS lat_13, p0_.lng AS lng_14, p0_.streetview_image_base64 AS streetview_image_base64_15, p0_.building_sketch_path AS building_sketch_path_16, p0_.preview_image_filename AS preview_image_filename_17, p0_.preview_image_mime_type AS preview_image_mime_type_18, p0_.preview_image_size AS preview_image_size_19, p0_.preview_image_uploaded_at AS preview_image_uploaded_at_20, p0_.status AS status_21, p0_.created_at AS created_at_22, p0_.updated_at AS updated_at_23, p0_.scheduling_token AS scheduling_token_24, p0_.energy_data AS energy_data_25, p0_.floor_plan AS floor_plan_26, p0_.appendix_g_selections AS appendix_g_selections_27, p0_.bouwlagen AS bouwlagen_28, p0_.floor_mass_class AS floor_mass_class_29, p0_.wall_mass_class AS wall_mass_class_30, p0_.dwelling_type AS dwelling_type_31, p0_.ground_height_nap AS ground_height_nap_32, p0_.ridge_height_nap AS ridge_height_nap_33, p0_.building_height_m AS building_height_m_34, p0_.footprint_area_m2 AS footprint_area_m2_35, p0_.roof_pitched_area_m2 AS roof_pitched_area_m2_36, p0_.roof_flat_area_m2 AS roof_flat_area_m2_37, p0_.outer_wall_area_m2 AS outer_wall_area_m2_38, p0_.party_wall_area_m2 AS party_wall_area_m2_39, p0_.building_volume_m3 AS building_volume_m3_40, p0_.roof_type AS roof_type_41, p0_.roof_facets AS roof_facets_42, p0_.building_sketch_geometry AS building_sketch_geometry_43, p0_.building_orientation_deg AS building_orientation_deg_44, p0_.signature AS signature_45, p0_.signed_at AS signed_at_46 FROM project p0_ WHERE p0_.advisor_id = ?) dctrn_result_inner ORDER BY updated_at_23 DESC, created_at_22 DESC) dctrn_result LIMIT 30
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
3 7.46 ms 
SELECT p0_.id AS id_0, p0_.postcode AS postcode_1, p0_.huisnummer AS huisnummer_2, p0_.toevoeging AS toevoeging_3, p0_.straat AS straat_4, p0_.plaats AS plaats_5, p0_.bag_id AS bag_id_6, p0_.bouwjaar AS bouwjaar_7, p0_.oppervlakte AS oppervlakte_8, p0_.gebruikdsdoel AS gebruikdsdoel_9, p0_.standpipe_penetrations AS standpipe_penetrations_10, p0_.vabi_general_source AS vabi_general_source_11, p0_.remarks AS remarks_12, p0_.lat AS lat_13, p0_.lng AS lng_14, p0_.streetview_image_base64 AS streetview_image_base64_15, p0_.building_sketch_path AS building_sketch_path_16, p0_.preview_image_filename AS preview_image_filename_17, p0_.preview_image_mime_type AS preview_image_mime_type_18, p0_.preview_image_size AS preview_image_size_19, p0_.preview_image_uploaded_at AS preview_image_uploaded_at_20, p0_.status AS status_21, p0_.created_at AS created_at_22, p0_.updated_at AS updated_at_23, p0_.scheduling_token AS scheduling_token_24, p0_.energy_data AS energy_data_25, p0_.floor_plan AS floor_plan_26, p0_.appendix_g_selections AS appendix_g_selections_27, p0_.bouwlagen AS bouwlagen_28, p0_.floor_mass_class AS floor_mass_class_29, p0_.wall_mass_class AS wall_mass_class_30, p0_.dwelling_type AS dwelling_type_31, p0_.ground_height_nap AS ground_height_nap_32, p0_.ridge_height_nap AS ridge_height_nap_33, p0_.building_height_m AS building_height_m_34, p0_.footprint_area_m2 AS footprint_area_m2_35, p0_.roof_pitched_area_m2 AS roof_pitched_area_m2_36, p0_.roof_flat_area_m2 AS roof_flat_area_m2_37, p0_.outer_wall_area_m2 AS outer_wall_area_m2_38, p0_.party_wall_area_m2 AS party_wall_area_m2_39, p0_.building_volume_m3 AS building_volume_m3_40, p0_.roof_type AS roof_type_41, p0_.roof_facets AS roof_facets_42, p0_.building_sketch_geometry AS building_sketch_geometry_43, p0_.building_orientation_deg AS building_orientation_deg_44, p0_.signature AS signature_45, p0_.signed_at AS signed_at_46, p0_.advisor_id AS advisor_id_47, p0_.client_id AS client_id_48 FROM project p0_ WHERE p0_.advisor_id = ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.updated_at DESC, p0_.created_at DESC
Parameters: 
[
  4
  312
  69
  313
  247
  56
  274
  175
  266
  57
  122
  91
  88
  41
  226
  53
  58
  40
  113
  140
  119
  233
  39
  229
  86
  206
  210
  166
  55
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.85 ms 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.postcode AS postcode_1, p0_.huisnummer AS huisnummer_2, p0_.toevoeging AS toevoeging_3, p0_.straat AS straat_4, p0_.plaats AS plaats_5, p0_.bag_id AS bag_id_6, p0_.bouwjaar AS bouwjaar_7, p0_.oppervlakte AS oppervlakte_8, p0_.gebruikdsdoel AS gebruikdsdoel_9, p0_.standpipe_penetrations AS standpipe_penetrations_10, p0_.vabi_general_source AS vabi_general_source_11, p0_.remarks AS remarks_12, p0_.lat AS lat_13, p0_.lng AS lng_14, p0_.streetview_image_base64 AS streetview_image_base64_15, p0_.building_sketch_path AS building_sketch_path_16, p0_.preview_image_filename AS preview_image_filename_17, p0_.preview_image_mime_type AS preview_image_mime_type_18, p0_.preview_image_size AS preview_image_size_19, p0_.preview_image_uploaded_at AS preview_image_uploaded_at_20, p0_.status AS status_21, p0_.created_at AS created_at_22, p0_.updated_at AS updated_at_23, p0_.scheduling_token AS scheduling_token_24, p0_.energy_data AS energy_data_25, p0_.floor_plan AS floor_plan_26, p0_.appendix_g_selections AS appendix_g_selections_27, p0_.bouwlagen AS bouwlagen_28, p0_.floor_mass_class AS floor_mass_class_29, p0_.wall_mass_class AS wall_mass_class_30, p0_.dwelling_type AS dwelling_type_31, p0_.ground_height_nap AS ground_height_nap_32, p0_.ridge_height_nap AS ridge_height_nap_33, p0_.building_height_m AS building_height_m_34, p0_.footprint_area_m2 AS footprint_area_m2_35, p0_.roof_pitched_area_m2 AS roof_pitched_area_m2_36, p0_.roof_flat_area_m2 AS roof_flat_area_m2_37, p0_.outer_wall_area_m2 AS outer_wall_area_m2_38, p0_.party_wall_area_m2 AS party_wall_area_m2_39, p0_.building_volume_m3 AS building_volume_m3_40, p0_.roof_type AS roof_type_41, p0_.roof_facets AS roof_facets_42, p0_.building_sketch_geometry AS building_sketch_geometry_43, p0_.building_orientation_deg AS building_orientation_deg_44, p0_.signature AS signature_45, p0_.signed_at AS signed_at_46 FROM project p0_ WHERE p0_.advisor_id = ? ORDER BY p0_.updated_at DESC, p0_.created_at DESC) dctrn_result) dctrn_table
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace

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\Project 28
App\Entity\Client 5
App\Entity\User 1
App\Entity\Company 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Company No errors.
App\Entity\AvailabilityException No errors.
App\Entity\Project No errors.
App\Entity\Client No errors.
App\Entity\ProjectProduct No errors.
App\Entity\ProjectRemark No errors.
App\Entity\EmailLog No errors.