Symfony Profiler

Query Metrics

32 Database Queries

3 Different statements

22.52 ms Query time

0 Invalid entities

Queries


SELECT t0.id AS id_1, t0.fromurl AS fromurl_2, t0.tourl AS tourl_3, t0.timestamp AS timestamp_4 FROM general t0
SELECT count(c0_.id) AS sclr_0 FROM City c0_
SELECT count(c0_.id) AS sclr_0 FROM City c0_
SELECT count(c0_.id) AS sclr_0 FROM City c0_
SELECT count(c0_.id) AS sclr_0 FROM City c0_
SELECT count(c0_.id) AS sclr_0 FROM City c0_
SELECT count(c0_.id) AS sclr_0 FROM City c0_
SELECT count(c0_.id) AS sclr_0 FROM City c0_
SELECT count(c0_.id) AS sclr_0 FROM City c0_
SELECT count(c0_.id) AS sclr_0 FROM City c0_
SELECT count(c0_.id) AS sclr_0 FROM City c0_
SELECT count(c0_.id) AS sclr_0 FROM City c0_
SELECT count(c0_.id) AS sclr_0 FROM City c0_
SELECT count(c0_.id) AS sclr_0 FROM City c0_
SELECT count(c0_.id) AS sclr_0 FROM City c0_
SELECT count(c0_.id) AS sclr_0 FROM City c0_
SELECT count(c0_.id) AS sclr_0 FROM City c0_
SELECT count(c0_.id) AS sclr_0 FROM City c0_
SELECT count(c0_.id) AS sclr_0 FROM City c0_
SELECT count(c0_.id) AS sclr_0 FROM City c0_
SELECT count(c0_.id) AS sclr_0 FROM City c0_
SELECT count(c0_.id) AS sclr_0 FROM City c0_
SELECT count(c0_.id) AS sclr_0 FROM City c0_
SELECT count(c0_.id) AS sclr_0 FROM City c0_
SELECT count(c0_.id) AS sclr_0 FROM City c0_
SELECT count(c0_.id) AS sclr_0 FROM City c0_
SELECT count(c0_.id) AS sclr_0 FROM City c0_
SELECT count(c0_.id) AS sclr_0 FROM Company c0_
SELECT count(c0_.id) AS sclr_0 FROM Company c0_
SELECT count(c0_.id) AS sclr_0 FROM Company c0_
SELECT count(c0_.id) AS sclr_0 FROM Company c0_
SELECT count(c0_.id) AS sclr_0 FROM Company c0_

