Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.30 ms
(86.22%)
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
  31329
  191199
  382786
  384588
  385474
  393705
  395540
  396747
  397209
  401280
  407709
  408351
  409374
  411368
  415755
  417244
  424431
  439475
  439795
  440974
  441583
  441770
  441788
  442941
  443628
  446023
  446386
  448704
  449093
  449158
  450139
  452345
  454168
  454369
  454525
  454759
  455201
  456995
  459238
  462488
  462707
  464018
  465551
  466005
  466206
  466217
  466738
  466986
  468685
  468760
  468858
  469347
  470158
  470260
  471995
  472398
  473194
  473334
  473457
  474831
  474855
  475539
  476030
  476039
  477596
  477950
  478375
  478411
  479066
  482761
  485273
  485377
  489171
  489384
  490731
  491124
  493026
  493426
  494192
  494204
  494957
  502199
  502813
  503845
  507003
  509199
  509204
  509528
  509655
  511273
  512085
  515276
  515615
  516483
  516808
  517525
  518355
  518872
  521127
  526837
  527041
  538005
  549731
  550646
  556559
  559042
  564254
  569407
  579196
  683012
  696983
  720357
  738209
  742633
  758801
  758807
  768756
  785126
  788819
  803298
]
14.36 ms
(8.35%)
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
  191199
  397209
  474855
  472398
  485377
  474831
  476039
  550646
  559042
  395540
  442941
  475539
  477950
  526837
  493026
  509528
  509655
  517525
  439795
  440974
  454525
  478375
  466217
  509204
  485273
  564254
  393705
  401280
  407709
  449093
  448704
  454168
  473334
  452345
  466738
  549731
  556559
  569407
  579196
  424431
  449158
  459238
  462707
  466005
  468858
  471995
  443628
  464018
  476030
  502199
  494192
  494204
  439475
  482761
  454369
  466986
  468685
  785126
  31329
  385474
  396747
  411368
  473194
  465551
  466206
  470158
  477596
  538005
  503845
  511273
  518355
  489384
  490731
  502813
  507003
  515276
  516483
  516808
  489171
  518872
  441788
  409374
  478411
  456995
  509199
  696983
  683012
  788819
  742633
  758807
  768756
  758801
  738209
  720357
  408351
  479066
  382786
  417244
  515615
  441770
  441583
  470260
  450139
  455201
  803298
  415755
  491124
  494957
  473457
  446386
  446023
  468760
  512085
  462488
  469347
  493426
  521127
  527041
  384588
  454759
]
2.82 ms
(1.64%)
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
  31329
  191199
  382786
  384588
  385474
  393705
  395540
  396747
  397209
  401280
  407709
  408351
  409374
  411368
  415755
  417244
  424431
  439475
  439795
  440974
  441583
  441770
  441788
  442941
  443628
  446023
  446386
  448704
  449093
  449158
  450139
  452345
  454168
  454369
  454525
  454759
  455201
  456995
  459238
  462488
  462707
  464018
  465551
  466005
  466206
  466217
  466738
  466986
  468685
  468760
  468858
  469347
  470158
  470260
  471995
  472398
  473194
  473334
  473457
  474831
  474855
  475539
  476030
  476039
  477596
  477950
  478375
  478411
  479066
  482761
  485273
  485377
  489171
  489384
  490731
  491124
  493026
  493426
  494192
  494204
  494957
  502199
  502813
  503845
  507003
  509199
  509204
  509528
  509655
  511273
  512085
  515276
  515615
  516483
  516808
  517525
  518355
  518872
  521127
  526837
  527041
  538005
  549731
  550646
  556559
  559042
  564254
  569407
  579196
  683012
  696983
  720357
  738209
  742633
  758801
  758807
  768756
  785126
  788819
  803298
]
2.07 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жирная теща"
]
1.62 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "толстая зрелая женщин"
]
1.25 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.