Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
179.76 ms
(88.72%)
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
  6840
  10077
  29242
  78637
  86926
  100449
  145053
  234736
  358857
  385129
  387529
  388241
  392977
  401794
  403139
  407449
  408334
  409405
  411249
  411435
  417137
  418250
  418935
  420233
  422817
  423888
  424762
  425248
  425884
  426273
  428574
  428877
  429489
  430941
  432391
  433751
  434007
  435566
  435598
  437568
  437778
  438293
  438460
  438551
  438984
  441255
  441507
  444265
  446419
  448774
  449252
  453168
  453604
  454030
  454360
  455713
  456266
  456575
  456989
  457917
  457949
  460901
  461302
  461641
  461916
  464896
  465157
  468285
  470990
  472797
  477538
  478329
  479398
  480273
  480651
  480970
  481828
  485573
  486665
  486848
  487748
  488952
  490632
  491344
  493733
  494081
  494216
  494613
  495516
  495553
  495644
  496582
  496670
  497642
  498243
  500070
  501989
  502830
  504021
  504202
  504518
  505958
  510097
  514450
  515528
  520496
  543187
  548380
  551290
  552226
  555629
  566214
  570033
  573431
  589358
  598145
  608771
  620267
  622067
  665308
]
13.32 ms
(6.57%)
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
  622067
  608771
  520496
  486665
  494081
  504518
  100449
  145053
  392977
  358857
  78637
  86926
  29242
  387529
  388241
  401794
  403139
  422817
  425884
  426273
  428574
  438551
  441255
  444265
  424762
  432391
  434007
  438293
  407449
  409405
  429489
  411435
  418935
  435598
  437778
  425248
  428877
  441507
  448774
  449252
  455713
  456989
  487748
  446419
  454030
  454360
  461302
  481828
  490632
  453168
  457949
  470990
  478329
  485573
  486848
  496582
  514450
  495516
  495644
  497642
  500070
  504021
  494216
  465157
  488952
  493733
  566214
  573431
  543187
  552226
  548380
  665308
  551290
  555629
  570033
  598145
  620267
  589358
  411249
  433751
  438460
  460901
  464896
  480651
  6840
  234736
  408334
  417137
  420233
  10077
  418250
  423888
  438984
  456575
  461641
  461916
  477538
  480970
  385129
  435566
  437568
  456266
  479398
  480273
  430941
  453604
  457917
  468285
  472797
  501989
  510097
  494613
  495553
  496670
  498243
  502830
  504202
  505958
  515528
  491344
]
2.76 ms
(1.36%)
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
  6840
  10077
  29242
  78637
  86926
  100449
  145053
  234736
  358857
  385129
  387529
  388241
  392977
  401794
  403139
  407449
  408334
  409405
  411249
  411435
  417137
  418250
  418935
  420233
  422817
  423888
  424762
  425248
  425884
  426273
  428574
  428877
  429489
  430941
  432391
  433751
  434007
  435566
  435598
  437568
  437778
  438293
  438460
  438551
  438984
  441255
  441507
  444265
  446419
  448774
  449252
  453168
  453604
  454030
  454360
  455713
  456266
  456575
  456989
  457917
  457949
  460901
  461302
  461641
  461916
  464896
  465157
  468285
  470990
  472797
  477538
  478329
  479398
  480273
  480651
  480970
  481828
  485573
  486665
  486848
  487748
  488952
  490632
  491344
  493733
  494081
  494216
  494613
  495516
  495553
  495644
  496582
  496670
  497642
  498243
  500070
  501989
  502830
  504021
  504202
  504518
  505958
  510097
  514450
  515528
  520496
  543187
  548380
  551290
  552226
  555629
  566214
  570033
  573431
  589358
  598145
  608771
  620267
  622067
  665308
]
1.93 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ног женскийрод"
]
1.67 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ноги баб"
]
1.63 ms
(0.80%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.76%)
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.