https://immihive.com/services/visas

Query Metrics

2 Database Queries
2 Different statements
4.00 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.81 ms
(70.35%)
1
SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.slug AS slug_2, r0_.path AS path_3, r0_.position AS position_4, r0_.date_created AS date_created_5, r0_.visibility AS visibility_6, r0_.parent_id AS parent_id_7, r0_.route_name AS route_name_8, r0_.template AS template_9, r0_.layout_type AS layout_type_10, r0_.controller AS controller_11, r0_.content_type AS content_type_12, r0_.controller AS controller_13, r0_.content_type AS content_type_14, r0_.url AS url_15, r0_.permanent AS permanent_16, r0_.route_type AS route_type_17 FROM route r0_ WHERE r0_.route_type IN ('list', 'post', 'page', 'taxon', 'url') ORDER BY r0_.position ASC
Parameters:
[]
1.19 ms
(29.65%)
1
SELECT c0_.id AS id_0, c0_.unique_id AS unique_id_1, c0_.title AS title_2, c0_.slug AS slug_3, c0_.summary AS summary_4, c0_.body AS body_5, c0_.thumbnail AS thumbnail_6, c0_.status AS status_7, c0_.is_featured AS is_featured_8, c0_.promoted AS promoted_9, c0_.publish_on_socialmedia AS publish_on_socialmedia_10, c0_.is_published_social_media AS is_published_social_media_11, c0_.is_home AS is_home_12, c0_.date_created AS date_created_13, c0_.date_published AS date_published_14, c0_.meta_keywords AS meta_keywords_15, c0_.meta_description AS meta_description_16, c0_.updated_at AS updated_at_17, c0_.icon AS icon_18, p1_.parent_id AS parent_id_19, u2_.id AS id_20, u2_.username AS username_21, u2_.firstname AS firstname_22, u2_.lastname AS lastname_23, u2_.gender AS gender_24, u2_.dob AS dob_25, u2_.contact_number AS contact_number_26, u2_.email AS email_27, u2_.address AS address_28, u2_.city AS city_29, u2_.country AS country_30, u2_.postal_code AS postal_code_31, u2_.roles AS roles_32, u2_.password AS password_33, u2_.salt AS salt_34, u2_.account_status AS account_status_35, u2_.is_activated AS is_activated_36, u2_.created_at AS created_at_37, u2_.updated_at AS updated_at_38, u2_.thumbnail AS thumbnail_39, r4_.id AS id_40, r4_.title AS title_41, r4_.slug AS slug_42, r4_.path AS path_43, r4_.position AS position_44, r4_.date_created AS date_created_45, r4_.visibility AS visibility_46, r4_.parent_id AS parent_id_47, r4_.route_name AS route_name_48, r4_.template AS template_49, r4_.layout_type AS layout_type_50, c0_.content_type AS content_type_51, c0_.user_id AS user_id_52, c0_.term_id AS term_id_53, p1_.route_id AS route_id_54, u2_.user_type AS user_type_55, r4_.route_type AS route_type_56 FROM page p1_ INNER JOIN contents c0_ ON p1_.id = c0_.id LEFT JOIN users u2_ ON c0_.user_id = u2_.id LEFT JOIN user_admin u3_ ON u2_.id = u3_.id LEFT JOIN route r4_ ON p1_.route_id = r4_.id AND r4_.route_type IN ('page') WHERE r4_.id = ? AND c0_.status = ?
Parameters:
[
  200
  "published"
]

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
Boab\CmsBundle\Entity\Route No errors.
Boab\CmsBundle\Entity\Content No errors.
Boab\CmsBundle\Entity\Event No errors.
Boab\CmsBundle\Entity\Block No errors.
Boab\CmsBundle\Entity\ListRoute No errors.
Boab\CmsBundle\Entity\PostRoute No errors.
Boab\CmsBundle\Entity\PageRoute No errors.
Boab\CmsBundle\Entity\TermRoute No errors.
Boab\CmsBundle\Entity\UrlRoute No errors.
Boab\CmsBundle\Entity\Term No errors.
Boab\CmsBundle\Entity\Page No errors.
Boab\CmsBundle\Entity\User No errors.
Boab\CmsBundle\Entity\Admin No errors.
Boab\CmsBundle\Entity\Photo No errors.
Boab\CmsBundle\Entity\Media No errors.