Query Metrics
10
Database Queries
9
Different statements
6.42 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.08 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.text AS text_4, t0.created AS created_5, t0.modified AS modified_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.title_tag AS title_tag_9, t0.meta_description AS meta_description_10, t0.keywords AS keywords_11, t0.type AS type_12, t0.published AS published_13, t0.video AS video_14, t0.name_short AS name_short_15, t0.h1 AS h1_16, t0.h2 AS h2_17, t0.h3 AS h3_18, t0.h4 AS h4_19, t0.menu AS menu_20, t0.upload_video AS upload_video_21, t0.gallery_title AS gallery_title_22, t0.gallery_description AS gallery_description_23, t0.items_title AS items_title_24, t0.items_description AS items_description_25, t0.video_title AS video_title_26, t0.video_description AS video_description_27, t0.color AS color_28, t0.download_link AS download_link_29, t0.lang AS lang_30, t0.duplicate AS duplicate_31, t0.glb_image AS glb_image_32, t0.category_id AS category_id_33 FROM page t0 WHERE t0.slug = ? AND t0.is_active = ? AND t0.lang = ? LIMIT 1
Parameters:
[ "outdoor-and-indoor-led-displays" 1 "en" ]
|
||||||||||||||||||||
| 2 | 0.79 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.active AS active_3, t0.name AS name_4, t0.type AS type_5, t0.lang AS lang_6, t0.gallery_id AS gallery_id_7, t0.page_id AS page_id_8, t0.contact_id AS contact_id_9 FROM image t0 WHERE t0.page_id = ? AND t0.active = ? ORDER BY t0.id ASC
Parameters:
[ 47 1 ]
|
||||||||||||||||||||
| 3 | 0.46 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_description AS short_description_3, t0.full_description AS full_description_4, t0.image AS image_5, t0.icon AS icon_6, t0.active AS active_7, t0.lang AS lang_8, t0.page_id AS page_id_9 FROM page_items t0 WHERE t0.page_id = ? AND t0.active = ? AND t0.lang = ? ORDER BY t0.id ASC
Parameters:
[ 47 1 "en" ]
|
||||||||||||||||||||
| 4 | 0.59 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.text AS text_4, t0.created AS created_5, t0.modified AS modified_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.title_tag AS title_tag_9, t0.meta_description AS meta_description_10, t0.keywords AS keywords_11, t0.type AS type_12, t0.published AS published_13, t0.video AS video_14, t0.name_short AS name_short_15, t0.h1 AS h1_16, t0.h2 AS h2_17, t0.h3 AS h3_18, t0.h4 AS h4_19, t0.menu AS menu_20, t0.upload_video AS upload_video_21, t0.gallery_title AS gallery_title_22, t0.gallery_description AS gallery_description_23, t0.items_title AS items_title_24, t0.items_description AS items_description_25, t0.video_title AS video_title_26, t0.video_description AS video_description_27, t0.color AS color_28, t0.download_link AS download_link_29, t0.lang AS lang_30, t0.duplicate AS duplicate_31, t0.glb_image AS glb_image_32, t0.category_id AS category_id_33 FROM page t0 WHERE t0.category_id = ? AND t0.is_active = ? AND t0.lang = ? ORDER BY t0.id ASC LIMIT 20
Parameters:
[ "6" 1 "en" ]
|
||||||||||||||||||||
| 5 | 0.42 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.active AS active_4, t0.youtube AS youtube_5, t0.lang AS lang_6, t0.page_id AS page_id_7 FROM videos t0 WHERE t0.page_id = ? AND t0.active = ? AND t0.lang = ? ORDER BY t0.id ASC
Parameters:
[ 47 1 "en" ]
|
||||||||||||||||||||
| 6 | 0.33 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.active AS active_4, t0.image AS image_5, t0.icon AS icon_6, t0.lang AS lang_7, t0.page_id AS page_id_8 FROM specs t0 WHERE t0.page_id = ? AND t0.active = ? AND t0.lang = ? ORDER BY t0.id ASC
Parameters:
[ 47 1 "en" ]
|
||||||||||||||||||||
| 7 | 0.58 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_active AS is_active_4 FROM country t0 WHERE t0.is_active = ? ORDER BY t0.name ASC
Parameters:
[
1
]
|
||||||||||||||||||||
| 8 | 0.68 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.text AS text_4, t0.created AS created_5, t0.modified AS modified_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.title_tag AS title_tag_9, t0.meta_description AS meta_description_10, t0.keywords AS keywords_11, t0.type AS type_12, t0.published AS published_13, t0.video AS video_14, t0.name_short AS name_short_15, t0.h1 AS h1_16, t0.h2 AS h2_17, t0.h3 AS h3_18, t0.h4 AS h4_19, t0.menu AS menu_20, t0.upload_video AS upload_video_21, t0.gallery_title AS gallery_title_22, t0.gallery_description AS gallery_description_23, t0.items_title AS items_title_24, t0.items_description AS items_description_25, t0.video_title AS video_title_26, t0.video_description AS video_description_27, t0.color AS color_28, t0.download_link AS download_link_29, t0.lang AS lang_30, t0.duplicate AS duplicate_31, t0.glb_image AS glb_image_32, t0.category_id AS category_id_33 FROM page t0 WHERE t0.category_id = ? AND t0.is_active = ? AND t0.lang = ? ORDER BY t0.title ASC
Parameters:
[ "6" 1 "en" ] |
||||||||||||||||||||
| 9 | 0.73 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.text AS text_4, t0.created AS created_5, t0.modified AS modified_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.title_tag AS title_tag_9, t0.meta_description AS meta_description_10, t0.keywords AS keywords_11, t0.type AS type_12, t0.published AS published_13, t0.video AS video_14, t0.name_short AS name_short_15, t0.h1 AS h1_16, t0.h2 AS h2_17, t0.h3 AS h3_18, t0.h4 AS h4_19, t0.menu AS menu_20, t0.upload_video AS upload_video_21, t0.gallery_title AS gallery_title_22, t0.gallery_description AS gallery_description_23, t0.items_title AS items_title_24, t0.items_description AS items_description_25, t0.video_title AS video_title_26, t0.video_description AS video_description_27, t0.color AS color_28, t0.download_link AS download_link_29, t0.lang AS lang_30, t0.duplicate AS duplicate_31, t0.glb_image AS glb_image_32, t0.category_id AS category_id_33 FROM page t0 WHERE t0.is_active = ? AND t0.category_id = ? AND t0.lang = ? ORDER BY t0.id ASC
Parameters:
[ 1 "6" "en" ] |
||||||||||||||||||||
| 10 | 0.77 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.text AS text_4, t0.created AS created_5, t0.modified AS modified_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.title_tag AS title_tag_9, t0.meta_description AS meta_description_10, t0.keywords AS keywords_11, t0.type AS type_12, t0.published AS published_13, t0.video AS video_14, t0.name_short AS name_short_15, t0.h1 AS h1_16, t0.h2 AS h2_17, t0.h3 AS h3_18, t0.h4 AS h4_19, t0.menu AS menu_20, t0.upload_video AS upload_video_21, t0.gallery_title AS gallery_title_22, t0.gallery_description AS gallery_description_23, t0.items_title AS items_title_24, t0.items_description AS items_description_25, t0.video_title AS video_title_26, t0.video_description AS video_description_27, t0.color AS color_28, t0.download_link AS download_link_29, t0.lang AS lang_30, t0.duplicate AS duplicate_31, t0.glb_image AS glb_image_32, t0.category_id AS category_id_33 FROM page t0 WHERE t0.is_active = ? AND t0.category_id = ? AND t0.lang = ? ORDER BY t0.id ASC
Parameters:
[ 1 "6" "en" ] |
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\Page | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\PageItems | No errors. |
| App\Entity\Videos | No errors. |
| App\Entity\Industry | No errors. |
| App\Entity\Specs | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\Gallery | No errors. |
| App\Entity\Country | No errors. |
| App\Entity\Article | No errors. |
| App\Entity\Product | No errors. |