Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.57 ms
(81.05%)
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
  385322
  390217
  400844
  403650
  415855
  419861
  436639
  437859
  440955
  442288
  442424
  443231
  443379
  443727
  445868
  446778
  448440
  450894
  452114
  452171
  453403
  453826
  454585
  456074
  461122
  461137
  462292
  464802
  469244
  472486
  473912
  475630
  489980
  494917
  496554
  500597
  501603
  503840
  505398
  511047
  511231
  513808
  513874
  515763
  516309
  516773
  517079
  517665
  518552
  518858
  519095
  521446
  523805
  524533
  526919
  527718
  529170
  529355
  531156
  532349
  537224
  543191
  546001
  550398
  553414
  554778
  557298
  558335
  560608
  560925
  561526
  563440
  564207
  564715
  566566
  569837
  571054
  572972
  575371
  577888
  580223
  580518
  581761
  584991
  585398
  585912
  588144
  590771
  590966
  594105
  596887
  598524
  598649
  598953
  599339
  599440
  599962
  600719
  601023
  601616
  602594
  603431
  603906
  605936
  611006
  611484
  619097
  621091
  625864
  632578
  633498
  636181
  637460
  640280
  650028
  661496
  663523
  664435
  684666
  716203
]
20.39 ms
(12.46%)
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
  436639
  580518
  445868
  453826
  596887
  440955
  400844
  464802
  403650
  443231
  511047
  572972
  581761
  564715
  571054
  564207
  590771
  390217
  513808
  625864
  632578
  524533
  663523
  557298
  500597
  543191
  600719
  419861
  518858
  516773
  442288
  537224
  461122
  462292
  443379
  453403
  513874
  450894
  442424
  446778
  469244
  684666
  605936
  599339
  443727
  518552
  529170
  517079
  599440
  550398
  585398
  611484
  437859
  577888
  516309
  560608
  546001
  585912
  598953
  454585
  489980
  415855
  452171
  621091
  448440
  519095
  531156
  650028
  640280
  517665
  558335
  603431
  532349
  599962
  601616
  598524
  661496
  501603
  523805
  515763
  580223
  456074
  561526
  563440
  529355
  584991
  527718
  588144
  602594
  496554
  633498
  452114
  505398
  637460
  594105
  619097
  664435
  475630
  473912
  472486
  566566
  521446
  511231
  598649
  569837
  590966
  554778
  560925
  636181
  603906
  461137
  503840
  494917
  553414
  611006
  716203
  601023
  575371
  526919
  385322
]
2.94 ms
(1.80%)
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
  385322
  390217
  400844
  403650
  415855
  419861
  436639
  437859
  440955
  442288
  442424
  443231
  443379
  443727
  445868
  446778
  448440
  450894
  452114
  452171
  453403
  453826
  454585
  456074
  461122
  461137
  462292
  464802
  469244
  472486
  473912
  475630
  489980
  494917
  496554
  500597
  501603
  503840
  505398
  511047
  511231
  513808
  513874
  515763
  516309
  516773
  517079
  517665
  518552
  518858
  519095
  521446
  523805
  524533
  526919
  527718
  529170
  529355
  531156
  532349
  537224
  543191
  546001
  550398
  553414
  554778
  557298
  558335
  560608
  560925
  561526
  563440
  564207
  564715
  566566
  569837
  571054
  572972
  575371
  577888
  580223
  580518
  581761
  584991
  585398
  585912
  588144
  590771
  590966
  594105
  596887
  598524
  598649
  598953
  599339
  599440
  599962
  600719
  601023
  601616
  602594
  603431
  603906
  605936
  611006
  611484
  619097
  621091
  625864
  632578
  633498
  636181
  637460
  640280
  650028
  661496
  663523
  664435
  684666
  716203
]
2.15 ms
(1.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.10 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass panties"
]
1.75 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп трусик нижн бел"
]
1.67 ms
(1.02%)
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.