Query Metrics
16
Database Queries
12
Different statements
8.03 ms
Query time
0
Invalid entities
Queries
main connection
No database queries were performed.
domain connection
#▲ | Time | Info |
---|---|---|
1 | 0.74 ms |
SELECT t0.name AS name_1, t0.value AS value_2 FROM Setting t0
Parameters: []
|
2 | 0.63 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM PageType t0 WHERE t0.title = ? LIMIT 1
Parameters: [0 => Custom Page]
|
3 | 0.55 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.meta_description AS meta_description_4, t0.meta_key AS meta_key_5, t0.sitemap AS sitemap_6, t0.custom_tag AS custom_tag_7, t0.pagetype_id AS pagetype_id_8, t0.updated AS updated_9, t0.pagetype_id AS pagetype_id_10 FROM Page t0 WHERE t0.url = ? AND t0.pagetype_id = ? LIMIT 1
Parameters: [0 => advertise, 1 => 22]
|
4 | 0.59 ms |
SELECT r0_.id AS id_0, r0_.listing_id AS listing_id_1, r0_.day AS day_2, r0_.total_view AS total_view_3, r0_.site_visit_count AS site_visit_count_4 FROM Report_ClientCookie_Daily r0_ WHERE r0_.listing_id = ? AND DATE(r0_.day) = ?
Parameters: [0 => null, 1 => 2025-02-02]
|
5 | 0.49 ms |
SELECT t0.id AS id_1, t0.listing_id AS listing_id_2, t0.cookie AS cookie_3, t0.created_date AS created_date_4, t0.last_visit_date AS last_visit_date_5, t0.initial_status AS initial_status_6, t0.total_views AS total_views_7, t0.site_visit_count AS site_visit_count_8 FROM Report_ClientCookie t0 WHERE t0.listing_id IS NULL LIMIT 1
Parameters: []
|
6 | 0.47 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM Theme t0 WHERE t0.title = ? LIMIT 1
Parameters: [0 => Default]
|
7 | 0.32 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM Theme t0 WHERE t0.title = ? LIMIT 1
Parameters: [0 => Default]
|
8 | 0.67 ms |
SELECT t0.id AS id_1, t0.page_id AS page_id_2, t0.widget_id AS widget_id_3, t0.content AS content_4, t0.`order` AS order_5, t0.theme_id AS theme_id_6, t0.page_id AS page_id_7, t0.widget_id AS widget_id_8, t9.id AS id_10, t9.title AS title_11, t9.twig_file AS twig_file_12, t9.content AS content_13, t9.`type` AS type_14, t9.`modal` AS modal_15, t0.theme_id AS theme_id_16 FROM Page_Widget t0 LEFT JOIN Widget t9 ON t0.widget_id = t9.id WHERE t0.page_id = ? AND t0.theme_id = ? ORDER BY t0.`order` ASC
Parameters: [0 => 36, 1 => 1]
|
9 | 0.57 ms |
SELECT s0_.`order` AS order_0, s0_.area AS area_1, s0_.label AS label_2, s0_.link AS link_3, s0_.custom AS custom_4, s0_.page_id AS page_id_5 FROM Setting_Navigation s0_ WHERE s0_.area = ? AND (s0_.link IS NOT NULL OR s0_.page_id IS NOT NULL) ORDER BY s0_.`order` ASC
Parameters: [0 => header]
|
10 | 0.68 ms |
SELECT s0_.name AS name_0, s0_.value AS value_1 FROM Setting s0_ WHERE s0_.name IN ('custom_event_feature', 'custom_classified_feature', 'custom_article_feature', 'custom_banner_feature', 'custom_promotion_feature', 'custom_blog_feature', 'custom_job_feature')
Parameters: []
|
11 | 0.33 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.meta_description AS meta_description_4, t0.meta_key AS meta_key_5, t0.sitemap AS sitemap_6, t0.custom_tag AS custom_tag_7, t0.pagetype_id AS pagetype_id_8, t0.updated AS updated_9, t0.pagetype_id AS pagetype_id_10 FROM Page t0 WHERE t0.id = ?
Parameters: [0 => 1]
|
12 | 0.48 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM PageType t0 WHERE t0.id = ?
Parameters: [0 => 1]
|
13 | 0.31 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.meta_description AS meta_description_4, t0.meta_key AS meta_key_5, t0.sitemap AS sitemap_6, t0.custom_tag AS custom_tag_7, t0.pagetype_id AS pagetype_id_8, t0.updated AS updated_9, t0.pagetype_id AS pagetype_id_10 FROM Page t0 WHERE t0.id = ?
Parameters: [0 => 3]
|
14 | 0.32 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM PageType t0 WHERE t0.id = ?
Parameters: [0 => 2]
|
15 | 0.32 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.meta_description AS meta_description_4, t0.meta_key AS meta_key_5, t0.sitemap AS sitemap_6, t0.custom_tag AS custom_tag_7, t0.pagetype_id AS pagetype_id_8, t0.updated AS updated_9, t0.pagetype_id AS pagetype_id_10 FROM Page t0 WHERE t0.id = ?
Parameters: [0 => 38]
|
16 | 0.55 ms |
SELECT t0.id AS id_1, t0.bank AS bank_2, t0.currency AS currency_3, t0.buy AS buy_4, t0.sell AS sell_5 FROM Exchange t0
Parameters: []
|
Database Connections
Name | Service |
---|---|
main | doctrine.dbal.main_connection |
domain | doctrine.dbal.domain_connection |
Entity Managers
Name | Service |
---|---|
main | doctrine.orm.main_entity_manager |
domain | doctrine.orm.domain_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
main entity manager
No loaded entities.
domain entity manager
Class | Mapping errors |
---|---|
ArcaSolutions\WebBundle\Entity\Setting | No errors. |
ArcaSolutions\WysiwygBundle\Entity\PageType | No errors. |
ArcaSolutions\WysiwygBundle\Entity\WidgetPageType | No errors. |
ArcaSolutions\WysiwygBundle\Entity\Page | No errors. |
ArcaSolutions\WysiwygBundle\Entity\PageWidget | No errors. |
ArcaSolutions\WebBundle\Entity\SettingNavigation | No errors. |
ArcaSolutions\WebBundle\Entity\Slider | No errors. |
ArcaSolutions\ReportsBundle\Entity\ReportClientCookieDaily | No errors. |
ArcaSolutions\ReportsBundle\Entity\ReportClientCookie | No errors. |
ArcaSolutions\WysiwygBundle\Entity\Theme | No errors. |
ArcaSolutions\WysiwygBundle\Entity\WidgetTheme | No errors. |
ArcaSolutions\WysiwygBundle\Entity\Widget | No errors. |
ArcaSolutions\WebBundle\Entity\Exchange | No errors. |