Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
213.13 ms
(52.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сиськ огромный"
]
163.19 ms
(39.90%)
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
  154463
  191835
  383564
  385053
  394767
  404698
  409060
  413392
  415591
  415905
  416522
  416539
  416626
  416677
  416681
  416699
  420658
  421369
  423784
  427027
  427457
  429799
  430559
  434376
  436132
  439151
  439653
  442430
  443257
  448199
  448696
  455915
  458001
  459111
  462079
  465008
  467633
  472622
  473453
  474506
  483705
  491497
  495568
  500288
  500748
  516619
  516676
  518550
  529078
  530480
  530953
  533809
  534772
  542707
  545392
  545454
  548310
  550282
  552069
  561038
  561040
  569258
  569302
  580727
  583358
  584301
  587987
  589191
  591427
  595847
  598406
  608550
  609885
  609890
  614957
  615921
  619802
  621796
  624921
  624942
  627147
  630091
  630420
  658703
  660412
  660416
  664149
  664575
  665421
  669067
  669079
  669386
  671044
  671045
  672939
  678713
  683533
  708451
  717035
  718678
  737736
  739125
  739127
  739585
  745384
  754178
  761378
  761394
  775107
  786621
  789362
  792274
  792553
  792558
  801008
  801495
  801739
  802179
  803333
]
23.00 ms
(5.62%)
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
  427027
  473453
  542707
  545392
  552069
  394767
  416677
  569258
  383564
  385053
  409060
  416699
  427457
  472622
  516619
  516676
  530953
  534772
  467633
  672939
  660412
  671045
  583358
  608550
  591427
  739125
  792553
  442430
  423784
  529078
  416626
  420658
  416681
  455915
  678713
  609890
  619802
  627147
  630091
  413392
  416539
  439151
  495568
  500288
  587987
  443257
  474506
  154463
  415591
  416522
  448199
  483705
  545454
  671044
  660416
  664149
  669067
  550282
  561040
  609885
  615921
  630420
  459111
  518550
  595847
  439653
  462079
  429799
  500748
  569302
  580727
  621796
  598406
  434376
  415905
  717035
  789362
  739127
  458001
  530480
  561038
  718678
  669079
  669386
  614957
  624942
  630427
  792558
  436132
  421369
  430559
  465008
  584301
  745384
  658703
  683533
  803333
  754178
  761394
  786621
  792274
  739585
  801739
  404698
  491497
  624921
  448696
  775107
  665421
  589191
  801008
  737736
  191835
  533809
  664575
  548310
  801495
  802179
  708451
  761378
]
3.30 ms
(0.81%)
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
  154463
  191835
  383564
  385053
  394767
  404698
  409060
  413392
  415591
  415905
  416522
  416539
  416626
  416677
  416681
  416699
  420658
  421369
  423784
  427027
  427457
  429799
  430559
  434376
  436132
  439151
  439653
  442430
  443257
  448199
  448696
  455915
  458001
  459111
  462079
  465008
  467633
  472622
  473453
  474506
  483705
  491497
  495568
  500288
  500748
  516619
  516676
  518550
  529078
  530480
  530953
  533809
  534772
  542707
  545392
  545454
  548310
  550282
  552069
  561038
  561040
  569258
  569302
  580727
  583358
  584301
  587987
  589191
  591427
  595847
  598406
  608550
  609885
  609890
  614957
  615921
  619802
  621796
  624921
  624942
  627147
  630091
  630420
  658703
  660412
  660416
  664149
  664575
  665421
  669067
  669079
  669386
  671044
  671045
  672939
  678713
  683533
  708451
  717035
  718678
  737736
  739125
  739127
  739585
  745384
  754178
  761378
  761394
  775107
  786621
  789362
  792274
  792553
  792558
  801008
  801495
  801739
  802179
  803333
]
2.45 ms
(0.60%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.27 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "сиськи огромного"
]
1.64 ms
(0.40%)
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.