Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.02 ms
(81.30%)
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
  382313
  400128
  406303
  413722
  425603
  445542
  447072
  448033
  451950
  454530
  456525
  457781
  462331
  463262
  470146
  475207
  480900
  493046
  499765
  500875
  502518
  503350
  503772
  504042
  507946
  508386
  508421
  508510
  510194
  512629
  512844
  514373
  514989
  516325
  516650
  517269
  517824
  518077
  518100
  519040
  520828
  520877
  521041
  521492
  521605
  521653
  522724
  523813
  524096
  525022
  536004
  536372
  537340
  537962
  546668
  546824
  548991
  549143
  550485
  554260
  554262
  556706
  557679
  559934
  559936
  559938
  562080
  564842
  565526
  565838
  567643
  569332
  572291
  575607
  576966
  577500
  577897
  578552
  579728
  579780
  579812
  580880
  582889
  582897
  584641
  586864
  586912
  587946
  589723
  594261
  595579
  595593
  596405
  597690
  598154
  601884
  602510
  602666
  605164
  606344
  606987
  610401
  618852
  619885
  620180
  625807
  630135
  632818
  636428
  643489
  646669
  652673
  653461
  654739
  657199
  663172
  668079
  680705
  682945
  690153
]
17.69 ms
(11.79%)
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
  517824
  521041
  521605
  584641
  463262
  512629
  537340
  516650
  537962
  500875
  508421
  518077
  582889
  548991
  657199
  579780
  643489
  586912
  589723
  619885
  425603
  475207
  400128
  493046
  579812
  550485
  562080
  572291
  577500
  582897
  653461
  680705
  682945
  668079
  554260
  610401
  636428
  594261
  597690
  605164
  618852
  620180
  595579
  601884
  602510
  625807
  470146
  519040
  521492
  577897
  549143
  556706
  575607
  554262
  595593
  447072
  413722
  536004
  499765
  524096
  518100
  525022
  586864
  630135
  503350
  480900
  512844
  514373
  567643
  606987
  382313
  445542
  514989
  690153
  456525
  520877
  536372
  580880
  546824
  579728
  578552
  663172
  646669
  546668
  606344
  632818
  521653
  522724
  507946
  564842
  654739
  569332
  596405
  602666
  451950
  457781
  504042
  508510
  652673
  587946
  462331
  448033
  508386
  517269
  565526
  523813
  516325
  557679
  565838
  559936
  559938
  559934
  576966
  502518
  406303
  598154
  454530
  503772
  520828
  510194
]
3.50 ms
(2.33%)
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
  382313
  400128
  406303
  413722
  425603
  445542
  447072
  448033
  451950
  454530
  456525
  457781
  462331
  463262
  470146
  475207
  480900
  493046
  499765
  500875
  502518
  503350
  503772
  504042
  507946
  508386
  508421
  508510
  510194
  512629
  512844
  514373
  514989
  516325
  516650
  517269
  517824
  518077
  518100
  519040
  520828
  520877
  521041
  521492
  521605
  521653
  522724
  523813
  524096
  525022
  536004
  536372
  537340
  537962
  546668
  546824
  548991
  549143
  550485
  554260
  554262
  556706
  557679
  559934
  559936
  559938
  562080
  564842
  565526
  565838
  567643
  569332
  572291
  575607
  576966
  577500
  577897
  578552
  579728
  579780
  579812
  580880
  582889
  582897
  584641
  586864
  586912
  587946
  589723
  594261
  595579
  595593
  596405
  597690
  598154
  601884
  602510
  602666
  605164
  606344
  606987
  610401
  618852
  619885
  620180
  625807
  630135
  632818
  636428
  643489
  646669
  652673
  653461
  654739
  657199
  663172
  668079
  680705
  682945
  690153
]
2.04 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "показывает член подружке"
]
1.67 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "показыва член подружк"
]
1.54 ms
(1.03%)
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.