Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.21 ms
(84.52%)
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
  383687
  393274
  398747
  420037
  427798
  461864
  510494
  530559
  543106
  570677
  571488
  581275
  587978
  588278
  592159
  592680
  594581
  596981
  610489
  613643
  619815
  623372
  626023
  627623
  629667
  630212
  633030
  634948
  635522
  639680
  644773
  645697
  648693
  652338
  660622
  665324
  668813
  671228
  682957
  689477
  689923
  696299
  699346
  700775
  725741
  730356
  730719
  731304
  735394
  735965
  736502
  736577
  737286
  739095
  739685
  740272
  744243
  745849
  747376
  748880
  749662
  753429
  757654
  757695
  758506
  758654
  759728
  760256
  762499
  765345
  766093
  766205
  767680
  769199
  771400
  771437
  772962
  780124
  780510
  783699
  783995
  784232
  784235
  785232
  786204
  786784
  788100
  789060
  791481
  791985
  792417
  793113
  793308
  793777
  798864
  798886
  803204
  804918
  805072
  808760
  810399
  811658
  814593
  816130
  817496
  818135
  819668
  820736
  821788
  821819
  822533
  822551
  823407
  823612
  824488
  824678
  825056
  826745
  828373
  828626
]
18.99 ms
(10.08%)
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
  398747
  822533
  823407
  826745
  820736
  828373
  570677
  696299
  627623
  785232
  798864
  730719
  735394
  765345
  769199
  783699
  792417
  805072
  731304
  739095
  748880
  760256
  740272
  753429
  757654
  730356
  771437
  634948
  789060
  700775
  383687
  623372
  824488
  461864
  571488
  543106
  645697
  671228
  803204
  766093
  784235
  759728
  757695
  393274
  825056
  818135
  816130
  817496
  828626
  530559
  652338
  668813
  660622
  594581
  596981
  592680
  635522
  630212
  644773
  592159
  639680
  783995
  786204
  786784
  749662
  758654
  736502
  745849
  758506
  767680
  725741
  821788
  510494
  648693
  665324
  682957
  610489
  619815
  626023
  588278
  793308
  784232
  791481
  747376
  762499
  771400
  810399
  739685
  633030
  780124
  780510
  420037
  427798
  814593
  822551
  823612
  821819
  824678
  819668
  581275
  689477
  689923
  699346
  587978
  629667
  613643
  788100
  791985
  793113
  804918
  808760
  793777
  798886
  811658
  766205
  772962
  737286
  735965
  736577
  744243
]
2.96 ms
(1.57%)
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
  383687
  393274
  398747
  420037
  427798
  461864
  510494
  530559
  543106
  570677
  571488
  581275
  587978
  588278
  592159
  592680
  594581
  596981
  610489
  613643
  619815
  623372
  626023
  627623
  629667
  630212
  633030
  634948
  635522
  639680
  644773
  645697
  648693
  652338
  660622
  665324
  668813
  671228
  682957
  689477
  689923
  696299
  699346
  700775
  725741
  730356
  730719
  731304
  735394
  735965
  736502
  736577
  737286
  739095
  739685
  740272
  744243
  745849
  747376
  748880
  749662
  753429
  757654
  757695
  758506
  758654
  759728
  760256
  762499
  765345
  766093
  766205
  767680
  769199
  771400
  771437
  772962
  780124
  780510
  783699
  783995
  784232
  784235
  785232
  786204
  786784
  788100
  789060
  791481
  791985
  792417
  793113
  793308
  793777
  798864
  798886
  803204
  804918
  805072
  808760
  810399
  811658
  814593
  816130
  817496
  818135
  819668
  820736
  821788
  821819
  822533
  822551
  823407
  823612
  824488
  824678
  825056
  826745
  828373
  828626
]
1.93 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "room секс"
]
1.91 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "room sex"
]
1.70 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "room секс"
]

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.