Query Metrics
22
Database Queries
9
Different statements
13.14 ms
Query time
0
Invalid entities
Grouped Statements
main connection
Time▼ | Count | Info |
---|---|---|
1.51 ms (11.48%) |
3 |
SELECT t0.id AS id_1, t0.value AS value_2 FROM RobotsFilter t0 WHERE t0.value IN (?)
Parameters: [
0 => [
0 => 3.147.69.90,
1 => 3.147.69.*,
2 => 3.147.*.*,
3 => 3.*.*.*
]
]
|
0.55 ms (4.17%) |
1 |
SELECT t0.id AS id_1, t0.location_3 AS location_3_2, t0.location_2 AS location_2_3, t0.location_1 AS location_1_4, t0.name AS name_5, t0.abbreviation AS abbreviation_6, t0.friendly_url AS friendly_url_7, t0.page_title AS page_title_8, t0.seo_description AS seo_description_9, t0.seo_keywords AS seo_keywords_10, t0.latitude AS latitude_11, t0.longitude AS longitude_12, t0.radius AS radius_13, t0.import_id AS import_id_14 FROM Location_4 t0 WHERE t0.id = ?
Parameters: [0 => 132]
|
domain connection
Time▼ | Count | Info |
---|---|---|
6.83 ms (51.98%) |
3 |
"COMMIT"
Parameters: []
|
1.75 ms (13.34%) |
6 |
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.96 ms (7.31%) |
3 |
INSERT INTO Report_Statistic (search_date, module, keyword, category_id, location_1, location_2, location_3, location_4, location_5, search_where) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [1 => 2025-01-25 14:13:27, 2 => l, 3 => , 4 => 662, 5 => 0, 6 => 0, 7 => 0, 8 => 0, 9 => 0, 10 => null]
|
0.48 ms (3.63%) |
1 |
SELECT t0.name AS name_1, t0.value AS value_2 FROM Setting t0
Parameters: []
|
0.42 ms (3.20%) |
1 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.url AS url_2, p0_.meta_description AS meta_description_3, p0_.meta_key AS meta_key_4, p0_.sitemap AS sitemap_5, p0_.custom_tag AS custom_tag_6, p0_.pagetype_id AS pagetype_id_7, p0_.updated AS updated_8, p0_.pagetype_id AS pagetype_id_9 FROM Page p0_ LEFT JOIN PageType p1_ ON p0_.pagetype_id = p1_.id WHERE p1_.title = ?
Parameters: [0 => Directory Results]
|
0.35 ms (2.63%) |
3 |
"START TRANSACTION"
Parameters: []
|
0.30 ms (2.25%) |
1 |
SELECT t0.id AS id_1, t0.default_id AS default_id_2, t0.name AS name_3, t0.name_plural AS name_plural_4, t0.enabled AS enabled_5, t0.`show` AS show_6 FROM Setting_Location t0 WHERE t0.enabled = ?
Parameters: [0 => y]
|
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
Class | Mapping errors |
---|---|
ArcaSolutions\CoreBundle\Entity\Robotsfilter | No errors. |
ArcaSolutions\CoreBundle\Entity\Location1 | No errors. |
ArcaSolutions\CoreBundle\Entity\Location2 | No errors. |
ArcaSolutions\CoreBundle\Entity\Location3 | No errors. |
ArcaSolutions\CoreBundle\Entity\Location4 | No errors. |
ArcaSolutions\CoreBundle\Entity\Location5 | No errors. |
domain entity manager
Class | Mapping errors |
---|---|
ArcaSolutions\WebBundle\Entity\Setting | No errors. |
ArcaSolutions\ReportsBundle\Entity\ReportStatistic | No errors. |
ArcaSolutions\WebBundle\Entity\SettingLocation | No errors. |
ArcaSolutions\WysiwygBundle\Entity\Page | No errors. |
ArcaSolutions\WysiwygBundle\Entity\PageType | No errors. |
ArcaSolutions\WysiwygBundle\Entity\PageWidget | No errors. |
ArcaSolutions\WebBundle\Entity\SettingNavigation | No errors. |
ArcaSolutions\WebBundle\Entity\Slider | No errors. |