Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.55 ms
(82.39%)
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
  390139
  391861
  397905
  432324
  438536
  444911
  455366
  458999
  470260
  472362
  475871
  476535
  483878
  484014
  488134
  489994
  492978
  495968
  497858
  497993
  499527
  499750
  500037
  501969
  502260
  502852
  504558
  504665
  505083
  505762
  506112
  506719
  508255
  509250
  509607
  509614
  511848
  512647
  512760
  513276
  516360
  517247
  517362
  518091
  519394
  519434
  521991
  522305
  522334
  522583
  522956
  523943
  524215
  524576
  525294
  525489
  525571
  525581
  527300
  527618
  527894
  528490
  529523
  537819
  538199
  539356
  542940
  544043
  546529
  552151
  555092
  561247
  561419
  562298
  563679
  569433
  570004
  570269
  574000
  575694
  575796
  585895
  591236
  594608
  595384
  596997
  613301
  614682
  620659
  622796
  623991
  624081
  626182
  628661
  630296
  641026
  642237
  643573
  653234
  655539
  664470
  671245
  672489
  676438
  677848
  681522
  686585
  689798
  692073
  693327
  696070
  696769
  697135
  703589
  711655
  716195
  716378
  775538
  813593
  813612
]
17.48 ms
(11.12%)
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
  455366
  472362
  475871
  476535
  509250
  509614
  512647
  513276
  516360
  521991
  523943
  527618
  528490
  537819
  489994
  495968
  499527
  502852
  504665
  505083
  506112
  511848
  517362
  518091
  522305
  525294
  527894
  483878
  492978
  499750
  500037
  501969
  502260
  508255
  512760
  517247
  519434
  522583
  522956
  524576
  525571
  525581
  527300
  529523
  484014
  488134
  497858
  497993
  504558
  505762
  506719
  509607
  519394
  524215
  538199
  539356
  397905
  391861
  390139
  438536
  432324
  444911
  813593
  813612
  458999
  470260
  522334
  525489
  575796
  546529
  561247
  569433
  570004
  542940
  544043
  552151
  561419
  570269
  575694
  653234
  655539
  664470
  676438
  677848
  696769
  681522
  692073
  696070
  671245
  672489
  686585
  689798
  693327
  697135
  703589
  711655
  716195
  716378
  555092
  562298
  563679
  574000
  594608
  614682
  620659
  628661
  642237
  591236
  626182
  643573
  585895
  613301
  630296
  595384
  596997
  622796
  623991
  624081
  641026
  775538
]
3.11 ms
(1.98%)
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
  390139
  391861
  397905
  432324
  438536
  444911
  455366
  458999
  470260
  472362
  475871
  476535
  483878
  484014
  488134
  489994
  492978
  495968
  497858
  497993
  499527
  499750
  500037
  501969
  502260
  502852
  504558
  504665
  505083
  505762
  506112
  506719
  508255
  509250
  509607
  509614
  511848
  512647
  512760
  513276
  516360
  517247
  517362
  518091
  519394
  519434
  521991
  522305
  522334
  522583
  522956
  523943
  524215
  524576
  525294
  525489
  525571
  525581
  527300
  527618
  527894
  528490
  529523
  537819
  538199
  539356
  542940
  544043
  546529
  552151
  555092
  561247
  561419
  562298
  563679
  569433
  570004
  570269
  574000
  575694
  575796
  585895
  591236
  594608
  595384
  596997
  613301
  614682
  620659
  622796
  623991
  624081
  626182
  628661
  630296
  641026
  642237
  643573
  653234
  655539
  664470
  671245
  672489
  676438
  677848
  681522
  686585
  689798
  692073
  693327
  696070
  696769
  697135
  703589
  711655
  716195
  716378
  775538
  813593
  813612
]
2.13 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русскый рот"
]
1.68 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск рот"
]
1.66 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.