Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.47 ms
(83.01%)
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
  120415
  182526
  320879
  383479
  387281
  387295
  389023
  391922
  397296
  398585
  401009
  401057
  407346
  421842
  422989
  423605
  423989
  424556
  425952
  426259
  426898
  428883
  428885
  431463
  433946
  442674
  448483
  449531
  450192
  450912
  451797
  452772
  455631
  457336
  457842
  461932
  462623
  463641
  465739
  466199
  466714
  467065
  468329
  468514
  468641
  468730
  469213
  469784
  470354
  470572
  470988
  475940
  476225
  478113
  478437
  482501
  483498
  491786
  496813
  498092
  499327
  500238
  500590
  502180
  502222
  503502
  503756
  504201
  506435
  507348
  507533
  507557
  509752
  512552
  512738
  512745
  514366
  516115
  521048
  528636
  529177
  529347
  532056
  534186
  541859
  545050
  549241
  549293
  550667
  551532
  552229
  555149
  557989
  558286
  560434
  565659
  566760
  570716
  573798
  575198
  578023
  578509
  578823
  582689
  585390
  586649
  587315
  587358
  595805
  596857
  601659
  605503
  607709
  620432
  625312
  639551
  652758
  664836
  671085
  768575
]
16.54 ms
(10.69%)
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
  442674
  465739
  463641
  457336
  466199
  514366
  502222
  552229
  401057
  389023
  468514
  433946
  462623
  516115
  605503
  423605
  182526
  455631
  423989
  391922
  387281
  398585
  451797
  470354
  470572
  478437
  461932
  468329
  475940
  557989
  578509
  586649
  407346
  421842
  426898
  448483
  431463
  449531
  500238
  503756
  509752
  512552
  558286
  450912
  503502
  120415
  545050
  428885
  502180
  587358
  452772
  534186
  476225
  496813
  428883
  507533
  468641
  582689
  521048
  620432
  478113
  500590
  560434
  387295
  639551
  506435
  469213
  566760
  549293
  507348
  467065
  424556
  512738
  512745
  607709
  468730
  401009
  549241
  664836
  587315
  466714
  578023
  671085
  768575
  397296
  320879
  499327
  457842
  570716
  575198
  601659
  383479
  450192
  532056
  483498
  578823
  541859
  482501
  491786
  422989
  469784
  498092
  652758
  573798
  565659
  529177
  504201
  625312
  550667
  529347
  551532
  555149
  528636
  425952
  426259
  507557
  585390
  595805
  596857
  470988
]
2.75 ms
(1.78%)
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
  120415
  182526
  320879
  383479
  387281
  387295
  389023
  391922
  397296
  398585
  401009
  401057
  407346
  421842
  422989
  423605
  423989
  424556
  425952
  426259
  426898
  428883
  428885
  431463
  433946
  442674
  448483
  449531
  450192
  450912
  451797
  452772
  455631
  457336
  457842
  461932
  462623
  463641
  465739
  466199
  466714
  467065
  468329
  468514
  468641
  468730
  469213
  469784
  470354
  470572
  470988
  475940
  476225
  478113
  478437
  482501
  483498
  491786
  496813
  498092
  499327
  500238
  500590
  502180
  502222
  503502
  503756
  504201
  506435
  507348
  507533
  507557
  509752
  512552
  512738
  512745
  514366
  516115
  521048
  528636
  529177
  529347
  532056
  534186
  541859
  545050
  549241
  549293
  550667
  551532
  552229
  555149
  557989
  558286
  560434
  565659
  566760
  570716
  573798
  575198
  578023
  578509
  578823
  582689
  585390
  586649
  587315
  587358
  595805
  596857
  601659
  605503
  607709
  620432
  625312
  639551
  652758
  664836
  671085
  768575
]
2.13 ms
(1.37%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.89 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в чулках на кровате"
]
1.52 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "чулк нижн бел на кроват"
]
1.47 ms
(0.95%)
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.