Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.87 ms
(79.92%)
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
  249637
  384306
  388789
  398140
  400850
  402247
  404289
  409106
  416385
  421823
  428643
  434241
  435064
  435436
  437876
  451587
  452112
  452277
  453615
  453781
  456423
  460176
  462935
  463151
  466134
  466921
  468827
  469914
  470262
  471593
  473729
  476916
  478332
  478548
  481727
  483035
  483174
  483991
  484718
  485524
  486390
  487228
  487469
  487547
  490018
  491040
  491839
  492261
  493460
  496228
  497085
  498827
  499695
  499951
  502106
  504333
  505202
  506141
  507010
  507349
  511039
  511076
  513123
  516674
  516848
  516969
  518189
  518334
  518499
  519047
  520686
  521315
  521993
  522767
  524147
  525841
  526010
  526888
  527792
  529204
  529483
  542094
  543756
  544396
  546853
  553247
  553678
  556990
  557951
  559238
  560466
  560766
  565905
  569583
  569886
  573145
  573538
  574534
  574819
  597674
  598658
  603067
  604545
  605589
  608751
  616613
  620038
  634213
  654562
  672713
  688991
  705739
  714776
  726432
  733138
  751643
  766849
  776864
  807323
  807907
]
19.72 ms
(12.52%)
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
  513123
  518189
  518499
  502106
  516674
  516969
  526010
  511039
  460176
  463151
  487469
  543756
  544396
  546853
  553678
  556990
  573145
  542094
  553247
  557951
  560466
  569886
  574819
  569583
  574534
  672713
  688991
  705739
  714776
  654562
  559238
  560766
  565905
  573538
  603067
  608751
  620038
  597674
  616613
  598658
  634213
  776864
  807323
  807907
  751643
  766849
  733138
  726432
  604545
  605589
  398140
  400850
  402247
  409106
  416385
  421823
  434241
  452112
  453781
  466921
  468827
  473729
  384306
  404289
  428643
  437876
  452277
  466134
  478332
  249637
  435064
  451587
  456423
  470262
  471593
  481727
  388789
  462935
  469914
  476916
  478548
  435436
  453615
  499951
  504333
  505202
  522767
  491040
  492261
  516848
  518334
  519047
  520686
  524147
  526888
  527792
  529483
  483035
  483991
  485524
  486390
  487228
  487547
  490018
  491839
  497085
  498827
  499695
  506141
  507010
  507349
  521315
  521993
  525841
  529204
  483174
  484718
  493460
  496228
  511076
]
4.51 ms
(2.86%)
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
  249637
  384306
  388789
  398140
  400850
  402247
  404289
  409106
  416385
  421823
  428643
  434241
  435064
  435436
  437876
  451587
  452112
  452277
  453615
  453781
  456423
  460176
  462935
  463151
  466134
  466921
  468827
  469914
  470262
  471593
  473729
  476916
  478332
  478548
  481727
  483035
  483174
  483991
  484718
  485524
  486390
  487228
  487469
  487547
  490018
  491040
  491839
  492261
  493460
  496228
  497085
  498827
  499695
  499951
  502106
  504333
  505202
  506141
  507010
  507349
  511039
  511076
  513123
  516674
  516848
  516969
  518189
  518334
  518499
  519047
  520686
  521315
  521993
  522767
  524147
  525841
  526010
  526888
  527792
  529204
  529483
  542094
  543756
  544396
  546853
  553247
  553678
  556990
  557951
  559238
  560466
  560766
  565905
  569583
  569886
  573145
  573538
  574534
  574819
  597674
  598658
  603067
  604545
  605589
  608751
  616613
  620038
  634213
  654562
  672713
  688991
  705739
  714776
  726432
  733138
  751643
  766849
  776864
  807323
  807907
]
2.25 ms
(1.43%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "все вместе"
]
1.80 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вмест"
]
1.52 ms
(0.97%)
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.