Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
214.10 ms
(48.56%)
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
  7373
  7449
  109218
  191698
  233166
  274758
  323581
  383111
  384895
  386414
  389067
  394004
  398229
  408214
  411829
  411842
  429409
  439470
  440841
  442830
  451626
  483440
  484730
  500597
  502277
  502279
  515931
  521515
  524850
  524853
  524858
  524860
  524878
  530002
  532019
  536447
  544181
  546671
  547030
  549716
  553146
  553455
  567415
  578473
  581267
  584050
  584996
  592117
  593072
  603678
  609161
  629416
  633166
  634569
  634922
  638829
  641372
  649956
  652253
  660701
  668680
  669195
  669216
  673053
  675203
  676783
  676804
  693931
  700908
  707069
  707507
  712646
  716052
  719872
  721167
  724041
  729816
  735548
  738247
  741093
  741515
  742237
  743426
  749646
  752291
  756544
  758504
  761538
  765967
  766601
  768862
  770021
  775605
  776820
  776829
  779315
  780536
  783994
  787171
  787495
  788262
  790961
  793237
  794691
  794875
  796597
  797208
  802702
  803126
  805135
  805666
  807614
  808268
  811549
  818847
  820131
  823808
  824156
  828257
  828383
]
206.65 ms
(46.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf fuck"
]
11.66 ms
(2.64%)
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
  191698
  411829
  483440
  451626
  500597
  532019
  788262
  603678
  584050
  524858
  609161
  515931
  787171
  761538
  780536
  578473
  384895
  633166
  803126
  775605
  389067
  776820
  766601
  770021
  743426
  581267
  749646
  442830
  820131
  553146
  408214
  676804
  484730
  693931
  765967
  828383
  823808
  383111
  828257
  741093
  797208
  707507
  805135
  807614
  707069
  7373
  641372
  502279
  719872
  634922
  567415
  502277
  787495
  796597
  783994
  768862
  790961
  521515
  386414
  675203
  676783
  593072
  794875
  758504
  735548
  700908
  7449
  544181
  429409
  547030
  752291
  756544
  524853
  669216
  805666
  649956
  794691
  411842
  668680
  629416
  638829
  811549
  274758
  524850
  634569
  323581
  439470
  584996
  660701
  109218
  652253
  818847
  824156
  729816
  742237
  233166
  776829
  398229
  530002
  808268
  738247
  716052
  779315
  549716
  721167
  793237
  802702
  524878
  524860
  394004
  440841
  592117
  741515
  673053
  536447
  712646
  669195
  553455
  546671
  724041
]
3.75 ms
(0.85%)
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
  7373
  7449
  109218
  191698
  233166
  274758
  323581
  383111
  384895
  386414
  389067
  394004
  398229
  408214
  411829
  411842
  429409
  439470
  440841
  442830
  451626
  483440
  484730
  500597
  502277
  502279
  515931
  521515
  524850
  524853
  524858
  524860
  524878
  530002
  532019
  536447
  544181
  546671
  547030
  549716
  553146
  553455
  567415
  578473
  581267
  584050
  584996
  592117
  593072
  603678
  609161
  629416
  633166
  634569
  634922
  638829
  641372
  649956
  652253
  660701
  668680
  669195
  669216
  673053
  675203
  676783
  676804
  693931
  700908
  707069
  707507
  712646
  716052
  719872
  721167
  724041
  729816
  735548
  738247
  741093
  741515
  742237
  743426
  749646
  752291
  756544
  758504
  761538
  765967
  766601
  768862
  770021
  775605
  776820
  776829
  779315
  780536
  783994
  787171
  787495
  788262
  790961
  793237
  794691
  794875
  796597
  797208
  802702
  803126
  805135
  805666
  807614
  808268
  811549
  818847
  820131
  823808
  824156
  828257
  828383
]
1.92 ms
(0.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf секс"
]
1.44 ms
(0.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf секс"
]
1.41 ms
(0.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.