Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.79 ms
(82.19%)
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
  3727
  108764
  230821
  385224
  385581
  388341
  388935
  390954
  391045
  391875
  396067
  396390
  397406
  397658
  402030
  402972
  403778
  405966
  411377
  412827
  415809
  423445
  426720
  426721
  436860
  438562
  441917
  442497
  442897
  444894
  447071
  448936
  449258
  451309
  451525
  455203
  456010
  456265
  456742
  457540
  459593
  460254
  460489
  460539
  460561
  460686
  461124
  461241
  461313
  461397
  461818
  462151
  465146
  466778
  467133
  469214
  472393
  472771
  474267
  478529
  480115
  481319
  482129
  483900
  484992
  485425
  485512
  494003
  494543
  497374
  499100
  499418
  502574
  502916
  503470
  503535
  504345
  505248
  505866
  506339
  507102
  507429
  511257
  511516
  517317
  517604
  520216
  522954
  525848
  527297
  529604
  544246
  547702
  549174
  566303
  571953
  572621
  584226
  585278
  589642
  591167
  602080
  614935
  626124
  629770
  651037
  672891
  674284
  696330
  720176
  733220
  742693
  742697
  742757
  744234
  758923
  765804
  773982
  783464
  813055
]
19.29 ms
(11.67%)
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
  388935
  391045
  397658
  403778
  423445
  461241
  460254
  502916
  672891
  674284
  572621
  602080
  402972
  385224
  436860
  461818
  497374
  505248
  527297
  456742
  499100
  411377
  614935
  483900
  591167
  506339
  385581
  444894
  547702
  451525
  522954
  485425
  415809
  456010
  525848
  696330
  405966
  460686
  517604
  474267
  480115
  742757
  466778
  391875
  457540
  472771
  456265
  459593
  402030
  589642
  651037
  744234
  813055
  412827
  505866
  511257
  494003
  549174
  733220
  108764
  230821
  438562
  441917
  442497
  449258
  451309
  465146
  494543
  783464
  758923
  742693
  742697
  467133
  390954
  461313
  517317
  396067
  397406
  461397
  765804
  481319
  460561
  507429
  507102
  544246
  566303
  502574
  584226
  626124
  629770
  720176
  460489
  529604
  511516
  520216
  484992
  426720
  426721
  455203
  460539
  469214
  461124
  571953
  585278
  773982
  448936
  442897
  447071
  462151
  472393
  478529
  482129
  503470
  503535
  504345
  499418
  485512
  3727
  388341
  396390
]
3.31 ms
(2.00%)
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
  3727
  108764
  230821
  385224
  385581
  388341
  388935
  390954
  391045
  391875
  396067
  396390
  397406
  397658
  402030
  402972
  403778
  405966
  411377
  412827
  415809
  423445
  426720
  426721
  436860
  438562
  441917
  442497
  442897
  444894
  447071
  448936
  449258
  451309
  451525
  455203
  456010
  456265
  456742
  457540
  459593
  460254
  460489
  460539
  460561
  460686
  461124
  461241
  461313
  461397
  461818
  462151
  465146
  466778
  467133
  469214
  472393
  472771
  474267
  478529
  480115
  481319
  482129
  483900
  484992
  485425
  485512
  494003
  494543
  497374
  499100
  499418
  502574
  502916
  503470
  503535
  504345
  505248
  505866
  506339
  507102
  507429
  511257
  511516
  517317
  517604
  520216
  522954
  525848
  527297
  529604
  544246
  547702
  549174
  566303
  571953
  572621
  584226
  585278
  589642
  591167
  602080
  614935
  626124
  629770
  651037
  672891
  674284
  696330
  720176
  733220
  742693
  742697
  742757
  744234
  758923
  765804
  773982
  783464
  813055
]
2.15 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"муж трахает любовникÐ%…"
]
2.02 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.41 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен секс любовник"
]
1.24 ms
(0.75%)
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.