Query Metrics

7 Database Queries
7 Different statements
185.97 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
166.23 ms
(89.38%)
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
  382073
  388393
  389897
  396069
  406836
  413716
  421290
  435047
  441615
  450331
  454514
  456005
  460017
  462843
  463517
  463733
  465969
  466035
  466704
  469428
  471712
  472083
  488594
  489266
  491631
  494250
  496587
  496895
  497687
  507379
  508687
  508894
  510331
  511080
  513658
  514249
  515289
  516373
  517660
  517763
  522223
  524935
  534170
  546652
  547768
  547769
  547799
  547804
  552382
  554772
  554864
  576474
  584126
  594038
  596263
  597899
  600958
  608827
  620880
  626217
  628901
  633983
  638413
  642462
  654084
  662438
  663088
  663538
  666493
  670336
  673116
  677237
  677240
  680754
  683073
  693313
  700919
  701404
  704280
  706422
  707394
  709355
  720622
  729382
  739769
  739827
  739903
  742641
  743947
  744919
  745942
  748623
  751050
  754086
  756307
  757020
  758070
  761922
  764507
  769209
  770679
  772360
  773253
  775448
  777784
  785087
  786912
  787002
  791132
  791395
  794769
  796270
  799153
  801669
  807271
  810440
  811215
  811537
  811961
  813418
]
10.94 ms
(5.88%)
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
  706422
  693313
  775448
  811537
  791395
  739903
  754086
  796270
  799153
  388393
  396069
  466035
  663088
  700919
  620880
  786912
  801669
  729382
  794769
  748623
  743947
  739827
  761922
  707394
  709355
  469428
  534170
  494250
  515289
  489266
  496895
  638413
  406836
  450331
  547799
  628901
  513658
  680754
  777784
  811215
  773253
  744919
  770679
  704280
  807271
  811961
  466704
  465969
  626217
  633983
  454514
  510331
  508894
  496587
  460017
  552382
  654084
  663538
  677237
  642462
  751050
  785087
  742641
  756307
  472083
  471712
  511080
  522223
  517763
  382073
  389897
  421290
  547768
  517660
  666493
  584126
  594038
  514249
  683073
  456005
  463517
  597899
  608827
  508687
  547769
  554772
  673116
  720622
  596263
  600958
  810440
  757020
  769209
  745942
  739769
  758070
  764507
  787002
  791132
  813418
  441615
  497687
  516373
  488594
  547804
  576474
  546652
  662438
  772360
  462843
  435047
  524935
  491631
  413716
  463733
  507379
  554864
  670336
  677240
  701404
]
2.58 ms
(1.39%)
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
  382073
  388393
  389897
  396069
  406836
  413716
  421290
  435047
  441615
  450331
  454514
  456005
  460017
  462843
  463517
  463733
  465969
  466035
  466704
  469428
  471712
  472083
  488594
  489266
  491631
  494250
  496587
  496895
  497687
  507379
  508687
  508894
  510331
  511080
  513658
  514249
  515289
  516373
  517660
  517763
  522223
  524935
  534170
  546652
  547768
  547769
  547799
  547804
  552382
  554772
  554864
  576474
  584126
  594038
  596263
  597899
  600958
  608827
  620880
  626217
  628901
  633983
  638413
  642462
  654084
  662438
  663088
  663538
  666493
  670336
  673116
  677237
  677240
  680754
  683073
  693313
  700919
  701404
  704280
  706422
  707394
  709355
  720622
  729382
  739769
  739827
  739903
  742641
  743947
  744919
  745942
  748623
  751050
  754086
  756307
  757020
  758070
  761922
  764507
  769209
  770679
  772360
  773253
  775448
  777784
  785087
  786912
  787002
  791132
  791395
  794769
  796270
  799153
  801669
  807271
  810440
  811215
  811537
  811961
  813418
]
1.70 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "розовый киски"
]
1.59 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "розов вагин"
]
1.53 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.39 ms
(0.75%)
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.