Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
185.77 ms
(88.25%)
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
  21576
  371547
  386994
  391745
  395839
  396784
  397564
  398713
  398922
  401727
  402080
  402434
  403117
  403285
  405701
  410655
  413109
  413228
  414734
  416441
  417748
  421182
  424764
  425026
  426100
  429169
  429259
  429349
  439870
  443463
  446259
  447645
  447659
  449003
  451677
  451699
  459832
  461582
  464688
  467253
  467384
  470048
  470341
  473260
  473844
  475761
  478849
  482258
  483721
  484058
  485235
  487086
  487281
  489584
  490847
  493112
  493115
  502772
  505324
  509765
  511060
  512234
  512259
  512838
  516105
  518951
  521825
  522535
  522814
  526436
  527550
  531032
  548693
  549394
  549898
  556346
  556855
  558823
  572564
  572638
  579253
  591280
  592823
  593263
  600454
  604956
  607084
  609808
  612119
  612666
  624354
  636161
  654351
  655428
  655732
  656728
  656957
  657416
  658690
  659150
  660505
  660540
  669414
  675768
  686064
  698015
  707774
  716934
  722888
  740807
  741428
  768591
  779724
  780843
  789315
  791490
  793334
  814139
  817617
  828843
]
14.70 ms
(6.99%)
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
  396784
  398713
  421182
  443463
  464688
  467384
  470341
  21576
  371547
  402434
  416441
  426100
  429169
  429349
  461582
  470048
  482258
  425026
  502772
  518951
  521825
  487086
  505324
  509765
  512259
  489584
  512234
  483721
  484058
  493115
  511060
  386994
  402080
  473844
  485235
  467253
  572564
  558823
  548693
  556346
  579253
  659150
  707774
  654351
  722888
  656728
  686064
  698015
  716934
  556855
  609808
  607084
  592823
  593263
  604956
  612119
  600454
  612666
  779724
  793334
  780843
  740807
  741428
  791490
  768591
  636161
  401727
  410655
  413109
  414734
  429259
  451677
  451699
  475761
  405701
  449003
  397564
  403117
  424764
  478849
  403285
  473260
  527550
  490847
  493112
  512838
  516105
  522814
  522535
  398922
  828843
  531032
  572638
  549394
  656957
  660540
  655732
  655428
  657416
  658690
  660505
  669414
  675768
  549898
  624354
  591280
  789315
  395839
  391745
  413228
  417748
  439870
  817617
  526436
  814139
  446259
  447645
  487281
  447659
  459832
]
2.32 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая худые"
]
2.25 ms
(1.07%)
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
  21576
  371547
  386994
  391745
  395839
  396784
  397564
  398713
  398922
  401727
  402080
  402434
  403117
  403285
  405701
  410655
  413109
  413228
  414734
  416441
  417748
  421182
  424764
  425026
  426100
  429169
  429259
  429349
  439870
  443463
  446259
  447645
  447659
  449003
  451677
  451699
  459832
  461582
  464688
  467253
  467384
  470048
  470341
  473260
  473844
  475761
  478849
  482258
  483721
  484058
  485235
  487086
  487281
  489584
  490847
  493112
  493115
  502772
  505324
  509765
  511060
  512234
  512259
  512838
  516105
  518951
  521825
  522535
  522814
  526436
  527550
  531032
  548693
  549394
  549898
  556346
  556855
  558823
  572564
  572638
  579253
  591280
  592823
  593263
  600454
  604956
  607084
  609808
  612119
  612666
  624354
  636161
  654351
  655428
  655732
  656728
  656957
  657416
  658690
  659150
  660505
  660540
  669414
  675768
  686064
  698015
  707774
  716934
  722888
  740807
  741428
  768591
  779724
  780843
  789315
  791490
  793334
  814139
  817617
  828843
]
2.17 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful skinny"
]
1.75 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.73%)
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.