Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.57 ms
(84.85%)
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
  386761
  389499
  420474
  430161
  434072
  434277
  442619
  442648
  443668
  449611
  449622
  449662
  450824
  457191
  461402
  464404
  469180
  472696
  474778
  481068
  482739
  490740
  490813
  497372
  498477
  500690
  502211
  506301
  515408
  516486
  517695
  519266
  519570
  522626
  524472
  524473
  527249
  529970
  530251
  532580
  537322
  542569
  545856
  547297
  554357
  556641
  556789
  557054
  557557
  558197
  563263
  566826
  572543
  572568
  579425
  580355
  583848
  584249
  584693
  586828
  586919
  589646
  590254
  592015
  592685
  592838
  600854
  601169
  604704
  604927
  605119
  605149
  610615
  611305
  612079
  629866
  629903
  630178
  630281
  634481
  636540
  648963
  649939
  652540
  656206
  656266
  665651
  668406
  679471
  687584
  694179
  707361
  709240
  726439
  728440
  729570
  730504
  731626
  741219
  743752
  747249
  751590
  755173
  756658
  760166
  760659
  760681
  760687
  761411
  765379
  786454
  788576
  789016
  789760
  802114
  804943
  805259
  807711
  807716
  808659
]
16.50 ms
(9.18%)
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
  547297
  630281
  630178
  729570
  760166
  743752
  434277
  464404
  589646
  751590
  449611
  558197
  788576
  389499
  482739
  506301
  519570
  537322
  502211
  461402
  580355
  584249
  584693
  545856
  679471
  649939
  652540
  592838
  601169
  604704
  611305
  592015
  612079
  610615
  731626
  755173
  808659
  741219
  726439
  756658
  760687
  747249
  760659
  760681
  765379
  709240
  472696
  457191
  442648
  500690
  490813
  443668
  524472
  490740
  542569
  572568
  648963
  761411
  730504
  449662
  515408
  517695
  420474
  498477
  563263
  557054
  668406
  687584
  707361
  583848
  586828
  629903
  634481
  605119
  605149
  789016
  804943
  497372
  519266
  532580
  579425
  566826
  590254
  629866
  604927
  481068
  527249
  556641
  665651
  600854
  469180
  386761
  434072
  524473
  789760
  522626
  516486
  449622
  450824
  430161
  442619
  474778
  529970
  530251
  556789
  557557
  694179
  656206
  656266
  554357
  572543
  592685
  586919
  807711
  807716
  786454
  805259
  728440
  636540
  802114
]
3.30 ms
(1.83%)
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
  386761
  389499
  420474
  430161
  434072
  434277
  442619
  442648
  443668
  449611
  449622
  449662
  450824
  457191
  461402
  464404
  469180
  472696
  474778
  481068
  482739
  490740
  490813
  497372
  498477
  500690
  502211
  506301
  515408
  516486
  517695
  519266
  519570
  522626
  524472
  524473
  527249
  529970
  530251
  532580
  537322
  542569
  545856
  547297
  554357
  556641
  556789
  557054
  557557
  558197
  563263
  566826
  572543
  572568
  579425
  580355
  583848
  584249
  584693
  586828
  586919
  589646
  590254
  592015
  592685
  592838
  600854
  601169
  604704
  604927
  605119
  605149
  610615
  611305
  612079
  629866
  629903
  630178
  630281
  634481
  636540
  648963
  649939
  652540
  656206
  656266
  665651
  668406
  679471
  687584
  694179
  707361
  709240
  726439
  728440
  729570
  730504
  731626
  741219
  743752
  747249
  751590
  755173
  756658
  760166
  760659
  760681
  760687
  761411
  765379
  786454
  788576
  789016
  789760
  802114
  804943
  805259
  807711
  807716
  808659
]
2.17 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf mom compilation"
]
1.83 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf mom подборк"
]
1.77 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf mom подборк"
]
1.68 ms
(0.93%)
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.