Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
96.75 ms
(68.29%)
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
  400802
  405891
  416311
  435521
  446853
  450557
  458800
  459429
  483315
  486277
  492518
  492537
  493272
  494530
  498022
  505604
  514913
  522292
  524799
  534530
  537653
  543109
  543218
  549601
  556906
  559783
  586452
  599187
  610490
  615456
  626439
  642706
  665950
  675402
  676026
  707571
  708827
  730975
  737445
  739408
  744408
  745874
  745921
  750462
  750611
  768033
  769469
  776303
  778364
  779125
  780615
  789932
  796694
  797350
  801639
  803824
  811690
  814932
  819826
  824394
  824414
]
24.37 ms
(17.20%)
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:
[
  "stretch pussy"
  "stretch pussy"
  "stretch pussy"
  20
]
10.41 ms
(7.35%)
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
  824394
  400802
  819826
  797350
  524799
  745921
  776303
  665950
  796694
  610490
  769469
  459429
  493272
  492537
  814932
  789932
  435521
  730975
  750462
  811690
  615456
  492518
  549601
  768033
  780615
  824414
  586452
  744408
  739408
  708827
  543218
  707571
  505604
  446853
  514913
  458800
  534530
  556906
  543109
  559783
  675402
  626439
  778364
  801639
  803824
  737445
  745874
  494530
  486277
  779125
  416311
  450557
  522292
  599187
  483315
  537653
  750611
  498022
  405891
  676026
  642706
]
3.44 ms
(2.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
  400802
  405891
  416311
  435521
  446853
  450557
  458800
  459429
  483315
  486277
  492518
  492537
  493272
  494530
  498022
  505604
  514913
  522292
  524799
  534530
  537653
  543109
  543218
  549601
  556906
  559783
  586452
  599187
  610490
  615456
  626439
  642706
  665950
  675402
  676026
  707571
  708827
  730975
  737445
  739408
  744408
  745874
  745921
  750462
  750611
  768033
  769469
  776303
  778364
  779125
  780615
  789932
  796694
  797350
  801639
  803824
  811690
  814932
  819826
  824394
  824414
]
1.94 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "stretch pussy"
]
1.67 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "stretch pussy"
]
1.66 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "stretch pussy"
]

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.