Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.42 ms
(82.65%)
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
  76074
  385448
  387711
  397406
  397917
  405950
  411382
  418426
  420067
  421544
  423487
  424012
  439049
  449389
  449628
  450030
  450044
  451702
  452328
  457780
  462029
  463747
  468239
  468712
  471092
  471929
  488046
  505384
  506067
  510679
  515307
  526152
  528128
  532310
  533333
  545493
  550294
  550482
  551660
  552336
  554260
  555393
  557377
  557915
  563424
  563633
  564065
  564358
  564617
  568750
  569118
  571722
  572742
  575878
  583435
  584563
  585569
  587487
  588033
  592027
  593599
  604799
  610233
  615685
  616117
  619092
  619445
  625753
  634314
  654376
  677361
  717837
  722222
  730349
  733195
  737893
  746136
  757751
  760514
  762252
  762380
  765340
  765513
  766025
  766592
  766637
  769209
  770313
  770784
  771560
  774794
  775541
  776915
  777605
  778375
  780950
  781460
  788430
  792100
  792259
  792604
  795076
  795092
  798635
  800562
  801260
  801640
  802028
  803078
  803415
  803960
  804751
  805044
  806397
  807547
  808101
  811123
  813122
  817444
  817733
]
19.23 ms
(11.32%)
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
  800562
  766637
  765513
  770784
  778375
  654376
  805044
  424012
  76074
  397917
  439049
  506067
  515307
  532310
  592027
  798635
  774794
  450044
  616117
  468239
  781460
  463747
  510679
  585569
  397406
  411382
  564358
  722222
  788430
  795076
  765340
  760514
  777605
  387711
  462029
  625753
  468712
  552336
  593599
  813122
  766592
  584563
  568750
  554260
  615685
  817733
  451702
  545493
  604799
  802028
  769209
  806397
  762252
  766025
  776915
  780950
  420067
  730349
  757751
  762380
  555393
  610233
  488046
  421544
  450030
  449389
  572742
  775541
  792259
  795092
  803960
  807547
  808101
  792604
  557915
  563424
  811123
  557377
  677361
  452328
  717837
  792100
  804751
  801640
  423487
  471929
  550482
  471092
  550294
  564065
  583435
  733195
  526152
  528128
  571722
  569118
  587487
  385448
  405950
  619445
  737893
  505384
  533333
  551660
  803078
  801260
  817444
  771560
  770313
  418426
  449628
  457780
  575878
  563633
  619092
  588033
  746136
  564617
  634314
  803415
]
3.89 ms
(2.29%)
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
  76074
  385448
  387711
  397406
  397917
  405950
  411382
  418426
  420067
  421544
  423487
  424012
  439049
  449389
  449628
  450030
  450044
  451702
  452328
  457780
  462029
  463747
  468239
  468712
  471092
  471929
  488046
  505384
  506067
  510679
  515307
  526152
  528128
  532310
  533333
  545493
  550294
  550482
  551660
  552336
  554260
  555393
  557377
  557915
  563424
  563633
  564065
  564358
  564617
  568750
  569118
  571722
  572742
  575878
  583435
  584563
  585569
  587487
  588033
  592027
  593599
  604799
  610233
  615685
  616117
  619092
  619445
  625753
  634314
  654376
  677361
  717837
  722222
  730349
  733195
  737893
  746136
  757751
  760514
  762252
  762380
  765340
  765513
  766025
  766592
  766637
  769209
  770313
  770784
  771560
  774794
  775541
  776915
  777605
  778375
  780950
  781460
  788430
  792100
  792259
  792604
  795076
  795092
  798635
  800562
  801260
  801640
  802028
  803078
  803415
  803960
  804751
  805044
  806397
  807547
  808101
  811123
  813122
  817444
  817733
]
2.01 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sperm sex"
]
1.47 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм секс"
]
1.33 ms
(0.78%)
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.