Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
170.27 ms
(85.35%)
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
  7196
  101894
  102334
  152234
  336584
  382330
  384420
  384524
  386304
  387946
  388849
  394760
  395715
  396527
  402869
  403577
  407136
  407148
  411227
  413047
  413485
  414581
  416200
  416797
  418028
  418952
  419751
  423633
  425004
  425767
  430701
  434392
  435496
  435731
  437509
  440618
  440680
  443578
  445499
  445626
  447301
  448501
  448705
  450988
  452292
  453333
  453335
  461732
  461738
  461744
  461748
  461756
  463829
  464162
  464430
  466588
  466696
  468731
  469599
  472180
  472553
  479703
  482626
  483571
  484503
  484506
  484785
  484791
  484797
  485094
  485158
  485165
  486182
  488931
  499812
  503693
  506304
  507804
  512532
  512534
  514071
  516291
  518182
  518450
  518733
  520734
  520738
  522636
  523361
  525249
  528538
  530777
  533319
  534283
  534685
  536774
  542618
  564201
  586460
  665004
  667826
  716895
  719926
  720003
  725621
  732002
  737573
  739870
  739877
  741436
  747605
  754170
  757324
  780906
  792558
  792570
  814941
  815724
  815926
  822254
]
18.37 ms
(9.21%)
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
  488931
  452292
  479703
  754170
  485158
  518733
  461744
  586460
  719926
  152234
  461738
  448501
  472180
  739870
  815724
  518182
  522636
  732002
  516291
  525249
  386304
  407136
  416797
  423633
  445626
  469599
  483571
  499812
  534685
  536774
  792558
  413047
  395715
  7196
  425004
  418952
  430701
  425767
  484791
  667826
  382330
  450988
  101894
  102334
  387946
  434392
  523361
  512534
  472553
  448705
  461732
  461748
  466696
  518450
  506304
  528538
  564201
  336584
  822254
  542618
  725621
  739877
  741436
  384524
  414581
  416200
  418028
  419751
  411227
  440680
  435496
  435731
  503693
  514071
  464162
  486182
  407148
  520734
  484785
  484797
  512532
  530777
  396527
  384420
  394760
  402869
  437509
  443578
  440618
  815926
  482626
  453335
  468731
  447301
  453333
  484506
  461756
  466588
  463829
  485094
  720003
  413485
  464430
  388849
  403577
  445499
  485165
  484503
  507804
  520738
  814941
  534283
  533319
  665004
  716895
  780906
  737573
  747605
  757324
  792570
]
3.58 ms
(1.79%)
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
  7196
  101894
  102334
  152234
  336584
  382330
  384420
  384524
  386304
  387946
  388849
  394760
  395715
  396527
  402869
  403577
  407136
  407148
  411227
  413047
  413485
  414581
  416200
  416797
  418028
  418952
  419751
  423633
  425004
  425767
  430701
  434392
  435496
  435731
  437509
  440618
  440680
  443578
  445499
  445626
  447301
  448501
  448705
  450988
  452292
  453333
  453335
  461732
  461738
  461744
  461748
  461756
  463829
  464162
  464430
  466588
  466696
  468731
  469599
  472180
  472553
  479703
  482626
  483571
  484503
  484506
  484785
  484791
  484797
  485094
  485158
  485165
  486182
  488931
  499812
  503693
  506304
  507804
  512532
  512534
  514071
  516291
  518182
  518450
  518733
  520734
  520738
  522636
  523361
  525249
  528538
  530777
  533319
  534283
  534685
  536774
  542618
  564201
  586460
  665004
  667826
  716895
  719926
  720003
  725621
  732002
  737573
  739870
  739877
  741436
  747605
  754170
  757324
  780906
  792558
  792570
  814941
  815724
  815926
  822254
]
2.41 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "белый и негритянка по%…"
]
1.69 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "белый чернокожая"
]
1.66 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "белый чернокожая"
]
1.51 ms
(0.76%)
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.