Query Metrics
4
Database Queries
4
Different statements
6.62 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
4.32 ms (65.28%) |
1 |
SELECT p0_.id AS id_0, p0_.monthly_fees AS monthly_fees_1, p0_.monthly_fees_discount AS monthly_fees_discount_2, p0_.yearly_fees AS yearly_fees_3, p0_.yearly_fees_discount AS yearly_fees_discount_4, p0_.setup_fees AS setup_fees_5, p0_.setup_fees_discount AS setup_fees_discount_6, p0_.free_period AS free_period_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p1_.id AS id_10, p1_.enabled AS enabled_11, p1_.highlighted AS highlighted_12, p1_.view_order AS view_order_13, p1_.action_target AS action_target_14, p1_.createdAt AS createdAt_15, p1_.updated_at AS updated_at_16, p2_.name AS name_17, p2_.description AS description_18, p2_.action_name AS action_name_19, p2_.locale AS locale_20, p3_.id AS id_21, p3_.createdAt AS createdAt_22, p3_.updated_at AS updated_at_23, p4_.name AS name_24, p4_.locale AS locale_25, p0_.package_label_id AS package_label_id_26, p0_.created_by_id AS created_by_id_27, p0_.updated_by AS updated_by_28, p1_.created_by AS created_by_29, p1_.updated_by AS updated_by_30, p2_.id AS id_31, p3_.created_by AS created_by_32, p3_.updated_by AS updated_by_33, p4_.id AS id_34 FROM package p0_ INNER JOIN package_label p1_ ON p0_.package_label_id = p1_.id INNER JOIN package_label_translation p2_ ON p1_.id = p2_.id AND (p2_.locale = 'ar') LEFT JOIN package_label_package_benefit p5_ ON p1_.id = p5_.package_label_id LEFT JOIN package_benefit p3_ ON p3_.id = p5_.package_benefit_id LEFT JOIN package_benefit_translation p4_ ON p3_.id = p4_.id AND (p4_.locale = 'ar') WHERE p1_.enabled = 1 AND p0_.id IN (?) ORDER BY p1_.view_order ASC, p1_.id ASC
Parameters:
[ [ "1" "2" "3" ] ] |
0.86 ms (13.00%) |
1 |
SELECT MAX(p0_.id) AS sclr_0 FROM package p0_ GROUP BY p0_.package_label_id
Parameters:
[] |
0.84 ms (12.68%) |
1 |
SELECT c0_.id AS id_0, c0_.lvl AS lvl_1, c0_.lft AS lft_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.name AS name_5, c0_.role AS role_6, c0_.parent_id AS parent_id_7 FROM cms_roles c0_ WHERE c0_.lvl IN (0, 1) AND c0_.role NOT LIKE 'ROLE_ADMIN_%' ORDER BY c0_.root ASC, c0_.lft ASC
Parameters:
[] |
0.60 ms (9.04%) |
1 |
SELECT r0_.name AS name_0, r0_.value AS value_1 FROM runtime_parameter r0_
Parameters:
[] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
tq | doctrine.orm.tq_entity_manager |
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
tq entity manager
No loaded entities.
default entity manager
Class | Mapping errors |
---|---|
Rawafed\SecurityBundle\Entity\Role | No errors. |
Rawafed\SecurityBundle\Entity\RoleRoute | No errors. |
FOS\UserBundle\Model\Group | No errors. |
Rawafed\UserBundle\Entity\Group | No errors. |
FOS\UserBundle\Model\User | No errors. |
Rawafed\UserBundle\Entity\User | No errors. |
Rawafed\ContactFormsBundle\Entity\ContactUsMessage | No errors. |
Rawafed\RuntimeConfigBundle\Entity\Parameter | No errors. |
Rawafed\CloudServicesBundle\Entity\Package | No errors. |
Rawafed\CloudServicesBundle\Entity\PackageLabel | No errors. |
Rawafed\CloudServicesBundle\Entity\PackageLabelTranslation | No errors. |
Rawafed\CloudServicesBundle\Entity\PackageBenefit | No errors. |
Rawafed\CloudServicesBundle\Entity\PackageBenefitTranslation | No errors. |
Rawafed\CloudServicesBundle\Entity\PackageFeature | No errors. |
Rawafed\CloudServicesBundle\Entity\PackageConstraint | No errors. |
Rawafed\ThemeBundle\Entity\Theme | No errors. |