Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.10 ms
(85.27%)
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
  395623
  401749
  410953
  414739
  418673
  422177
  447496
  449291
  449313
  453496
  458721
  459156
  468749
  470784
  475052
  477037
  485039
  489308
  490499
  491353
  497932
  507975
  508902
  513769
  519504
  520174
  520688
  521754
  521869
  525402
  526937
  533447
  548779
  550242
  551972
  562132
  562758
  564220
  567061
  567772
  570599
  573891
  576347
  622746
  645836
  654453
  659066
  666978
  671458
  675796
  675808
  676532
  676915
  679059
  693511
  699639
  700513
  700595
  718976
  720035
  721275
  722617
  722683
  727715
  728154
  730650
  730938
  731867
  734356
  736373
  739645
  740822
  742337
  744591
  745031
  746146
  746982
  748011
  752761
  754126
  754196
  756947
  761321
  762500
  762553
  764184
  770764
  772108
  774256
  776942
  780328
  780481
  782769
  787106
  788213
  790033
  793830
  793839
  800204
  802319
  804493
  804611
  804942
  805267
  805400
  806111
  807963
  810062
  810326
  810690
  812160
  816758
  817815
  821083
  821379
  821635
  824526
  826490
  826881
]
14.51 ms
(8.65%)
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
  816758
  817815
  821083
  821379
  521754
  533447
  567772
  550242
  645836
  666978
  676915
  693511
  699639
  720035
  654453
  675796
  679059
  700595
  721275
  722683
  676532
  718976
  722617
  562132
  622746
  776942
  782769
  788213
  800204
  780481
  790033
  804493
  804611
  805400
  727715
  730650
  770764
  774256
  802319
  805267
  807963
  810326
  734356
  736373
  739645
  744591
  756947
  759378
  728154
  745031
  746146
  748011
  754126
  754196
  762553
  731867
  742337
  752761
  761321
  762500
  772108
  740822
  746982
  700513
  787106
  806111
  810062
  812160
  414739
  520174
  576347
  485039
  507975
  671458
  659066
  810690
  520688
  449313
  458721
  567061
  422177
  449291
  470784
  395623
  491353
  519504
  821635
  824526
  826490
  826881
  564220
  804942
  730938
  453496
  468749
  475052
  525402
  508902
  570599
  548779
  675808
  573891
  410953
  418673
  477037
  489308
  497932
  490499
  780328
  793830
  793839
  764184
  562758
  513769
  551972
  447496
  459156
  526937
  521869
  401749
]
3.13 ms
(1.86%)
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
  395623
  401749
  410953
  414739
  418673
  422177
  447496
  449291
  449313
  453496
  458721
  459156
  468749
  470784
  475052
  477037
  485039
  489308
  490499
  491353
  497932
  507975
  508902
  513769
  519504
  520174
  520688
  521754
  521869
  525402
  526937
  533447
  548779
  550242
  551972
  562132
  562758
  564220
  567061
  567772
  570599
  573891
  576347
  622746
  645836
  654453
  659066
  666978
  671458
  675796
  675808
  676532
  676915
  679059
  693511
  699639
  700513
  700595
  718976
  720035
  721275
  722617
  722683
  727715
  728154
  730650
  730938
  731867
  734356
  736373
  739645
  740822
  742337
  744591
  745031
  746146
  746982
  748011
  752761
  754126
  754196
  756947
  761321
  762500
  762553
  764184
  770764
  772108
  774256
  776942
  780328
  780481
  782769
  787106
  788213
  790033
  793830
  793839
  800204
  802319
  804493
  804611
  804942
  805267
  805400
  806111
  807963
  810062
  810326
  810690
  812160
  816758
  817815
  821083
  821379
  821635
  824526
  826490
  826881
]
1.95 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "shaved pussy lick"
]
1.86 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "бритая pussy лиза"
]
1.43 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "бритая 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.