Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.78 ms
(85.26%)
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
  379777
  402378
  405208
  430824
  434046
  434163
  434212
  437843
  448644
  448669
  448953
  460267
  464129
  464542
  486531
  489934
  495199
  495868
  497404
  498057
  499717
  503449
  504422
  506908
  511829
  513137
  514808
  516790
  519983
  520113
  522438
  522605
  523511
  524283
  525882
  526930
  527029
  527139
  528331
  528336
  528779
  531943
  538274
  542094
  542870
  543026
  549174
  549688
  553332
  556002
  561286
  561295
  562888
  563122
  563885
  564194
  564208
  565101
  565160
  566375
  566708
  572194
  572675
  573941
  574231
  574414
  577410
  585163
  585721
  586805
  592580
  592662
  597670
  598361
  600488
  605356
  608387
  610241
  612828
  613683
  614557
  618813
  619366
  620275
  623735
  626857
  671348
  678899
  682389
  683369
  683906
  683952
  684910
  684997
  696934
  700426
  702299
  704561
  706676
  721617
  730307
  734008
  734506
  735867
  746736
  758847
  788373
  789175
  790891
  792614
  796239
  797280
  801906
  804771
  805629
  805874
  807533
  814781
  814936
  816541
]
17.65 ms
(9.36%)
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
  614557
  801906
  804771
  807533
  706676
  448953
  516790
  528336
  538274
  520113
  702299
  684997
  610241
  597670
  620275
  789175
  790891
  797280
  805629
  734008
  746736
  522438
  814936
  816541
  553332
  574231
  683906
  556002
  598361
  600488
  696934
  525882
  522605
  734506
  460267
  524283
  528331
  503449
  528779
  519983
  549174
  678899
  572675
  623735
  612828
  626857
  730307
  735867
  758847
  618813
  788373
  796239
  499717
  526930
  721617
  586805
  448669
  566708
  437843
  506908
  405208
  434163
  527139
  542094
  565160
  562888
  574414
  605356
  700426
  511829
  514808
  577410
  613683
  495868
  572194
  564208
  561295
  608387
  585163
  592662
  464129
  513137
  434212
  434046
  504422
  549688
  683369
  704561
  448644
  671348
  430824
  543026
  573941
  564194
  464542
  531943
  379777
  814781
  592580
  486531
  527029
  542870
  561286
  563122
  619366
  792614
  523511
  489934
  402378
  684910
  805874
  498057
  495199
  497404
  585721
  566375
  565101
  683952
  682389
  563885
]
2.98 ms
(1.58%)
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
  379777
  402378
  405208
  430824
  434046
  434163
  434212
  437843
  448644
  448669
  448953
  460267
  464129
  464542
  486531
  489934
  495199
  495868
  497404
  498057
  499717
  503449
  504422
  506908
  511829
  513137
  514808
  516790
  519983
  520113
  522438
  522605
  523511
  524283
  525882
  526930
  527029
  527139
  528331
  528336
  528779
  531943
  538274
  542094
  542870
  543026
  549174
  549688
  553332
  556002
  561286
  561295
  562888
  563122
  563885
  564194
  564208
  565101
  565160
  566375
  566708
  572194
  572675
  573941
  574231
  574414
  577410
  585163
  585721
  586805
  592580
  592662
  597670
  598361
  600488
  605356
  608387
  610241
  612828
  613683
  614557
  618813
  619366
  620275
  623735
  626857
  671348
  678899
  682389
  683369
  683906
  683952
  684910
  684997
  696934
  700426
  702299
  704561
  706676
  721617
  730307
  734008
  734506
  735867
  746736
  758847
  788373
  789175
  790891
  792614
  796239
  797280
  801906
  804771
  805629
  805874
  807533
  814781
  814936
  816541
]
2.09 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother stepdaughter"
]
1.74 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин stepdaughter"
]
1.71 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин stepdaughter"
]

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.