Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.98 ms
(83.74%)
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
  123610
  388426
  392563
  401216
  402146
  411361
  411393
  412367
  419545
  422275
  424259
  428049
  432766
  437960
  440827
  443712
  443814
  444926
  447962
  449693
  449757
  449877
  450312
  450811
  451476
  451485
  453028
  454200
  454208
  454310
  454706
  455058
  455993
  458842
  459406
  462708
  462720
  464129
  464163
  464351
  465333
  466129
  466319
  466836
  466941
  467026
  468034
  468804
  469405
  470771
  470964
  471162
  471611
  472595
  472618
  472933
  473237
  473960
  474004
  474034
  474154
  474160
  475885
  475888
  475977
  476691
  477597
  478510
  478935
  479044
  479091
  480304
  482786
  482872
  483590
  483600
  484455
  484689
  485952
  485961
  485977
  486446
  487052
  487763
  489138
  489462
  490307
  490913
  490945
  495246
  496370
  497828
  502001
  505465
  506334
  506656
  509540
  509918
  512069
  512346
  514853
  516221
  517565
  518500
  519137
  519753
  522978
  525025
  526737
  532138
  532893
  534334
  535456
  591997
  685682
  702430
  800773
  814781
  815255
  815789
]
18.93 ms
(10.36%)
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
  464351
  466319
  480304
  388426
  392563
  411393
  419545
  428049
  443712
  444926
  454310
  470964
  473237
  475885
  479044
  479091
  411361
  443814
  451485
  462708
  462720
  466129
  467026
  470771
  475888
  502001
  509918
  512069
  519137
  526737
  484689
  487763
  497828
  505465
  509540
  522978
  483590
  483600
  490307
  490913
  495246
  485952
  485961
  485977
  487052
  490945
  496370
  534334
  535456
  459406
  464163
  464129
  486446
  482786
  685682
  591997
  702430
  800773
  424259
  451476
  465333
  466836
  437960
  449877
  412367
  489138
  123610
  402146
  401216
  422275
  440827
  432766
  814781
  815789
  815255
  449757
  453028
  454200
  469405
  472595
  473960
  474004
  474154
  474160
  475977
  482872
  447962
  449693
  450312
  468804
  471162
  472618
  472933
  478935
  450811
  454208
  454706
  455058
  455993
  458842
  466941
  471611
  474034
  476691
  477597
  478510
  484455
  489462
  506656
  512346
  516221
  518500
  519753
  506334
  525025
  514853
  517565
  532138
  532893
  468034
]
3.78 ms
(2.07%)
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
  123610
  388426
  392563
  401216
  402146
  411361
  411393
  412367
  419545
  422275
  424259
  428049
  432766
  437960
  440827
  443712
  443814
  444926
  447962
  449693
  449757
  449877
  450312
  450811
  451476
  451485
  453028
  454200
  454208
  454310
  454706
  455058
  455993
  458842
  459406
  462708
  462720
  464129
  464163
  464351
  465333
  466129
  466319
  466836
  466941
  467026
  468034
  468804
  469405
  470771
  470964
  471162
  471611
  472595
  472618
  472933
  473237
  473960
  474004
  474034
  474154
  474160
  475885
  475888
  475977
  476691
  477597
  478510
  478935
  479044
  479091
  480304
  482786
  482872
  483590
  483600
  484455
  484689
  485952
  485961
  485977
  486446
  487052
  487763
  489138
  489462
  490307
  490913
  490945
  495246
  496370
  497828
  502001
  505465
  506334
  506656
  509540
  509918
  512069
  512346
  514853
  516221
  517565
  518500
  519137
  519753
  522978
  525025
  526737
  532138
  532893
  534334
  535456
  591997
  685682
  702430
  800773
  814781
  815255
  815789
]
2.17 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "short milf pussy"
]
1.86 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "short milf pussy"
]
1.48 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "short milf pussy"
]

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.