Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.87 ms
(82.39%)
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
  358596
  389765
  391941
  400463
  400912
  411342
  411384
  419042
  424406
  436031
  443708
  443761
  443789
  443793
  443964
  447314
  451542
  451565
  451574
  453614
  454231
  454262
  460732
  462830
  463157
  466085
  467635
  470229
  470653
  470743
  470918
  474014
  474659
  474674
  484561
  484687
  484715
  486391
  486392
  488730
  489991
  490682
  490834
  495622
  497544
  497572
  497887
  498497
  500429
  506051
  506059
  510762
  512289
  512334
  514816
  517858
  522092
  522789
  523321
  523975
  535591
  540902
  542964
  544393
  546022
  546684
  548734
  548738
  548743
  548753
  548756
  548780
  551162
  551220
  557939
  560466
  562254
  562369
  566432
  568001
  570414
  574781
  575501
  575506
  575803
  576405
  578363
  582201
  583728
  591192
  595813
  597494
  598452
  601994
  607730
  617652
  619204
  641756
  651855
  651856
  659295
  659321
  661237
  661264
  670721
  670965
  677082
  679365
  683301
  695125
  733866
  740584
  742162
  745404
  751566
  758404
  766135
  766325
  775834
  811611
]
19.77 ms
(11.48%)
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
  498497
  411384
  560466
  575803
  661237
  582201
  400912
  436031
  540902
  358596
  454262
  484715
  470653
  548756
  470743
  411342
  474014
  447314
  443761
  474674
  495622
  562254
  460732
  443789
  466085
  506051
  484561
  557939
  548780
  548753
  659295
  443708
  453614
  391941
  470918
  419042
  462830
  454231
  486391
  490682
  443793
  451565
  451542
  514816
  489991
  542964
  488730
  517858
  484687
  500429
  470229
  443964
  497572
  497544
  679365
  566432
  758404
  740584
  670965
  607730
  641756
  548734
  551162
  570414
  683301
  651856
  670721
  695125
  562369
  601994
  742162
  733866
  766325
  389765
  523975
  497887
  490834
  522789
  535591
  575501
  548743
  546022
  583728
  677082
  548738
  551220
  617652
  619204
  597494
  751566
  811611
  400463
  474659
  512289
  523321
  424406
  510762
  522092
  546684
  568001
  578363
  575506
  544393
  651855
  659321
  661264
  574781
  576405
  598452
  591192
  595813
  775834
  745404
  766135
  451574
  463157
  467635
  512334
  486392
  506059
]
3.03 ms
(1.76%)
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
  358596
  389765
  391941
  400463
  400912
  411342
  411384
  419042
  424406
  436031
  443708
  443761
  443789
  443793
  443964
  447314
  451542
  451565
  451574
  453614
  454231
  454262
  460732
  462830
  463157
  466085
  467635
  470229
  470653
  470743
  470918
  474014
  474659
  474674
  484561
  484687
  484715
  486391
  486392
  488730
  489991
  490682
  490834
  495622
  497544
  497572
  497887
  498497
  500429
  506051
  506059
  510762
  512289
  512334
  514816
  517858
  522092
  522789
  523321
  523975
  535591
  540902
  542964
  544393
  546022
  546684
  548734
  548738
  548743
  548753
  548756
  548780
  551162
  551220
  557939
  560466
  562254
  562369
  566432
  568001
  570414
  574781
  575501
  575506
  575803
  576405
  578363
  582201
  583728
  591192
  595813
  597494
  598452
  601994
  607730
  617652
  619204
  641756
  651855
  651856
  659295
  659321
  661237
  661264
  670721
  670965
  677082
  679365
  683301
  695125
  733866
  740584
  742162
  745404
  751566
  758404
  766135
  766325
  775834
  811611
]
2.18 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.00 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "групповом секс русско…"
]
1.67 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "группов секс русск"
]
1.66 ms
(0.97%)
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.