Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
263.76 ms
(52.48%)
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
  56464
  72431
  187847
  188610
  358438
  358481
  383235
  385486
  387043
  388364
  391054
  391326
  394059
  396881
  400487
  400923
  401804
  402973
  403000
  404522
  405222
  406298
  407878
  411208
  411389
  411408
  421843
  421883
  421894
  421913
  422182
  428421
  429409
  430630
  432235
  439710
  440813
  440938
  442198
  443769
  447474
  448800
  451505
  454989
  460638
  465394
  466733
  468537
  468900
  470109
  470290
  471195
  475724
  480270
  482345
  484402
  484692
  485697
  491230
  492320
  507015
  517711
  518750
  519588
  520672
  523767
  526556
  529362
  538834
  556524
  556654
  557118
  562885
  578509
  601956
  601975
  607537
  620158
  636283
  642853
  665789
  706030
  710460
  719873
  721646
  726794
  730444
  759451
  765134
  765726
  766442
  767175
  768328
  768420
  772585
  772612
  778143
  782628
  789225
  792533
  792564
  793886
  793997
  797780
  797844
  799093
  800171
  800344
  802998
  803062
  803621
  805768
  808452
  808870
  810402
  810477
  811174
  812356
  813944
  814571
]
215.62 ms
(42.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "рыжая мам женщин"
]
14.73 ms
(2.93%)
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
  557118
  466733
  480270
  485697
  406298
  538834
  429409
  484402
  607537
  519588
  562885
  430630
  636283
  484692
  601956
  465394
  726794
  470290
  520672
  492320
  523767
  556524
  443769
  468537
  793886
  451505
  442198
  793997
  518750
  721646
  391054
  812356
  768328
  803062
  387043
  440938
  411408
  358438
  802998
  421894
  439710
  782628
  470109
  400487
  358481
  421913
  529362
  383235
  400923
  800344
  188610
  710460
  765726
  402973
  768420
  810477
  767175
  187847
  507015
  394059
  401804
  471195
  620158
  642853
  797844
  792564
  396881
  813944
  491230
  526556
  719873
  706030
  810402
  730444
  789225
  411389
  811174
  454989
  778143
  447474
  56464
  765134
  808452
  428421
  482345
  799093
  422182
  405222
  665789
  766442
  404522
  421883
  432235
  411208
  460638
  792533
  468900
  517711
  72431
  475724
  403000
  388364
  800171
  759451
  772585
  797780
  805768
  808870
  814571
  601975
  391326
  407878
  448800
  556654
  578509
  803621
  772612
  421843
  385486
  440813
]
3.04 ms
(0.61%)
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
  56464
  72431
  187847
  188610
  358438
  358481
  383235
  385486
  387043
  388364
  391054
  391326
  394059
  396881
  400487
  400923
  401804
  402973
  403000
  404522
  405222
  406298
  407878
  411208
  411389
  411408
  421843
  421883
  421894
  421913
  422182
  428421
  429409
  430630
  432235
  439710
  440813
  440938
  442198
  443769
  447474
  448800
  451505
  454989
  460638
  465394
  466733
  468537
  468900
  470109
  470290
  471195
  475724
  480270
  482345
  484402
  484692
  485697
  491230
  492320
  507015
  517711
  518750
  519588
  520672
  523767
  526556
  529362
  538834
  556524
  556654
  557118
  562885
  578509
  601956
  601975
  607537
  620158
  636283
  642853
  665789
  706030
  710460
  719873
  721646
  726794
  730444
  759451
  765134
  765726
  766442
  767175
  768328
  768420
  772585
  772612
  778143
  782628
  789225
  792533
  792564
  793886
  793997
  797780
  797844
  799093
  800171
  800344
  802998
  803062
  803621
  805768
  808452
  808870
  810402
  810477
  811174
  812356
  813944
  814571
]
2.08 ms
(0.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рыжая мам женщин"
]
1.75 ms
(0.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "рыжие мамы"
]
1.62 ms
(0.32%)
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.