Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.62 ms
(85.02%)
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
  263812
  391247
  391943
  395701
  399591
  402247
  407458
  407571
  408138
  409001
  409035
  409682
  412288
  415547
  415693
  416864
  418877
  425961
  426382
  430701
  433189
  447352
  447947
  452242
  452838
  453826
  457103
  458715
  460079
  462472
  463768
  464397
  470987
  476577
  478802
  486400
  486869
  489397
  489979
  497899
  498809
  504178
  509103
  516991
  518507
  519911
  520682
  522498
  522825
  523152
  523511
  527425
  528181
  530777
  532351
  536657
  541838
  543579
  543777
  543849
  543881
  545718
  549976
  557195
  558413
  562004
  562894
  565153
  570899
  571428
  572006
  584453
  584635
  585637
  586555
  587162
  587172
  591119
  592478
  596330
  597787
  599160
  601147
  603364
  604551
  604933
  607236
  609221
  613177
  619399
  623264
  626564
  628641
  634134
  641436
  642742
  665672
  674983
  675010
  678117
  680484
  696947
  724275
  771924
  801471
  806228
  808077
  810839
  811506
  814901
]
16.68 ms
(9.17%)
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
  562004
  572006
  584453
  587172
  642742
  587162
  607236
  628641
  641436
  626564
  806228
  810839
  724275
  771924
  402247
  407458
  418877
  426382
  447352
  504178
  518507
  523511
  498809
  489397
  592478
  619399
  696947
  801471
  409682
  391943
  409035
  408138
  523152
  464397
  528181
  415547
  415693
  425961
  476577
  447947
  452838
  453826
  460079
  532351
  520682
  570899
  545718
  584635
  596330
  585637
  609221
  811506
  604551
  808077
  462472
  470987
  391247
  430701
  522498
  543881
  486400
  412288
  543849
  395701
  416864
  458715
  509103
  497899
  541838
  557195
  665672
  586555
  263812
  486869
  562894
  558413
  565153
  599160
  591119
  522825
  399591
  489979
  516991
  536657
  543777
  549976
  680484
  601147
  597787
  407571
  433189
  478802
  409001
  814901
  527425
  519911
  678117
  604933
  613177
  452242
  463768
  674983
  623264
  571428
  543579
  675010
  634134
  603364
  457103
  530777
]
2.63 ms
(1.45%)
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
  263812
  391247
  391943
  395701
  399591
  402247
  407458
  407571
  408138
  409001
  409035
  409682
  412288
  415547
  415693
  416864
  418877
  425961
  426382
  430701
  433189
  447352
  447947
  452242
  452838
  453826
  457103
  458715
  460079
  462472
  463768
  464397
  470987
  476577
  478802
  486400
  486869
  489397
  489979
  497899
  498809
  504178
  509103
  516991
  518507
  519911
  520682
  522498
  522825
  523152
  523511
  527425
  528181
  530777
  532351
  536657
  541838
  543579
  543777
  543849
  543881
  545718
  549976
  557195
  558413
  562004
  562894
  565153
  570899
  571428
  572006
  584453
  584635
  585637
  586555
  587162
  587172
  591119
  592478
  596330
  597787
  599160
  601147
  603364
  604551
  604933
  607236
  609221
  613177
  619399
  623264
  626564
  628641
  634134
  641436
  642742
  665672
  674983
  675010
  678117
  680484
  696947
  724275
  771924
  801471
  806228
  808077
  810839
  811506
  814901
]
2.42 ms
(1.33%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "busty milf черноволосая"
]
2.09 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "busty milf brunette"
]
1.76 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "busty milf черноволосая"
]
1.65 ms
(0.91%)
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.