Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.10 ms
(86.91%)
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
  386280
  422704
  442649
  446772
  460003
  468301
  476306
  490598
  490646
  502751
  506510
  514250
  515258
  517485
  535324
  538956
  539774
  549230
  549240
  555612
  556612
  557706
  558314
  560403
  560910
  562153
  562554
  563731
  565993
  571048
  585416
  603930
  606362
  609057
  624821
  627938
  636968
  637409
  650524
  652162
  658943
  660436
  661029
  662877
  665142
  665187
  666683
  667172
  667496
  667615
  668155
  668538
  671705
  675230
  676116
  688019
  692460
  694098
  694505
  695140
  698431
  702582
  703140
  705452
  707479
  713087
  713188
  714377
  714476
  714785
  715264
  715724
  716487
  719144
  724718
  728732
  734270
  736539
  748800
  752114
  753617
  754647
  768890
  768932
  776325
  788560
  790024
  790991
  794414
  800726
  802179
  802598
  804269
  804456
  806287
  808296
  817058
  817136
  819412
  819773
  820472
  821604
  823549
  823576
  823713
  823946
  824403
  824632
  824663
  824868
  826314
  826620
  826705
  826787
  827100
  827102
  827176
  827395
  827397
  828294
]
14.02 ms
(7.38%)
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
  386280
  827395
  823713
  555612
  676116
  702582
  802179
  728732
  806287
  422704
  819412
  820472
  824403
  823946
  826787
  827100
  827102
  817058
  817136
  826314
  828294
  538956
  535324
  652162
  688019
  692460
  714785
  705452
  667172
  675230
  585416
  637409
  606362
  636968
  794414
  776325
  788560
  800726
  804269
  802598
  804456
  768932
  724718
  748800
  734270
  736539
  752114
  753617
  754647
  768890
  627938
  790024
  790991
  808296
  556612
  609057
  824868
  446772
  476306
  490598
  502751
  514250
  506510
  539774
  549230
  557706
  549240
  719144
  665187
  603930
  715724
  460003
  515258
  560403
  571048
  558314
  562153
  667496
  695140
  714476
  665142
  694098
  624821
  490646
  517485
  468301
  442649
  823576
  824632
  824663
  826620
  826705
  819773
  823549
  827176
  827397
  821604
  562554
  563731
  560910
  565993
  650524
  668155
  694505
  713188
  714377
  715264
  716487
  658943
  703140
  707479
  660436
  661029
  662877
  666683
  667615
  668538
  671705
  698431
  713087
]
2.58 ms
(1.36%)
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
  386280
  422704
  442649
  446772
  460003
  468301
  476306
  490598
  490646
  502751
  506510
  514250
  515258
  517485
  535324
  538956
  539774
  549230
  549240
  555612
  556612
  557706
  558314
  560403
  560910
  562153
  562554
  563731
  565993
  571048
  585416
  603930
  606362
  609057
  624821
  627938
  636968
  637409
  650524
  652162
  658943
  660436
  661029
  662877
  665142
  665187
  666683
  667172
  667496
  667615
  668155
  668538
  671705
  675230
  676116
  688019
  692460
  694098
  694505
  695140
  698431
  702582
  703140
  705452
  707479
  713087
  713188
  714377
  714476
  714785
  715264
  715724
  716487
  719144
  724718
  728732
  734270
  736539
  748800
  752114
  753617
  754647
  768890
  768932
  776325
  788560
  790024
  790991
  794414
  800726
  802179
  802598
  804269
  804456
  806287
  808296
  817058
  817136
  819412
  819773
  820472
  821604
  823549
  823576
  823713
  823946
  824403
  824632
  824663
  824868
  826314
  826620
  826705
  826787
  827100
  827102
  827176
  827395
  827397
  828294
]
2.32 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy saggy tits"
]
2.17 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.07 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая saggy сиськ"
]
1.71 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "волосатая saggy сиськ"
]

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.