Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.50 ms
(82.92%)
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
  91510
  396458
  397555
  401350
  405508
  407250
  412540
  417947
  425335
  425852
  426138
  427939
  428402
  429145
  435323
  438741
  441162
  441265
  448844
  449001
  449291
  450028
  454529
  458297
  459575
  461150
  461776
  462501
  463186
  472795
  476383
  544521
  546659
  552207
  552211
  553674
  554789
  559186
  559219
  560292
  560655
  560942
  561901
  562240
  562996
  563206
  564434
  565024
  565301
  565404
  566055
  567398
  569845
  569887
  569911
  570224
  570251
  570258
  570259
  570280
  570297
  570307
  570319
  570348
  570350
  570359
  570459
  570506
  570646
  570648
  571559
  571614
  571631
  571636
  571650
  572083
  572363
  572400
  572465
  572467
  573023
  573083
  573632
  573633
  573795
  573892
  573954
  573963
  574591
  574663
  576084
  586835
  587055
  587930
  595490
  598744
  600027
  600473
  611103
  613426
  625489
  643624
  648648
  651578
  669339
  678783
  688997
  693291
  696114
  712276
  712814
  720456
  730076
  744612
  744927
  792722
  795515
  810122
  811950
  812143
]
17.19 ms
(10.52%)
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
  559219
  563206
  565301
  569845
  570258
  570297
  570319
  570350
  570646
  570648
  572363
  572465
  573083
  573632
  573795
  552211
  559186
  561901
  562996
  565024
  566055
  570224
  570459
  570506
  571559
  572467
  573954
  574591
  574663
  544521
  546659
  553674
  554789
  560292
  562240
  569911
  570259
  570280
  570307
  570348
  570359
  573633
  573892
  576084
  648648
  651578
  678783
  688997
  693291
  712814
  669339
  696114
  712276
  552207
  560655
  560942
  564434
  565404
  567398
  569887
  570251
  571614
  571631
  571636
  571650
  572083
  572400
  573023
  573963
  587055
  643624
  587930
  598744
  600027
  600473
  625489
  586835
  611103
  613426
  595490
  811950
  795515
  812143
  730076
  744612
  744927
  720456
  792722
  810122
  91510
  425335
  426138
  428402
  448844
  449001
  449291
  463186
  472795
  407250
  417947
  429145
  438741
  461150
  396458
  397555
  401350
  405508
  412540
  425852
  427939
  435323
  441162
  441265
  450028
  454529
  458297
  459575
  461776
  462501
  476383
]
4.25 ms
(2.60%)
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
  91510
  396458
  397555
  401350
  405508
  407250
  412540
  417947
  425335
  425852
  426138
  427939
  428402
  429145
  435323
  438741
  441162
  441265
  448844
  449001
  449291
  450028
  454529
  458297
  459575
  461150
  461776
  462501
  463186
  472795
  476383
  544521
  546659
  552207
  552211
  553674
  554789
  559186
  559219
  560292
  560655
  560942
  561901
  562240
  562996
  563206
  564434
  565024
  565301
  565404
  566055
  567398
  569845
  569887
  569911
  570224
  570251
  570258
  570259
  570280
  570297
  570307
  570319
  570348
  570350
  570359
  570459
  570506
  570646
  570648
  571559
  571614
  571631
  571636
  571650
  572083
  572363
  572400
  572465
  572467
  573023
  573083
  573632
  573633
  573795
  573892
  573954
  573963
  574591
  574663
  576084
  586835
  587055
  587930
  595490
  598744
  600027
  600473
  611103
  613426
  625489
  643624
  648648
  651578
  669339
  678783
  688997
  693291
  696114
  712276
  712814
  720456
  730076
  744612
  744927
  792722
  795515
  810122
  811950
  812143
]
1.88 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "нет сисек худая"
]
1.62 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сиськ худая"
]
1.37 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.