Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.15 ms
(83.66%)
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
  3973
  190903
  385913
  386202
  389611
  393741
  400439
  400453
  411959
  412083
  413114
  418495
  418998
  429086
  430081
  444636
  444834
  445037
  445058
  446886
  461961
  464275
  464288
  465099
  466154
  467330
  470561
  472235
  476955
  482794
  492002
  504456
  505622
  511018
  512869
  515116
  515128
  515175
  515177
  515193
  515194
  515195
  515717
  520717
  520723
  520774
  521772
  521779
  523008
  523822
  526135
  529125
  541332
  546692
  550439
  550443
  550609
  557274
  557304
  559044
  561321
  565537
  566981
  567146
  567166
  571383
  599548
  607173
  608042
  609647
  613465
  615433
  615444
  617722
  623350
  624858
  631957
  632298
  644697
  646826
  650432
  651165
  663910
  664302
  665238
  667472
  684582
  696972
  700544
  700659
  709578
  712804
  712923
  716482
  722706
  722913
  722916
  726144
  727698
  732116
  732120
  732422
  732466
  733172
  734679
  735800
  741646
  743120
  743134
  744319
  748145
  759658
  759660
  766016
  775972
  778614
  781839
  788647
  814122
  825184
]
17.15 ms
(10.70%)
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
  664302
  663910
  400439
  476955
  3973
  716482
  559044
  727698
  735800
  393741
  700659
  523822
  766016
  775972
  561321
  515717
  734679
  411959
  418998
  446886
  565537
  722706
  743120
  733172
  744319
  644697
  413114
  400453
  732116
  665238
  541332
  632298
  550439
  429086
  482794
  515195
  523008
  418495
  466154
  515116
  631957
  567166
  550609
  430081
  190903
  515128
  567146
  557274
  470561
  521772
  512869
  748145
  712923
  700544
  445058
  743134
  520717
  571383
  550443
  617722
  608042
  520723
  781839
  412083
  444636
  521779
  461961
  520774
  385913
  613465
  788647
  504456
  623350
  599548
  515177
  511018
  778614
  759658
  526135
  712804
  667472
  609647
  444834
  472235
  515194
  684582
  732422
  465099
  467330
  515175
  529125
  464288
  624858
  722916
  445037
  646826
  615444
  505622
  759660
  386202
  709578
  651165
  650432
  615433
  732466
  741646
  726144
  732120
  515193
  464275
  492002
  557304
  722913
  607173
  546692
  566981
  696972
  389611
  825184
  814122
]
2.49 ms
(1.55%)
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
  3973
  190903
  385913
  386202
  389611
  393741
  400439
  400453
  411959
  412083
  413114
  418495
  418998
  429086
  430081
  444636
  444834
  445037
  445058
  446886
  461961
  464275
  464288
  465099
  466154
  467330
  470561
  472235
  476955
  482794
  492002
  504456
  505622
  511018
  512869
  515116
  515128
  515175
  515177
  515193
  515194
  515195
  515717
  520717
  520723
  520774
  521772
  521779
  523008
  523822
  526135
  529125
  541332
  546692
  550439
  550443
  550609
  557274
  557304
  559044
  561321
  565537
  566981
  567146
  567166
  571383
  599548
  607173
  608042
  609647
  613465
  615433
  615444
  617722
  623350
  624858
  631957
  632298
  644697
  646826
  650432
  651165
  663910
  664302
  665238
  667472
  684582
  696972
  700544
  700659
  709578
  712804
  712923
  716482
  722706
  722913
  722916
  726144
  727698
  732116
  732120
  732422
  732466
  733172
  734679
  735800
  741646
  743120
  743134
  744319
  748145
  759658
  759660
  766016
  775972
  778614
  781839
  788647
  814122
  825184
]
1.71 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big tits grandfather"
]
1.62 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие сиськ старый"
]
1.54 ms
(0.96%)
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.