Query Metrics
7
Database Queries
7
Different statements
185.35 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 26.24 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nip AS nip_5, t0.phone_number AS phone_number_6, t0.consent AS consent_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.active AS active_10, t0.confirmed_at AS confirmed_at_11, t0.activation_token AS activation_token_12, t0.logo_url AS logo_url_13, t0.name AS name_14, t0.slug AS slug_15, t0.bio AS bio_16, t0.bio2 AS bio2_17, t0.express_hour AS express_hour_18, t0.postal_code AS postal_code_19, t0.city AS city_20, t0.street AS street_21, t0.visible AS visible_22, t0.contact_person AS contact_person_23, t0.service_terms_accepted AS service_terms_accepted_24, t0.personal_data_processing_consent AS personal_data_processing_consent_25, t0.commission AS commission_26, t0.transport_terms AS transport_terms_27, t0.fixed_commission AS fixed_commission_28, t0.fixed_commission_prolong AS fixed_commission_prolong_29, t0.first_commission_fixed AS first_commission_fixed_30, t0.fixed_commission_express AS fixed_commission_express_31, t0.transport_terms_updated_at AS transport_terms_updated_at_32, t0.last_login AS last_login_33, t0.bdo_company_name AS bdo_company_name_34, t0.bdo_register_number AS bdo_register_number_35, t0.bdo_location AS bdo_location_36, t0.mpd_number AS mpd_number_37, t0.bdo_number AS bdo_number_38 FROM user t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"pan-gruzik-145"
]
|
| 2 | 25.96 ms |
SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.updated_at AS updated_at_2, o0_.rating AS rating_3, o0_.nick AS nick_4, o0_.opinion AS opinion_5, o0_.answer AS answer_6, o0_.order_entity_id AS order_entity_id_7, o0_.user_id AS user_id_8 FROM opinion o0_ WHERE o0_.user_id = ?
Parameters:
[
145
]
|
| 3 | 26.01 ms |
SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.updated_at AS updated_at_2, o0_.rating AS rating_3, o0_.nick AS nick_4, o0_.opinion AS opinion_5, o0_.answer AS answer_6, o0_.order_entity_id AS order_entity_id_7, o0_.user_id AS user_id_8 FROM opinion o0_ WHERE o0_.user_id = ? LIMIT 5
Parameters:
[
145
]
|
| 4 | 27.40 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.name_pl AS name_pl_2, c0_.size AS size_3, c0_.enabled AS enabled_4, c0_.priority AS priority_5 FROM container_size c0_ INNER JOIN service s1_ ON c0_.id = s1_.container_size_id INNER JOIN user_service u2_ ON s1_.id = u2_.service_id INNER JOIN period p3_ ON s1_.period_id = p3_.id LEFT JOIN user u4_ ON u2_.user_id = u4_.id WHERE c0_.enabled = ? AND s1_.enabled = ? AND u2_.enabled = ? AND p3_.enabled = ? AND u4_.active = ? AND u4_.visible = ? GROUP BY c0_.id ORDER BY c0_.priority DESC, c0_.size ASC
Parameters:
[ 1 1 1 1 1 1 ] |
| 5 | 27.21 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.weeks AS weeks_2, p0_.enabled AS enabled_3 FROM period p0_ INNER JOIN service s1_ ON p0_.id = s1_.period_id INNER JOIN user_service u2_ ON s1_.id = u2_.service_id INNER JOIN container_size c3_ ON s1_.container_size_id = c3_.id LEFT JOIN user u4_ ON u2_.user_id = u4_.id WHERE p0_.enabled = ? AND s1_.enabled = ? AND u2_.enabled = ? AND c3_.enabled = ? AND u4_.active = ? AND u4_.visible = ? GROUP BY p0_.id ORDER BY p0_.weeks ASC
Parameters:
[ 1 1 1 1 1 1 ] |
| 6 | 26.10 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.rating AS rating_4, t0.nick AS nick_5, t0.opinion AS opinion_6, t0.answer AS answer_7, t0.order_entity_id AS order_entity_id_8, t0.user_id AS user_id_9 FROM opinion t0 WHERE t0.user_id = ?
Parameters:
[
145
]
|
| 7 | 26.42 ms |
SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = ? AND w1_.environment = ?)) AND w0_.webspace_key = ? ORDER BY w0_.id ASC
Parameters:
[ "gzedev.mm-service.pl" "dev" "wywoz_gruzu" ] |
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 |
|---|---|
| Sulu\Bundle\TrashBundle\Domain\Model\TrashItem | No errors. |
| Sulu\Bundle\MediaBundle\Entity\Collection | No errors. |
| Sulu\Bundle\ContactBundle\Entity\ContactTitle | No errors. |
| Sulu\Bundle\SecurityBundle\Entity\Group | No errors. |
| App\Entity\Opinion | No errors. |
| App\Entity\User | No errors. |
| App\Entity\AreaCommunity | No errors. |
| App\Entity\UserService | No errors. |
| App\Entity\ChangePasswordRequest | No errors. |
| App\Entity\Report | No errors. |
| App\Entity\Order | No errors. |
| App\Entity\ContainerSize | No errors. |
| App\Entity\Service | No errors. |
| App\Entity\Period | No errors. |
| Sulu\Bundle\WebsiteBundle\Entity\Analytics | No errors. |
| Sulu\Bundle\WebsiteBundle\Entity\Domain | No errors. |