Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
168.75 ms
(86.36%)
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
  16998
  17037
  126458
  232978
  233443
  233676
  387352
  388546
  389587
  391310
  391561
  392554
  396182
  397852
  397856
  400957
  406074
  406657
  410036
  428758
  429960
  443884
  443902
  444197
  448349
  454840
  457149
  458470
  458744
  461973
  465123
  466187
  468089
  470320
  473990
  473992
  475231
  475918
  478895
  479418
  480831
  482484
  486044
  488030
  491155
  500777
  503975
  504639
  505021
  511689
  521089
  533763
  535618
  555787
  572322
  576145
  578825
  580298
  594577
  595423
  596616
  597041
  597052
  597560
  597801
  598022
  598041
  598172
  598443
  599859
  600112
  602739
  603878
  604016
  605791
  617275
  621203
  623206
  650056
  654399
  654840
  655625
  656545
  659793
  663247
  671250
  673661
  683303
  688927
  695093
  715300
  717725
  720641
  725167
  736824
  736845
  736852
  736856
  736869
  740710
  742160
  742234
  742473
  742916
  743025
  743051
  745352
  745363
  757846
  760466
  762273
  774642
  774653
  778380
  779832
  782131
  782184
  799909
  802893
  803238
]
14.73 ms
(7.54%)
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
  454840
  457149
  488030
  428758
  654840
  521089
  580298
  602739
  503975
  482484
  596616
  621203
  623206
  578825
  617275
  604016
  598172
  603878
  598022
  654399
  663247
  599859
  126458
  504639
  736856
  478895
  458744
  465123
  480831
  233676
  659793
  461973
  505021
  500777
  479418
  594577
  475918
  650056
  458470
  673661
  803238
  736852
  736845
  725167
  656545
  802893
  555787
  576145
  779832
  742234
  762273
  397852
  742160
  533763
  535618
  598041
  597560
  400957
  389587
  736824
  392554
  387352
  388546
  715300
  597052
  475231
  655625
  799909
  391561
  736869
  745352
  486044
  597801
  444197
  572322
  511689
  745363
  443902
  396182
  429960
  600112
  595423
  740710
  742473
  778380
  782184
  695093
  720641
  743051
  760466
  742916
  743025
  717725
  397856
  233443
  491155
  16998
  466187
  757846
  391310
  671250
  688927
  597041
  782131
  406657
  410036
  17037
  443884
  468089
  683303
  774653
  448349
  598443
  605791
  473990
  470320
  473992
  232978
  774642
  406074
]
4.23 ms
(2.16%)
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
  16998
  17037
  126458
  232978
  233443
  233676
  387352
  388546
  389587
  391310
  391561
  392554
  396182
  397852
  397856
  400957
  406074
  406657
  410036
  428758
  429960
  443884
  443902
  444197
  448349
  454840
  457149
  458470
  458744
  461973
  465123
  466187
  468089
  470320
  473990
  473992
  475231
  475918
  478895
  479418
  480831
  482484
  486044
  488030
  491155
  500777
  503975
  504639
  505021
  511689
  521089
  533763
  535618
  555787
  572322
  576145
  578825
  580298
  594577
  595423
  596616
  597041
  597052
  597560
  597801
  598022
  598041
  598172
  598443
  599859
  600112
  602739
  603878
  604016
  605791
  617275
  621203
  623206
  650056
  654399
  654840
  655625
  656545
  659793
  663247
  671250
  673661
  683303
  688927
  695093
  715300
  717725
  720641
  725167
  736824
  736845
  736852
  736856
  736869
  740710
  742160
  742234
  742473
  742916
  743025
  743051
  745352
  745363
  757846
  760466
  762273
  774642
  774653
  778380
  779832
  782131
  782184
  799909
  802893
  803238
]
2.31 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "молодые девушки русские"
]
1.92 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "молодая девушк русск"
]
1.83 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.84%)
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.