Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
186.57 ms
(86.01%)
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
  149612
  415878
  422392
  435795
  443233
  443956
  448553
  450112
  456312
  458047
  464987
  465990
  466092
  467102
  469591
  470660
  471420
  472409
  472418
  475561
  475885
  476471
  476613
  478381
  478940
  478949
  485400
  487007
  487633
  490399
  491102
  494204
  495031
  496334
  498193
  501699
  506329
  507266
  512089
  517397
  517399
  519489
  525656
  525882
  526473
  532388
  538468
  538730
  544219
  544952
  545972
  546456
  547008
  547885
  548392
  548467
  552510
  556446
  557525
  558172
  559832
  562458
  562561
  564032
  564371
  564753
  564760
  566652
  568017
  575634
  579221
  579867
  582321
  592988
  593271
  597162
  616635
  618682
  627156
  627696
  649476
  668782
  668829
  709894
  713422
  715535
  716309
  731010
  732987
  742688
  754994
  768081
  768893
  781918
  782358
  800981
  813738
  817069
  817206
  817542
  817551
  817560
  817574
  818955
  818957
  818984
  819869
  820055
  823273
  823651
  823846
  823999
  824479
  824520
  824886
  825270
  826438
  826890
  827225
]
19.78 ms
(9.12%)
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
  435795
  415878
  458047
  464987
  465990
  487007
  485400
  487633
  512089
  496334
  467102
  469591
  472418
  478940
  545972
  582321
  548392
  668782
  579221
  579867
  597162
  443233
  448553
  475561
  476613
  478949
  443956
  466092
  422392
  470660
  471420
  472409
  476471
  450112
  456312
  475885
  478381
  525882
  526473
  490399
  495031
  506329
  507266
  517399
  519489
  525656
  494204
  498193
  501699
  517397
  558172
  491102
  592988
  826438
  538730
  538468
  532388
  544219
  548467
  564032
  564371
  546456
  547008
  564753
  564760
  566652
  649476
  556446
  557525
  627156
  616635
  593271
  800981
  781918
  782358
  731010
  768081
  732987
  754994
  768893
  742688
  618682
  149612
  817551
  818957
  818984
  826523
  824520
  826890
  827225
  813738
  817069
  817542
  819869
  820055
  823651
  823999
  824479
  817206
  817560
  817574
  818955
  823273
  823846
  824886
  825270
  544952
  559832
  562458
  552510
  709894
  715535
  716309
  668829
  713422
  547885
  562561
  568017
  575634
  627696
]
3.57 ms
(1.65%)
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
  149612
  415878
  422392
  435795
  443233
  443956
  448553
  450112
  456312
  458047
  464987
  465990
  466092
  467102
  469591
  470660
  471420
  472409
  472418
  475561
  475885
  476471
  476613
  478381
  478940
  478949
  485400
  487007
  487633
  490399
  491102
  494204
  495031
  496334
  498193
  501699
  506329
  507266
  512089
  517397
  517399
  519489
  525656
  525882
  526473
  532388
  538468
  538730
  544219
  544952
  545972
  546456
  547008
  547885
  548392
  548467
  552510
  556446
  557525
  558172
  559832
  562458
  562561
  564032
  564371
  564753
  564760
  566652
  568017
  575634
  579221
  579867
  582321
  592988
  593271
  597162
  616635
  618682
  627156
  627696
  649476
  668782
  668829
  709894
  713422
  715535
  716309
  731010
  732987
  742688
  754994
  768081
  768893
  781918
  782358
  800981
  813738
  817069
  817206
  817542
  817551
  817560
  817574
  818955
  818957
  818984
  819869
  820055
  823273
  823651
  823846
  823999
  824479
  824520
  824886
  825270
  826438
  826890
  827225
]
2.17 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "обвисшая грудь веб-камера"
]
1.90 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "обвисшая сиськ вебкамер"
]
1.53 ms
(0.70%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.39 ms
(0.64%)
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.