Query Metrics

8 Database Queries
8 Different statements
318.63 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
207.30 ms
(65.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
64.75 ms
(20.32%)
1
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  381435
  388569
  391070
  424214
  437947
  454275
  495516
  510877
  531114
  531126
  531136
  531144
  531155
  532995
  537114
  540437
  545851
  550194
  577215
  591170
  620217
  620244
  628649
  635169
  637001
  668668
  682250
  702679
  703833
  704525
  717839
  742356
  744432
  761167
  790389
  796297
  801886
  805274
  817416
  819151
]
30.68 ms
(9.63%)
1
SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?
Parameters:
[
  "double cumshot mature"
  "double cumshot mature"
  "double cumshot mature"
  20
]
7.79 ms
(2.45%)
1
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  388569
  817416
  819151
  744432
  381435
  391070
  801886
  495516
  437947
  717839
  796297
  682250
  591170
  790389
  761167
  742356
  628649
  635169
  454275
  510877
  704525
  620217
  577215
  620244
  805274
  702679
  537114
  531114
  668668
  424214
  531144
  531126
  545851
  550194
  703833
  532995
  531136
  637001
  540437
  531155
]
2.65 ms
(0.83%)
1
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  381435
  388569
  391070
  424214
  437947
  454275
  495516
  510877
  531114
  531126
  531136
  531144
  531155
  532995
  537114
  540437
  545851
  550194
  577215
  591170
  620217
  620244
  628649
  635169
  637001
  668668
  682250
  702679
  703833
  704525
  717839
  742356
  744432
  761167
  790389
  796297
  801886
  805274
  817416
  819151
]
1.95 ms
(0.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "double cumshot mature"
]
1.91 ms
(0.60%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "double cumshot mature"
]
1.60 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "double cumshot mature"
]

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

No loaded entities.