Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
150.19 ms
(86.73%)
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
  94897
  384241
  385129
  391572
  400157
  402134
  408624
  453746
  471904
  472944
  533729
  535938
  538238
  540148
  540477
  542346
  547332
  548362
  549328
  549330
  549333
  549363
  549408
  549928
  549975
  556328
  557172
  559388
  560092
  560145
  566801
  570216
  571174
  571181
  571264
  574202
  577229
  577235
  577254
  586826
  586831
  589928
  593199
  593232
  596164
  597223
  603071
  606846
  606856
  627155
  627656
  630479
  643118
  644339
  648595
  655309
  655422
  655633
  655727
  656032
  656384
  656392
  656426
  656749
  656948
  656951
  657305
  657351
  657437
  657651
  657693
  657701
  657896
  657927
  657967
  658009
  658026
  658426
  658588
  659581
  659612
  659709
  660492
  660538
  660543
  660930
  661866
  663050
  669111
  670176
  671088
  691499
  693885
  702636
  708653
  721200
  722405
  723364
  725310
  738889
  740215
  744104
  747393
  753469
  753470
  770885
  785216
  789352
  794831
  808409
  814147
  818254
  818350
  818912
  820491
  820781
  820938
  826186
  828733
  828872
]
13.56 ms
(7.83%)
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
  655633
  657305
  657967
  663050
  655727
  656426
  657351
  657651
  659709
  669111
  693885
  656951
  658588
  661866
  547332
  549408
  549928
  577254
  740215
  606846
  384241
  400157
  818912
  542346
  549328
  571264
  556328
  560145
  708653
  722405
  691499
  559388
  560092
  593232
  586826
  630479
  606856
  589928
  627155
  627656
  808409
  725310
  753469
  738889
  753470
  770885
  744104
  747393
  702636
  472944
  385129
  391572
  535938
  597223
  453746
  820781
  826186
  818350
  820491
  818254
  828872
  828733
  538238
  540477
  540148
  471904
  570216
  574202
  577229
  549333
  549363
  566801
  571181
  548362
  549330
  648595
  655422
  656032
  657927
  658426
  660930
  670176
  656392
  657701
  657896
  658026
  659581
  660492
  671088
  655309
  656384
  656749
  656948
  657437
  657693
  658009
  659612
  660538
  660543
  721200
  549975
  557172
  571174
  577235
  596164
  603071
  586831
  593199
  643118
  785216
  794831
  644339
  723364
  789352
  94897
  408624
  402134
  814147
  820938
  533729
]
2.51 ms
(1.45%)
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
  94897
  384241
  385129
  391572
  400157
  402134
  408624
  453746
  471904
  472944
  533729
  535938
  538238
  540148
  540477
  542346
  547332
  548362
  549328
  549330
  549333
  549363
  549408
  549928
  549975
  556328
  557172
  559388
  560092
  560145
  566801
  570216
  571174
  571181
  571264
  574202
  577229
  577235
  577254
  586826
  586831
  589928
  593199
  593232
  596164
  597223
  603071
  606846
  606856
  627155
  627656
  630479
  643118
  644339
  648595
  655309
  655422
  655633
  655727
  656032
  656384
  656392
  656426
  656749
  656948
  656951
  657305
  657351
  657437
  657651
  657693
  657701
  657896
  657927
  657967
  658009
  658026
  658426
  658588
  659581
  659612
  659709
  660492
  660538
  660543
  660930
  661866
  663050
  669111
  670176
  671088
  691499
  693885
  702636
  708653
  721200
  722405
  723364
  725310
  738889
  740215
  744104
  747393
  753469
  753470
  770885
  785216
  789352
  794831
  808409
  814147
  818254
  818350
  818912
  820491
  820781
  820938
  826186
  828733
  828872
]
1.99 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny beauty"
]
1.77 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые beauty"
]
1.61 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худые beauty"
]
1.55 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.