Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.19 ms
(82.60%)
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
  402756
  420001
  428044
  434839
  441996
  447508
  453647
  464527
  467817
  467999
  470141
  470161
  470957
  474213
  475861
  479068
  482923
  491143
  495514
  495515
  501003
  501063
  506718
  508987
  510778
  514788
  524176
  527847
  533125
  533815
  547253
  550467
  551587
  567403
  596670
  601560
  612973
  624649
  639921
  650104
  657803
  659172
  669851
  676442
  682883
  683314
  697549
  701661
  703956
  715849
  717282
  718400
  720311
  728217
  731222
  732147
  736258
  736413
  738293
  738307
  740080
  741049
  742773
  744334
  746291
  746699
  748453
  754185
  754615
  768560
  769057
  778035
  778982
  779598
  779619
  779936
  780802
  781181
  783086
  783157
  784240
  786736
  787842
  788449
  789160
  789460
  789461
  789472
  790186
  790352
  790360
  791214
  791799
  792766
  793358
  793374
  793935
  795663
  798321
  798993
  807165
  809360
  811137
  813006
  817056
  818268
  819259
  820196
  825176
  825208
  825278
  826308
  826478
  826483
  826484
  826585
  826586
  826692
  828560
]
14.98 ms
(9.96%)
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
  813006
  567403
  467999
  482923
  650104
  514788
  524176
  510778
  527847
  506718
  464527
  470957
  501003
  533125
  596670
  441996
  474213
  501063
  508987
  475861
  453647
  470141
  826483
  826692
  819259
  826308
  495515
  533815
  495514
  551587
  550467
  669851
  683314
  717282
  720311
  657803
  659172
  676442
  682883
  697549
  715849
  547253
  631955
  612973
  639921
  781181
  783086
  784240
  793358
  795663
  798321
  798993
  811137
  778982
  783157
  786736
  788449
  789160
  791214
  731222
  732147
  740080
  746291
  754615
  769057
  791799
  793374
  736258
  728217
  736413
  738293
  738307
  741049
  742773
  744334
  746699
  768560
  624649
  701661
  703956
  778035
  779598
  779619
  780802
  787842
  790186
  792766
  807165
  809360
  479068
  402756
  447508
  467817
  491143
  820196
  420001
  470161
  826478
  826484
  826586
  817056
  818268
  825176
  825208
  825278
  826585
  828560
  718400
  779936
  789460
  790360
  789461
  789472
  790352
  754185
  748453
  793935
  434839
  428044
  601560
]
3.34 ms
(2.22%)
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
  402756
  420001
  428044
  434839
  441996
  447508
  453647
  464527
  467817
  467999
  470141
  470161
  470957
  474213
  475861
  479068
  482923
  491143
  495514
  495515
  501003
  501063
  506718
  508987
  510778
  514788
  524176
  527847
  533125
  533815
  547253
  550467
  551587
  567403
  596670
  601560
  612973
  624649
  639921
  650104
  657803
  659172
  669851
  676442
  682883
  683314
  697549
  701661
  703956
  715849
  717282
  718400
  720311
  728217
  731222
  732147
  736258
  736413
  738293
  738307
  740080
  741049
  742773
  744334
  746291
  746699
  748453
  754185
  754615
  768560
  769057
  778035
  778982
  779598
  779619
  779936
  780802
  781181
  783086
  783157
  784240
  786736
  787842
  788449
  789160
  789460
  789461
  789472
  790186
  790352
  790360
  791214
  791799
  792766
  793358
  793374
  793935
  795663
  798321
  798993
  807165
  809360
  811137
  813006
  817056
  818268
  819259
  820196
  825176
  825208
  825278
  826308
  826478
  826483
  826484
  826585
  826586
  826692
  828560
]
2.27 ms
(1.51%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.08 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian blowjob webcam"
]
1.77 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск минет оральн секс вебкамер"
]
1.71 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.