#▲	Time	Info
1	0.48 ms	SELECT t0.id AS id_1, t0.fromurl AS fromurl_2, t0.tourl AS tourl_3, t0.timestamp AS timestamp_4 FROM general t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fromurl AS fromurl_2, t0.tourl AS tourl_3, t0.timestamp AS timestamp_4 FROM general t0 SELECT t0.id AS id_1, t0.fromurl AS fromurl_2, t0.tourl AS tourl_3, t0.timestamp AS timestamp_4 FROM general t0;
2	14.49 ms	SELECT count(c0_.id) AS sclr_0 FROM City c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM City c0_ SELECT count(c0_.id) AS sclr_0 FROM City c0_;
3	0.29 ms	SELECT count(c0_.id) AS sclr_0 FROM City c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM City c0_ SELECT count(c0_.id) AS sclr_0 FROM City c0_;
4	0.13 ms	SELECT count(c0_.id) AS sclr_0 FROM City c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM City c0_ SELECT count(c0_.id) AS sclr_0 FROM City c0_;
5	0.13 ms	SELECT count(c0_.id) AS sclr_0 FROM City c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM City c0_ SELECT count(c0_.id) AS sclr_0 FROM City c0_;
6	0.13 ms	SELECT count(c0_.id) AS sclr_0 FROM City c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM City c0_ SELECT count(c0_.id) AS sclr_0 FROM City c0_;
7	0.12 ms	SELECT count(c0_.id) AS sclr_0 FROM City c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM City c0_ SELECT count(c0_.id) AS sclr_0 FROM City c0_;
8	0.09 ms	SELECT count(c0_.id) AS sclr_0 FROM City c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM City c0_ SELECT count(c0_.id) AS sclr_0 FROM City c0_;
9	0.09 ms	SELECT count(c0_.id) AS sclr_0 FROM City c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM City c0_ SELECT count(c0_.id) AS sclr_0 FROM City c0_;
10	0.10 ms	SELECT count(c0_.id) AS sclr_0 FROM City c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM City c0_ SELECT count(c0_.id) AS sclr_0 FROM City c0_;
11	0.09 ms	SELECT count(c0_.id) AS sclr_0 FROM City c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM City c0_ SELECT count(c0_.id) AS sclr_0 FROM City c0_;
12	0.11 ms	SELECT count(c0_.id) AS sclr_0 FROM City c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM City c0_ SELECT count(c0_.id) AS sclr_0 FROM City c0_;
13	0.10 ms	SELECT count(c0_.id) AS sclr_0 FROM City c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM City c0_ SELECT count(c0_.id) AS sclr_0 FROM City c0_;
14	0.10 ms	SELECT count(c0_.id) AS sclr_0 FROM City c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM City c0_ SELECT count(c0_.id) AS sclr_0 FROM City c0_;
15	0.10 ms	SELECT count(c0_.id) AS sclr_0 FROM City c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM City c0_ SELECT count(c0_.id) AS sclr_0 FROM City c0_;
16	0.13 ms	SELECT count(c0_.id) AS sclr_0 FROM City c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM City c0_ SELECT count(c0_.id) AS sclr_0 FROM City c0_;
17	0.09 ms	SELECT count(c0_.id) AS sclr_0 FROM City c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM City c0_ SELECT count(c0_.id) AS sclr_0 FROM City c0_;
18	0.09 ms	SELECT count(c0_.id) AS sclr_0 FROM City c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM City c0_ SELECT count(c0_.id) AS sclr_0 FROM City c0_;
19	0.11 ms	SELECT count(c0_.id) AS sclr_0 FROM City c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM City c0_ SELECT count(c0_.id) AS sclr_0 FROM City c0_;
20	0.11 ms	SELECT count(c0_.id) AS sclr_0 FROM City c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM City c0_ SELECT count(c0_.id) AS sclr_0 FROM City c0_;
21	0.11 ms	SELECT count(c0_.id) AS sclr_0 FROM City c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM City c0_ SELECT count(c0_.id) AS sclr_0 FROM City c0_;
22	0.10 ms	SELECT count(c0_.id) AS sclr_0 FROM City c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM City c0_ SELECT count(c0_.id) AS sclr_0 FROM City c0_;
23	0.10 ms	SELECT count(c0_.id) AS sclr_0 FROM City c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM City c0_ SELECT count(c0_.id) AS sclr_0 FROM City c0_;
24	0.10 ms	SELECT count(c0_.id) AS sclr_0 FROM City c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM City c0_ SELECT count(c0_.id) AS sclr_0 FROM City c0_;
25	0.09 ms	SELECT count(c0_.id) AS sclr_0 FROM City c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM City c0_ SELECT count(c0_.id) AS sclr_0 FROM City c0_;
26	0.09 ms	SELECT count(c0_.id) AS sclr_0 FROM City c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM City c0_ SELECT count(c0_.id) AS sclr_0 FROM City c0_;
27	0.09 ms	SELECT count(c0_.id) AS sclr_0 FROM City c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM City c0_ SELECT count(c0_.id) AS sclr_0 FROM City c0_;
28	4.14 ms	SELECT count(c0_.id) AS sclr_0 FROM Company c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM Company c0_ SELECT count(c0_.id) AS sclr_0 FROM Company c0_;
29	0.15 ms	SELECT count(c0_.id) AS sclr_0 FROM Company c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM Company c0_ SELECT count(c0_.id) AS sclr_0 FROM Company c0_;
30	0.13 ms	SELECT count(c0_.id) AS sclr_0 FROM Company c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM Company c0_ SELECT count(c0_.id) AS sclr_0 FROM Company c0_;
31	0.11 ms	SELECT count(c0_.id) AS sclr_0 FROM Company c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM Company c0_ SELECT count(c0_.id) AS sclr_0 FROM Company c0_;
32	0.21 ms	SELECT count(c0_.id) AS sclr_0 FROM Company c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM Company c0_ SELECT count(c0_.id) AS sclr_0 FROM Company c0_;

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
Webbamboo\SpinnersCommon\Entity\General	No errors.
Webbamboo\SpinnersCommon\Entity\City	No errors.
Webbamboo\SpinnersCommon\Entity\Company	No errors.

Symfony Profiler

GET https://fsd6.webbamboo.net/sitemaps/sitemap-general.xml

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping