Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.62 ms
(83.59%)
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
  188169
  250422
  341596
  390571
  407015
  411402
  411844
  411918
  418182
  424451
  429518
  442852
  447045
  447969
  448640
  451519
  459673
  460596
  464963
  466718
  467977
  470254
  476905
  484094
  485320
  485984
  486787
  489060
  489071
  490520
  490598
  492460
  507858
  508807
  509218
  509262
  510092
  510873
  510901
  512962
  516466
  519013
  519192
  519754
  520665
  527136
  528762
  529313
  530130
  533454
  535403
  535694
  537330
  541366
  543689
  544322
  544432
  545046
  547039
  549391
  550150
  551971
  552016
  556774
  557144
  557450
  557469
  557492
  558111
  558810
  561027
  561999
  563241
  566716
  567163
  567595
  568147
  569762
  576707
  577285
  580387
  580841
  582435
  583197
  584020
  584380
  585268
  586161
  588083
  588151
  588242
  588973
  589573
  591027
  592128
  592287
  592460
  592637
  595173
  597123
  598375
  603397
  603431
  604182
  609651
  612490
  625686
  628559
  636141
  649175
  651684
  663429
  668794
  669214
  685472
  768837
  769386
  794274
  802905
  804420
]
16.12 ms
(9.58%)
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
  451519
  464963
  584380
  418182
  467977
  484094
  510901
  550150
  580387
  545046
  588242
  604182
  250422
  460596
  509262
  509218
  508807
  556774
  669214
  589573
  625686
  537330
  566716
  668794
  584020
  592287
  636141
  512962
  651684
  583197
  442852
  447969
  580841
  588151
  429518
  535403
  486787
  551971
  557144
  592460
  528762
  533454
  535694
  557492
  557450
  558111
  543689
  544322
  547039
  563241
  577285
  552016
  557469
  561027
  567595
  588973
  591027
  592128
  603397
  592637
  628559
  595173
  609651
  768837
  804420
  603431
  649175
  459673
  612490
  411844
  411918
  407015
  448640
  510873
  576707
  424451
  489060
  490598
  341596
  541366
  188169
  470254
  519013
  489071
  544432
  685472
  569762
  588083
  585268
  794274
  769386
  411402
  567163
  390571
  447045
  516466
  490520
  527136
  529313
  510092
  485320
  561999
  558810
  663429
  597123
  476905
  466718
  485984
  492460
  519192
  520665
  519754
  507858
  530130
  549391
  568147
  598375
  586161
  802905
  582435
]
4.09 ms
(2.43%)
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
  188169
  250422
  341596
  390571
  407015
  411402
  411844
  411918
  418182
  424451
  429518
  442852
  447045
  447969
  448640
  451519
  459673
  460596
  464963
  466718
  467977
  470254
  476905
  484094
  485320
  485984
  486787
  489060
  489071
  490520
  490598
  492460
  507858
  508807
  509218
  509262
  510092
  510873
  510901
  512962
  516466
  519013
  519192
  519754
  520665
  527136
  528762
  529313
  530130
  533454
  535403
  535694
  537330
  541366
  543689
  544322
  544432
  545046
  547039
  549391
  550150
  551971
  552016
  556774
  557144
  557450
  557469
  557492
  558111
  558810
  561027
  561999
  563241
  566716
  567163
  567595
  568147
  569762
  576707
  577285
  580387
  580841
  582435
  583197
  584020
  584380
  585268
  586161
  588083
  588151
  588242
  588973
  589573
  591027
  592128
  592287
  592460
  592637
  595173
  597123
  598375
  603397
  603431
  604182
  609651
  612490
  625686
  628559
  636141
  649175
  651684
  663429
  668794
  669214
  685472
  768837
  769386
  794274
  802905
  804420
]
2.14 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "тетки с большими соск%…"
]
1.90 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин большие соск"
]
1.75 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.96%)
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.