Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
64.49 ms
(43.49%)
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:
[
  "wife crying anal"
  "wife crying anal"
  "wife crying anal"
  20
]
63.41 ms
(42.76%)
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
  390508
  423499
  425353
  428756
  429383
  430355
  430374
  432582
  432692
  432843
  435472
  441168
  451497
  452228
  453324
  456362
  456809
  482768
  484372
  491802
  492495
  499867
  500978
  505614
  506529
  510553
  512966
  513508
  518521
  519436
  521205
  522434
  523134
  524506
  525391
  527874
  534494
  537970
  538266
  542127
  547556
  550337
  555291
  575713
  584712
  592614
  594810
  597736
  601423
  602371
  604046
  604631
  608751
  609292
  610695
  619965
  622233
  622778
  624375
  625572
  638024
]
10.97 ms
(7.40%)
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
  432692
  534494
  519436
  542127
  525391
  492495
  423499
  435472
  550337
  521205
  638024
  604631
  430355
  491802
  547556
  624375
  390508
  592614
  510553
  622233
  456362
  456809
  602371
  594810
  430374
  500978
  538266
  513508
  527874
  512966
  522434
  432843
  429383
  523134
  432582
  506529
  452228
  482768
  601423
  604046
  505614
  425353
  428756
  453324
  499867
  609292
  537970
  597736
  555291
  524506
  608751
  625572
  619965
  451497
  575713
  484372
  441168
  584712
  622778
  518521
  610695
]
2.16 ms
(1.46%)
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
  390508
  423499
  425353
  428756
  429383
  430355
  430374
  432582
  432692
  432843
  435472
  441168
  451497
  452228
  453324
  456362
  456809
  482768
  484372
  491802
  492495
  499867
  500978
  505614
  506529
  510553
  512966
  513508
  518521
  519436
  521205
  522434
  523134
  524506
  525391
  527874
  534494
  537970
  538266
  542127
  547556
  550337
  555291
  575713
  584712
  592614
  594810
  597736
  601423
  602371
  604046
  604631
  608751
  609292
  610695
  619965
  622233
  622778
  624375
  625572
  638024
]
1.93 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife crying anal"
]
1.90 ms
(1.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен крича вперв анал"
]
1.89 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.