Symfony Profiler

Query Metrics

32 Database Queries

3 Different statements

28.01 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.40 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	0.20 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	1.70 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.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_;
5	0.08 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.08 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.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_;
8	2.16 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.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_;
10	0.08 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	3.20 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	2.92 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.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_;
15	0.08 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.08 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.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_;
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.08 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.08 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.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_;
22	0.08 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	3.18 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.27 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.07 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.08 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	3.25 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	3.22 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.09 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.08 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	5.53 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.09 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