Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.16 ms
(86.10%)
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
  428239
  443668
  448011
  461090
  484464
  488231
  493079
  504187
  516844
  518291
  529152
  529467
  536043
  536146
  541013
  542082
  542179
  548912
  551608
  551622
  553673
  554741
  554795
  563982
  570262
  573115
  582934
  583314
  584722
  584932
  586665
  591753
  600583
  601219
  605186
  606389
  608488
  621725
  622780
  624762
  626133
  626579
  627455
  627617
  628261
  631056
  634958
  635590
  650126
  674119
  677581
  682865
  690179
  694595
  694930
  697934
  702908
  703279
  707155
  707766
  708505
  709396
  709738
  716418
  719208
  720484
  720595
  722688
  723073
  728171
  728814
  729842
  730102
  730341
  731762
  735307
  741425
  742139
  742604
  747961
  749101
  749176
  752111
  753339
  757200
  758012
  764811
  768555
  768745
  771805
  773187
  774711
  777625
  778953
  779716
  780052
  782047
  784060
  788840
  788918
  789288
  789938
  791371
  792964
  793005
  793123
  795472
  795673
  799892
  802073
  802976
  803367
  806833
  807670
  810565
  810814
  813595
  818912
  819841
]
14.50 ms
(8.04%)
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
  583314
  584932
  606389
  626133
  628261
  600583
  621725
  622780
  626579
  627455
  591753
  608488
  601219
  627617
  774711
  784060
  795673
  799892
  803367
  777625
  779716
  780052
  788918
  789938
  793005
  795472
  810565
  810814
  749176
  752111
  757200
  758820
  773187
  782047
  788840
  793123
  806833
  807670
  728171
  731762
  742139
  749101
  768555
  730102
  728814
  729842
  730341
  741425
  747961
  753339
  758012
  768745
  735307
  742604
  764811
  771805
  605186
  631056
  634958
  635590
  702908
  703279
  707155
  707766
  709396
  778953
  789288
  791371
  792964
  802073
  802976
  542082
  584722
  624762
  461090
  553673
  586665
  518291
  443668
  428239
  818912
  819841
  813595
  448011
  484464
  488231
  504187
  529152
  529467
  536043
  536146
  516844
  493079
  548912
  551608
  541013
  542179
  551622
  554741
  554795
  563982
  570262
  573115
  582934
  650126
  677581
  682865
  694595
  716418
  719208
  690179
  694930
  708505
  720484
  720595
  722688
  723073
  674119
  697934
  709738
]
3.28 ms
(1.82%)
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
  428239
  443668
  448011
  461090
  484464
  488231
  493079
  504187
  516844
  518291
  529152
  529467
  536043
  536146
  541013
  542082
  542179
  548912
  551608
  551622
  553673
  554741
  554795
  563982
  570262
  573115
  582934
  583314
  584722
  584932
  586665
  591753
  600583
  601219
  605186
  606389
  608488
  621725
  622780
  624762
  626133
  626579
  627455
  627617
  628261
  631056
  634958
  635590
  650126
  674119
  677581
  682865
  690179
  694595
  694930
  697934
  702908
  703279
  707155
  707766
  708505
  709396
  709738
  716418
  719208
  720484
  720595
  722688
  723073
  728171
  728814
  729842
  730102
  730341
  731762
  735307
  741425
  742139
  742604
  747961
  749101
  749176
  752111
  753339
  757200
  758012
  764811
  768555
  768745
  771805
  773187
  774711
  777625
  778953
  779716
  780052
  782047
  784060
  788840
  788918
  789288
  789938
  791371
  792964
  793005
  793123
  795472
  795673
  799892
  802073
  802976
  803367
  806833
  807670
  810565
  810814
  813595
  818912
  819841
]
2.06 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny cum"
]
1.75 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые cum"
]
1.72 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худые cum"
]

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.