Query Metrics
13
Database Queries
5
Different statements
1195.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1192.37 ms (99.70%) |
9 |
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 ] |
|
2.17 ms (0.18%) |
1 |
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 ] |
|
0.61 ms (0.05%) |
1 |
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"
]
|
|
0.53 ms (0.04%) |
1 |
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
]
|
|
0.29 ms (0.02%) |
1 |
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
]
|
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. |