Query Metrics
4
Database Queries
4
Different statements
1.30 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.uitleg AS uitleg_3, t0.code AS code_4, t0.sequence AS sequence_5, t0.access AS access_6, t0.created AS created_7, t0.modified AS modified_8, t0.modified_by_id AS modified_by_id_9, t0.created_by_id AS created_by_id_10 FROM sjabloon t0 WHERE t0.name = ?
Parameters:
[
"Modal tekst"
]
|
2 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.page_url AS page_url_3, t0.created AS created_4, t0.modified AS modified_5, t0.sjabloon_id AS sjabloon_id_6, t7.id AS id_8, t7.name AS name_9, t7.uitleg AS uitleg_10, t7.code AS code_11, t7.sequence AS sequence_12, t7.access AS access_13, t7.created AS created_14, t7.modified AS modified_15, t7.modified_by_id AS modified_by_id_16, t7.created_by_id AS created_by_id_17, t0.created_by_id AS created_by_id_18, t0.modified_by_id AS modified_by_id_19 FROM sjabloon_content t0 LEFT JOIN sjabloon t7 ON t0.sjabloon_id = t7.id WHERE t0.sjabloon_id = ?
Parameters:
[
10
]
|
3 | 0.46 ms |
SELECT t0.id AS id_1, t0.object_name AS object_name_2, t0.content_id AS content_id_3, t4.id AS id_5, t4.name AS name_6, t4.page_url AS page_url_7, t4.created AS created_8, t4.modified AS modified_9, t4.sjabloon_id AS sjabloon_id_10, t4.created_by_id AS created_by_id_11, t4.modified_by_id AS modified_by_id_12, t0.field_id AS field_id_13, t0.parent_id AS parent_id_14, t15.id AS id_16, t15.name AS name_17, t15.sequence AS sequence_18, t15.sjabloon_field_value_collection_id AS sjabloon_field_value_collection_id_19, t20.id AS id_21, t20.html AS html_22, t20.value_id AS value_id_23, t24.id AS id_25, t24.string AS string_26, t24.value_id AS value_id_27, t28.id AS id_29, t28.image_file_name AS image_file_name_30, t28.value_id AS value_id_31, t32.id AS id_33, t32.file AS file_34, t32.value_id AS value_id_35, t36.id AS id_37, t36.text AS text_38, t36.value_id AS value_id_39, t40.id AS id_41, t40.number AS number_42, t40.value_id AS value_id_43, t44.id AS id_45, t44.sjabloon_content_id AS sjabloon_content_id_46, t44.value_id AS value_id_47, t48.id AS id_49, t48.module AS module_50, t48.method AS method_51, t48.value_id AS value_id_52, t53.id AS id_54, t53.name AS name_55, t53.value_id AS value_id_56 FROM sjabloon_content_value t0 LEFT JOIN sjabloon_content t4 ON t0.content_id = t4.id LEFT JOIN sjabloon_field_value_parent t15 ON t0.parent_id = t15.id LEFT JOIN sjabloon_field_value_tiny t20 ON t20.value_id = t0.id LEFT JOIN sjabloon_field_value_string t24 ON t24.value_id = t0.id LEFT JOIN sjabloon_field_value_image t28 ON t28.value_id = t0.id LEFT JOIN sjabloon_field_value_file t32 ON t32.value_id = t0.id LEFT JOIN sjabloon_field_value_text t36 ON t36.value_id = t0.id LEFT JOIN sjabloon_field_value_num t40 ON t40.value_id = t0.id LEFT JOIN sjabloon_field_value_sjabloon_content t44 ON t44.value_id = t0.id LEFT JOIN sjabloon_field_value_module t48 ON t48.value_id = t0.id LEFT JOIN sjabloon_field_value_collection t53 ON t53.value_id = t0.id WHERE t0.content_id = ?
Parameters:
[
45
]
|
4 | 0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sequence AS sequence_3, t0.sjabloon_id AS sjabloon_id_4, t0.field_type_id AS field_type_id_5, t6.id AS id_7, t6.name AS name_8, t6.sequence AS sequence_9, t6.db_type AS db_type_10, t6.object_name AS object_name_11, t0.parent_id AS parent_id_12 FROM sjabloon_field t0 INNER JOIN sjabloon_field_specification t6 ON t0.field_type_id = t6.id WHERE t0.sjabloon_id = ? ORDER BY t0.sequence ASC
Parameters:
[
10
]
|
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\Sjabloon | No errors. |
App\Entity\User | No errors. |
App\Entity\SjabloonField | No errors. |
App\Entity\Source | No errors. |
App\Entity\SjabloonContent | No errors. |
App\Entity\PageSjabloonContent | No errors. |
App\Entity\SjabloonContentValue | No errors. |
App\Entity\SjabloonFieldValueParent | No errors. |
App\Entity\SjabloonFieldValueCollection | No errors. |
App\Entity\SjabloonFieldValueTiny | No errors. |
App\Entity\SjabloonFieldValueString | No errors. |
App\Entity\SjabloonFieldValueImage | No errors. |
App\Entity\SjabloonFieldValueFile | No errors. |
App\Entity\SjabloonFieldValueText | No errors. |
App\Entity\SjabloonFieldValueNum | No errors. |
App\Entity\SjabloonFieldValueSjabloonContent | No errors. |
App\Entity\SjabloonFieldValueModule | No errors. |
App\Entity\SjabloonFieldSpecification | No errors. |