Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.95 ms
(83.37%)
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
  142471
  387798
  391693
  393442
  396458
  396748
  397071
  399475
  409015
  412506
  413106
  414101
  414760
  417770
  417813
  417975
  419428
  422054
  422318
  424159
  429040
  429066
  429071
  429182
  429286
  429299
  429611
  431139
  431541
  444726
  445567
  450269
  453198
  461585
  464625
  470301
  475143
  475343
  477211
  478464
  482730
  485196
  486766
  489009
  489523
  490205
  490592
  491192
  491199
  491205
  491776
  493876
  502991
  503003
  510214
  512242
  518917
  524207
  525842
  528970
  540876
  541195
  545456
  548058
  551189
  551203
  555791
  558042
  558307
  559097
  560186
  561392
  561656
  561672
  561684
  561718
  564459
  565044
  565053
  568299
  570711
  572427
  572498
  573384
  573857
  576728
  581961
  588116
  597051
  598451
  602633
  604350
  605850
  612476
  620256
  622510
  627378
  651151
  651808
  653243
  660613
  663232
  665867
  666662
  667672
  681216
  682865
  685767
  689212
  692998
  696460
  708505
  721006
  744095
  745075
  750471
  757151
  791975
  810965
  827829
]
16.95 ms
(9.89%)
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
  757151
  744095
  721006
  665867
  681216
  667672
  605850
  598451
  620256
  417813
  827829
  528970
  548058
  568299
  572498
  565053
  545456
  685767
  692998
  561718
  576728
  597051
  750471
  414760
  445567
  396458
  397071
  399475
  409015
  422054
  461585
  490205
  512242
  489523
  482730
  558307
  602633
  470301
  431541
  475143
  477211
  490592
  491776
  142471
  424159
  510214
  525842
  502991
  503003
  429611
  486766
  572427
  570711
  561656
  663232
  573857
  604350
  791975
  745075
  478464
  429299
  524207
  485196
  491199
  491192
  491205
  518917
  419428
  387798
  422318
  429066
  450269
  682865
  689212
  708505
  651151
  666662
  696460
  588116
  612476
  622510
  627378
  810965
  417770
  475343
  431139
  393442
  391693
  396748
  417975
  429040
  429182
  429071
  429286
  414101
  412506
  413106
  444726
  540876
  489009
  453198
  464625
  493876
  551203
  558042
  561672
  573384
  551189
  564459
  541195
  555791
  561392
  565044
  581961
  651808
  653243
  660613
  559097
  560186
  561684
]
3.89 ms
(2.27%)
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
  142471
  387798
  391693
  393442
  396458
  396748
  397071
  399475
  409015
  412506
  413106
  414101
  414760
  417770
  417813
  417975
  419428
  422054
  422318
  424159
  429040
  429066
  429071
  429182
  429286
  429299
  429611
  431139
  431541
  444726
  445567
  450269
  453198
  461585
  464625
  470301
  475143
  475343
  477211
  478464
  482730
  485196
  486766
  489009
  489523
  490205
  490592
  491192
  491199
  491205
  491776
  493876
  502991
  503003
  510214
  512242
  518917
  524207
  525842
  528970
  540876
  541195
  545456
  548058
  551189
  551203
  555791
  558042
  558307
  559097
  560186
  561392
  561656
  561672
  561684
  561718
  564459
  565044
  565053
  568299
  570711
  572427
  572498
  573384
  573857
  576728
  581961
  588116
  597051
  598451
  602633
  604350
  605850
  612476
  620256
  622510
  627378
  651151
  651808
  653243
  660613
  663232
  665867
  666662
  667672
  681216
  682865
  685767
  689212
  692998
  696460
  708505
  721006
  744095
  745075
  750471
  757151
  791975
  810965
  827829
]
2.24 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "18 skinny blonde"
]
2.02 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "18 худые беловолосая"
]
1.74 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "18 худые беловолосая"
]
1.66 ms
(0.97%)
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.