https://yangon.mmrdpub.com/advertise.html?id=149198&type=digital

Query Metrics

16 Database Queries
12 Different statements
8.03 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

main connection

No database queries were performed.

domain connection

Time Count Info
0.97 ms
(12.11%)
3
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]
0.80 ms
(9.96%)
2
SELECT t0.id AS id_1, t0.title AS title_2 FROM PageType t0 WHERE t0.id = ?
Parameters: [0 => 1]
0.80 ms
(9.95%)
2
SELECT t0.id AS id_1, t0.title AS title_2 FROM Theme t0 WHERE t0.title = ? LIMIT 1
Parameters: [0 => Default]
0.74 ms
(9.22%)
1
SELECT t0.name AS name_1, t0.value AS value_2 FROM Setting t0
Parameters: []
0.68 ms
(8.42%)
1
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: []
0.67 ms
(8.37%)
1
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]
0.63 ms
(7.81%)
1
SELECT t0.id AS id_1, t0.title AS title_2 FROM PageType t0 WHERE t0.title = ? LIMIT 1
Parameters: [0 => Custom Page]
0.59 ms
(7.40%)
1
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]
0.57 ms
(7.07%)
1
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]
0.55 ms
(6.85%)
1
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: []
0.55 ms
(6.80%)
1
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]
0.49 ms
(6.05%)
1
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: []

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.