Query Metrics
13
Database Queries
5
Different statements
1431.12 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.57 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.code AS code_5, t0.name AS name_6 FROM languages t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"storage"
]
|
| 2 | 0.23 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.code AS code_5, t0.name AS name_6 FROM languages t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 3 | 178.25 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.keyword = ? AND t0.language_id = ? AND t0.archived = ? AND (t0.domain_id IN (?, ?) OR t0.domain_id IS NULL) LIMIT 1
Parameters:
[ "storage" 1 0 1 null ] |
| 4 | 170.26 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.keyword = ? AND t0.language_id = ? AND t0.archived = ? AND (t0.domain_id IN (?, ?) OR t0.domain_id IS NULL) LIMIT 1
Parameters:
[ "storage" 1 1 1 null ] |
| 5 | 178.57 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.keyword = ? AND t0.language_id = ? AND t0.archived = ? AND (t0.domain_id IN (?, ?) OR t0.domain_id IS NULL) LIMIT 1
Parameters:
[ "storage" 1 0 1 null ] |
| 6 | 176.91 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.keyword = ? AND t0.language_id = ? AND t0.archived = ? AND (t0.domain_id IN (?, ?) OR t0.domain_id IS NULL) LIMIT 1
Parameters:
[ "image" 1 1 1 null ] |
| 7 | 204.55 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.keyword = ? AND t0.language_id = ? AND t0.archived = ? AND (t0.domain_id IN (?, ?) OR t0.domain_id IS NULL) LIMIT 1
Parameters:
[ "image" 1 0 1 null ] |
| 8 | 139.73 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.keyword = ? AND t0.language_id = ? AND t0.archived = ? AND (t0.domain_id IN (?, ?) OR t0.domain_id IS NULL) LIMIT 1
Parameters:
[ "blog" 1 1 1 null ] |
| 9 | 6.27 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.keyword = ? AND t0.language_id = ? AND t0.archived = ? AND (t0.domain_id IN (?, ?) OR t0.domain_id IS NULL) LIMIT 1
Parameters:
[ "blog" 1 0 1 null ] |
| 10 | 187.47 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.keyword = ? AND t0.language_id = ? AND t0.archived = ? AND (t0.domain_id IN (?, ?) OR t0.domain_id IS NULL) LIMIT 1
Parameters:
[ "všetko-v-jednom-all-in-one-pc-540x304.jpg" 1 1 1 null ] |
| 11 | 186.71 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.keyword = ? AND t0.language_id = ? AND t0.archived = ? AND (t0.domain_id IN (?, ?) OR t0.domain_id IS NULL) LIMIT 1
Parameters:
[ "všetko-v-jednom-all-in-one-pc-540x304.jpg" 1 0 1 null ] |
| 12 | 0.56 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.type AS type_5, t0.name AS name_6, t0.currency AS currency_7, t0.price_factor AS price_factor_8, t0.price_precision AS price_precision_9, t0.price_end AS price_end_10, t0.price_end2 AS price_end2_11, t0.price_end2_under AS price_end2_under_12, t0.vat AS vat_13, t0.warranty AS warranty_14, t0.url AS url_15, t0.title AS title_16, t0.short_title AS short_title_17, t0.ga_id AS ga_id_18, t0.blog_url AS blog_url_19, t0.facebook_url AS facebook_url_20, t0.twitter_url AS twitter_url_21, t0.youtube_url AS youtube_url_22, t0.gplus_url AS gplus_url_23, t0.livechat_username AS livechat_username_24, t0.javascripts AS javascripts_25, t0.language_id AS language_id_26, t0.company_id AS company_id_27, t0.default_sales_manager_id AS default_sales_manager_id_28 FROM domains t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 13 | 1.03 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.query = ? AND t0.language_id = ? AND t0.domain_id = ? AND t0.archived = ? LIMIT 1
Parameters:
[ "category_id=3" 1 1 0 ] |
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 |
|---|---|
| App\AtechNet\CoreBundle\Entity\AbstractEntity | No errors. |
| App\AtechNet\CoreBundle\Entity\AbstractSortableEntity | No errors. |
| App\AtechNet\CoreBundle\Entity\Language | No errors. |
| App\AtechNet\CoreBundle\Entity\Translation | No errors. |
| App\AtechNet\CoreBundle\Entity\Country | No errors. |
| App\AtechNet\CoreBundle\Entity\SeoUrl | No errors. |
| App\AtechNet\CoreBundle\Entity\Domain | No errors. |
| App\AtechNet\CoreBundle\Entity\Company | No errors. |
| App\AtechNet\CoreBundle\Entity\AbstractSignedEntity | No errors. |
| App\AtechNet\CoreBundle\Entity\User | No errors. |
| App\AtechNet\CoreBundle\Entity\Customer | No errors. |
| App\AtechNet\CoreBundle\Entity\DomainShippingType | No errors. |
| App\AtechNet\CoreBundle\Entity\DomainPaymentType | No errors. |
| App\AtechNet\CoreBundle\Entity\Order | No errors. |
| App\AtechNet\CoreBundle\Entity\DocumentGroup | No errors. |
| App\AtechNet\CoreBundle\Entity\Banner | No errors. |
| App\AtechNet\CoreBundle\Entity\Nanobar | No errors. |