http://alphawerks.co.uk/blog/elasticsearch

Query Metrics

22 Database Queries
11 Different statements
9.87 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.52 ms
SELECT t0.id AS id_1, t0.orgName AS orgName_2, t0.companyRegNumber AS companyRegNumber_3, t0.companyVatNumber AS companyVatNumber_4, t0.logoFilename AS logoFilename_5, t0.genEmail AS genEmail_6, t0.genPhoneNumber AS genPhoneNumber_7, t0.salesEmail AS salesEmail_8, t0.salesPhoneNumber AS salesPhoneNumber_9, t0.twitterLink AS twitterLink_10, t0.facebookLink AS facebookLink_11, t0.googlePlusLink AS googlePlusLink_12, t0.linkedinLink AS linkedinLink_13, t0.googleMapsAPIKey AS googleMapsAPIKey_14, t0.googleAnalyticsCode AS googleAnalyticsCode_15, t0.twitterAPIKey AS twitterAPIKey_16, t0.crmAPIKey AS crmAPIKey_17, t0.created AS created_18, t0.updated AS updated_19, t0.feature1_id AS feature1_id_20, t0.feature2_id AS feature2_id_21, t0.feature3_id AS feature3_id_22, t0.created_by AS created_by_23, t0.updated_by AS updated_by_24 FROM sitewide t0 ORDER BY t0.id ASC LIMIT 1
Parameters:
[]
2 0.48 ms
SELECT p0_.name AS name_0, p0_.slug AS slug_1 FROM pages p0_ WHERE p0_.category = ? AND p0_.publish = 1 ORDER BY p0_.position ASC
Parameters:
[
  "Main Nav"
]
3 0.35 ms
SELECT p0_.name AS name_0, p0_.slug AS slug_1 FROM pages p0_ WHERE p0_.category = ? AND p0_.publish = 1 ORDER BY p0_.position ASC
Parameters:
[
  "Other Nav"
]
4 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type AS type_4, t0.metaTitle AS metaTitle_5, t0.metaKeywords AS metaKeywords_6, t0.metaDescription AS metaDescription_7, t0.title AS title_8, t0.content AS content_9, t0.position AS position_10, t0.category AS category_11, t0.bannerImage AS bannerImage_12, t0.bannerContent AS bannerContent_13, t0.publish AS publish_14, t0.created AS created_15, t0.updated AS updated_16, t0.feature1_id AS feature1_id_17, t0.feature2_id AS feature2_id_18, t0.feature3_id AS feature3_id_19, t0.created_by AS created_by_20, t0.updated_by AS updated_by_21 FROM pages t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Blog"
]
5 0.57 ms
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.publish AS publish_6, t0.created AS created_7, t0.updated AS updated_8, t0.datePublished AS datePublished_9, t0.image_name AS image_name_10, t0.updated_at AS updated_at_11, t0.count AS count_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14 FROM articles t0 WHERE t0.publish = ? ORDER BY t0.datePublished DESC
Parameters:
[
  1
]
6 0.38 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.slug AS slug_4, t0.created AS created_5, t0.updated AS updated_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM tags t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "elasticsearch"
]
7 0.60 ms
SELECT a0_.id AS id_0, a0_.author AS author_1, a0_.title AS title_2, a0_.content AS content_3, a0_.slug AS slug_4, a0_.publish AS publish_5, a0_.created AS created_6, a0_.updated AS updated_7, a0_.datePublished AS datePublished_8, a0_.image_name AS image_name_9, a0_.updated_at AS updated_at_10, a0_.count AS count_11, a0_.created_by AS created_by_12, a0_.updated_by AS updated_by_13 FROM articles a0_ LEFT JOIN articles_tags a2_ ON a0_.id = a2_.articles_id LEFT JOIN tags t1_ ON t1_.id = a2_.tags_id WHERE a0_.publish = 1 AND t1_.slug = ? ORDER BY a0_.datePublished DESC
Parameters:
[
  "elasticsearch"
]
8 0.36 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.slug AS slug_4, t0.created AS created_5, t0.updated AS updated_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM tags t0 ORDER BY t0.name ASC
Parameters:
[]
9 0.47 ms
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.publish AS publish_6, t0.created AS created_7, t0.updated AS updated_8, t0.datePublished AS datePublished_9, t0.image_name AS image_name_10, t0.updated_at AS updated_at_11, t0.count AS count_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14 FROM articles t0 INNER JOIN articles_tags ON t0.id = articles_tags.articles_id WHERE articles_tags.tags_id = ?
Parameters:
[
  6
]
10 0.43 ms
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.publish AS publish_6, t0.created AS created_7, t0.updated AS updated_8, t0.datePublished AS datePublished_9, t0.image_name AS image_name_10, t0.updated_at AS updated_at_11, t0.count AS count_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14 FROM articles t0 INNER JOIN articles_tags ON t0.id = articles_tags.articles_id WHERE articles_tags.tags_id = ?
Parameters:
[
  4
]
11 0.45 ms
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.publish AS publish_6, t0.created AS created_7, t0.updated AS updated_8, t0.datePublished AS datePublished_9, t0.image_name AS image_name_10, t0.updated_at AS updated_at_11, t0.count AS count_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14 FROM articles t0 INNER JOIN articles_tags ON t0.id = articles_tags.articles_id WHERE articles_tags.tags_id = ?
Parameters:
[
  3
]
12 0.46 ms
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.publish AS publish_6, t0.created AS created_7, t0.updated AS updated_8, t0.datePublished AS datePublished_9, t0.image_name AS image_name_10, t0.updated_at AS updated_at_11, t0.count AS count_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14 FROM articles t0 INNER JOIN articles_tags ON t0.id = articles_tags.articles_id WHERE articles_tags.tags_id = ?
Parameters:
[
  10
]
13 0.45 ms
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.publish AS publish_6, t0.created AS created_7, t0.updated AS updated_8, t0.datePublished AS datePublished_9, t0.image_name AS image_name_10, t0.updated_at AS updated_at_11, t0.count AS count_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14 FROM articles t0 INNER JOIN articles_tags ON t0.id = articles_tags.articles_id WHERE articles_tags.tags_id = ?
Parameters:
[
  2
]
14 0.42 ms
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.publish AS publish_6, t0.created AS created_7, t0.updated AS updated_8, t0.datePublished AS datePublished_9, t0.image_name AS image_name_10, t0.updated_at AS updated_at_11, t0.count AS count_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14 FROM articles t0 INNER JOIN articles_tags ON t0.id = articles_tags.articles_id WHERE articles_tags.tags_id = ?
Parameters:
[
  5
]
15 0.52 ms
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.publish AS publish_6, t0.created AS created_7, t0.updated AS updated_8, t0.datePublished AS datePublished_9, t0.image_name AS image_name_10, t0.updated_at AS updated_at_11, t0.count AS count_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14 FROM articles t0 INNER JOIN articles_tags ON t0.id = articles_tags.articles_id WHERE articles_tags.tags_id = ?
Parameters:
[
  1
]
16 0.38 ms
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.publish AS publish_6, t0.created AS created_7, t0.updated AS updated_8, t0.datePublished AS datePublished_9, t0.image_name AS image_name_10, t0.updated_at AS updated_at_11, t0.count AS count_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14 FROM articles t0 INNER JOIN articles_tags ON t0.id = articles_tags.articles_id WHERE articles_tags.tags_id = ?
Parameters:
[
  9
]
17 0.43 ms
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.publish AS publish_6, t0.created AS created_7, t0.updated AS updated_8, t0.datePublished AS datePublished_9, t0.image_name AS image_name_10, t0.updated_at AS updated_at_11, t0.count AS count_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14 FROM articles t0 INNER JOIN articles_tags ON t0.id = articles_tags.articles_id WHERE articles_tags.tags_id = ?
Parameters:
[
  7
]
18 0.30 ms
SELECT t0.id AS id_1, t0.author AS author_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.publish AS publish_6, t0.created AS created_7, t0.updated AS updated_8, t0.datePublished AS datePublished_9, t0.image_name AS image_name_10, t0.updated_at AS updated_at_11, t0.count AS count_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14 FROM articles t0 INNER JOIN articles_tags ON t0.id = articles_tags.articles_id WHERE articles_tags.tags_id = ?
Parameters:
[
  8
]
19 0.50 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.slug AS slug_3, t0.salt AS salt_4, t0.password AS password_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.roles AS roles_8, t0.created AS created_9, t0.updated AS updated_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t13.id AS id_14, t13.firstName AS firstName_15, t13.lastName AS lastName_16, t13.slug AS slug_17, t13.roleTitle AS roleTitle_18, t13.team AS team_19, t13.email AS email_20, t13.phoneNumber AS phoneNumber_21, t13.phoneExtension AS phoneExtension_22, t13.mobileNumber AS mobileNumber_23, t13.faxNumber AS faxNumber_24, t13.skypeName AS skypeName_25, t13.twitterName AS twitterName_26, t13.facebookLink AS facebookLink_27, t13.linkedInLink AS linkedInLink_28, t13.googlePlusLink AS googlePlusLink_29, t13.specialities AS specialities_30, t13.bio AS bio_31, t13.interests AS interests_32, t13.recommendations AS recommendations_33, t13.companyQuote AS companyQuote_34, t13.thumbnailName AS thumbnailName_35, t13.photoName AS photoName_36, t13.backgroundName AS backgroundName_37, t13.crmID AS crmID_38, t13.publish AS publish_39, t13.position AS position_40, t13.datePublished AS datePublished_41, t13.created AS created_42, t13.updated AS updated_43, t13.user_id AS user_id_44, t13.manager_id AS manager_id_45, t13.created_by AS created_by_46, t13.updated_by AS updated_by_47 FROM users t0 LEFT JOIN people t13 ON t13.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  2
]
20 0.41 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.slug AS slug_4, t0.created AS created_5, t0.updated AS updated_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM tags t0 INNER JOIN articles_tags ON t0.id = articles_tags.tags_id WHERE articles_tags.articles_id = ?
Parameters:
[
  2
]
21 0.47 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.slug AS slug_4, t0.created AS created_5, t0.updated AS updated_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM tags t0 INNER JOIN articles_tags ON t0.id = articles_tags.tags_id WHERE articles_tags.articles_id = ?
Parameters:
[
  1
]
22 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.title AS title_4, t0.content AS content_5, t0.position AS position_6, t0.category AS category_7, t0.icon AS icon_8, t0.publish AS publish_9, t0.created AS created_10, t0.updated AS updated_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13 FROM features t0 WHERE t0.id = ?
Parameters:
[
  2
]

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\Entity\Sitewide No errors.
App\Entity\Features No errors.
App\Entity\User No errors.
App\Entity\Pages No errors.
App\Entity\Articles No errors.
App\Entity\Tags No errors.
App\Entity\People No errors.