Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.78 ms
(81.96%)
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
  13954
  108018
  168977
  177739
  348918
  383523
  387380
  390292
  394931
  395848
  396110
  396575
  398204
  402931
  403833
  410956
  413748
  416967
  417246
  420340
  421807
  424795
  426432
  428492
  430815
  432338
  434587
  434992
  436869
  447308
  448903
  449516
  451799
  452654
  453418
  454863
  455633
  457908
  458466
  458742
  459350
  459449
  459578
  460641
  462836
  462883
  463031
  464461
  465616
  466526
  466708
  467806
  471311
  472080
  473804
  475444
  478145
  478336
  478788
  479296
  482014
  483906
  484053
  484054
  485479
  486620
  486668
  487028
  492751
  493937
  497545
  497551
  498724
  498753
  507152
  507194
  510985
  511209
  511984
  522665
  525900
  526697
  551366
  551844
  551973
  552070
  552402
  552483
  552633
  552696
  553452
  554128
  554187
  558375
  558520
  561330
  565177
  566751
  567193
  569854
  569878
  570207
  570528
  570656
  571539
  571893
  571917
  572116
  572621
  573667
  578375
  580735
  583320
  583426
  587338
  590334
  594215
  654836
  672706
  806883
]
16.33 ms
(10.73%)
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
  177739
  13954
  396575
  398204
  434587
  413748
  410956
  484054
  525900
  552070
  558375
  569878
  571917
  573667
  553452
  565177
  569854
  570207
  570528
  570656
  583320
  552696
  554187
  571539
  571893
  578375
  672706
  654836
  552633
  572116
  572621
  580735
  594215
  590334
  448903
  416967
  421807
  428492
  432338
  479296
  108018
  454863
  434992
  467806
  507152
  497545
  383523
  168977
  394931
  387380
  390292
  396110
  403833
  424795
  426432
  436869
  417246
  420340
  451799
  452654
  458466
  459449
  463031
  466708
  478145
  486668
  487028
  449516
  453418
  455633
  457908
  466526
  472080
  482014
  483906
  484053
  486620
  459350
  460641
  471311
  485479
  492751
  498753
  511209
  511984
  522665
  526697
  510985
  498724
  507194
  497551
  462883
  464461
  465616
  473804
  478336
  478788
  493937
  551366
  551973
  552402
  561330
  554128
  583426
  558520
  567193
  551844
  552483
  566751
  587338
  806883
  348918
  395848
  402931
  430815
  447308
  458742
  459578
  462836
  475444
]
3.58 ms
(2.35%)
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
  13954
  108018
  168977
  177739
  348918
  383523
  387380
  390292
  394931
  395848
  396110
  396575
  398204
  402931
  403833
  410956
  413748
  416967
  417246
  420340
  421807
  424795
  426432
  428492
  430815
  432338
  434587
  434992
  436869
  447308
  448903
  449516
  451799
  452654
  453418
  454863
  455633
  457908
  458466
  458742
  459350
  459449
  459578
  460641
  462836
  462883
  463031
  464461
  465616
  466526
  466708
  467806
  471311
  472080
  473804
  475444
  478145
  478336
  478788
  479296
  482014
  483906
  484053
  484054
  485479
  486620
  486668
  487028
  492751
  493937
  497545
  497551
  498724
  498753
  507152
  507194
  510985
  511209
  511984
  522665
  525900
  526697
  551366
  551844
  551973
  552070
  552402
  552483
  552633
  552696
  553452
  554128
  554187
  558375
  558520
  561330
  565177
  566751
  567193
  569854
  569878
  570207
  570528
  570656
  571539
  571893
  571917
  572116
  572621
  573667
  578375
  580735
  583320
  583426
  587338
  590334
  594215
  654836
  672706
  806883
]
2.05 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "с членом девка"
]
1.91 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "член девк"
]
1.91 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "член девк"
]
1.68 ms
(1.10%)
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.