Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.08 ms
(87.13%)
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
  221091
  305328
  306045
  338098
  388193
  398552
  398753
  403979
  413643
  417844
  464373
  470548
  484145
  500617
  503791
  504161
  506813
  517448
  518499
  520162
  520393
  520758
  535585
  536211
  538043
  543685
  543688
  543943
  543982
  544696
  544751
  545080
  545106
  553241
  562588
  566431
  566445
  566464
  568180
  579304
  579541
  586737
  587216
  593885
  599533
  603608
  605029
  605616
  606064
  608645
  610780
  610816
  614565
  620432
  630712
  631329
  635787
  635842
  635871
  642525
  644421
  650797
  651262
  653593
  653615
  653634
  654268
  654276
  654292
  675934
  675960
  680588
  681785
  682914
  690000
  692454
  698086
  711013
  715581
  718964
  720965
  721933
  723967
  728946
  731358
  732690
  732704
  732743
  732850
  733045
  733076
  733148
  736778
  742663
  742684
  747234
  748741
  755011
  767861
  773948
  773961
  775969
  776528
  780688
  781638
  782036
  784323
  784875
  788596
  790971
  799553
  799674
  801533
  804512
  809533
  810286
  813050
  823928
  825998
  826217
]
13.58 ms
(7.12%)
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
  782036
  784323
  398753
  654292
  653615
  788596
  736778
  733076
  654276
  566445
  732704
  711013
  388193
  823928
  748741
  675934
  520393
  620432
  603608
  500617
  518499
  517448
  610816
  776528
  545080
  801533
  809533
  536211
  690000
  813050
  651262
  605029
  543943
  630712
  305328
  653593
  593885
  635787
  733045
  732850
  767861
  731358
  484145
  398552
  644421
  720965
  755011
  599533
  464373
  520758
  631329
  742684
  413643
  417844
  732690
  579541
  825998
  635871
  543982
  804512
  721933
  723967
  587216
  221091
  799674
  682914
  799553
  775969
  586737
  742663
  503791
  306045
  698086
  773948
  680588
  773961
  579304
  608645
  732743
  747234
  535585
  544751
  568180
  553241
  606064
  715581
  470548
  650797
  544696
  543688
  718964
  545106
  338098
  614565
  543685
  728946
  504161
  826217
  654268
  780688
  520162
  566431
  566464
  681785
  675960
  642525
  810286
  733148
  403979
  506813
  784875
  781638
  790971
  610780
  538043
  692454
  635842
  605616
  562588
  653634
]
3.32 ms
(1.74%)
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
  221091
  305328
  306045
  338098
  388193
  398552
  398753
  403979
  413643
  417844
  464373
  470548
  484145
  500617
  503791
  504161
  506813
  517448
  518499
  520162
  520393
  520758
  535585
  536211
  538043
  543685
  543688
  543943
  543982
  544696
  544751
  545080
  545106
  553241
  562588
  566431
  566445
  566464
  568180
  579304
  579541
  586737
  587216
  593885
  599533
  603608
  605029
  605616
  606064
  608645
  610780
  610816
  614565
  620432
  630712
  631329
  635787
  635842
  635871
  642525
  644421
  650797
  651262
  653593
  653615
  653634
  654268
  654276
  654292
  675934
  675960
  680588
  681785
  682914
  690000
  692454
  698086
  711013
  715581
  718964
  720965
  721933
  723967
  728946
  731358
  732690
  732704
  732743
  732850
  733045
  733076
  733148
  736778
  742663
  742684
  747234
  748741
  755011
  767861
  773948
  773961
  775969
  776528
  780688
  781638
  782036
  784323
  784875
  788596
  790971
  799553
  799674
  801533
  804512
  809533
  810286
  813050
  823928
  825998
  826217
]
2.18 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex wife threesome"
]
1.99 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс жен секс втро"
]
1.75 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс жен секс втро"
]
1.73 ms
(0.91%)
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.