Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
98.75 ms
(47.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:
[
  "arab amateur anal"
  "arab amateur anal"
  "arab amateur anal"
  20
]
86.33 ms
(41.64%)
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
  538567
  542264
  542302
  542321
  542348
  542356
  543307
  543450
  547538
  562342
  567562
  575004
  575038
  575710
  576857
  578182
  578587
  579439
  580577
  585999
  588387
  591870
  593787
  593886
  595241
  599710
  601101
  603084
  604428
  606498
  606951
  610080
  610711
  624152
  630081
  633215
  635183
  640180
  657163
  660435
  663187
  710228
  750227
  750241
  750266
  750879
  762107
  769775
  771251
  789496
  792961
  795295
  797135
  810382
  811549
  825342
  827994
  828215
]
11.08 ms
(5.34%)
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
  769775
  827994
  750266
  579439
  795295
  633215
  588387
  567562
  610711
  593787
  542302
  792961
  750879
  657163
  660435
  635183
  599710
  575004
  762107
  640180
  789496
  825342
  828215
  575038
  606498
  750227
  542264
  542348
  811549
  810382
  595241
  578182
  750241
  547538
  663187
  562342
  580577
  591870
  630081
  575710
  576857
  606951
  603084
  604428
  542356
  543450
  543307
  797135
  624152
  585999
  610080
  578587
  593886
  710228
  538567
  771251
  542321
  601101
]
2.97 ms
(1.43%)
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
  538567
  542264
  542302
  542321
  542348
  542356
  543307
  543450
  547538
  562342
  567562
  575004
  575038
  575710
  576857
  578182
  578587
  579439
  580577
  585999
  588387
  591870
  593787
  593886
  595241
  599710
  601101
  603084
  604428
  606498
  606951
  610080
  610711
  624152
  630081
  633215
  635183
  640180
  657163
  660435
  663187
  710228
  750227
  750241
  750266
  750879
  762107
  769775
  771251
  789496
  792961
  795295
  797135
  810382
  811549
  825342
  827994
  828215
]
2.33 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.14 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "arab amateur anal"
]
1.88 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "араб любительск анал"
]
1.84 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "араб любительск анал"
]

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.