Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.31 ms
(83.44%)
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
  338311
  386782
  390021
  390209
  391110
  397037
  406206
  410967
  414973
  418949
  423584
  426777
  427550
  430811
  454677
  456849
  462870
  464955
  469827
  472169
  475082
  480368
  489958
  492266
  495259
  505534
  505836
  509278
  519713
  520253
  523219
  527065
  530730
  530777
  539609
  541618
  542737
  545394
  548601
  549695
  550585
  563079
  565985
  570218
  571819
  586590
  586678
  596051
  598268
  599674
  606396
  608359
  609780
  610241
  610255
  625928
  639310
  644091
  647645
  650338
  661873
  663088
  665840
  672554
  674035
  674751
  676421
  676538
  676575
  678910
  680580
  680745
  682741
  688333
  690179
  693302
  693643
  697311
  704987
  707324
  710807
  716897
  724502
  724553
  727684
  731014
  731898
  732422
  740036
  741625
  746141
  756400
  769584
  770181
  773131
  774761
  775770
  777782
  779738
  779817
  780565
  782729
  786428
  786549
  787435
  788290
  789760
  794238
  798968
  799402
  799727
  801526
  804594
  811237
  811390
  814293
  814797
  814837
  814847
  815542
]
17.28 ms
(9.99%)
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
  672554
  693643
  596051
  606396
  608359
  386782
  625928
  814837
  814847
  542737
  688333
  495259
  390021
  410967
  815542
  680745
  690179
  565985
  798968
  794238
  756400
  799727
  811390
  741625
  732422
  710807
  464955
  426777
  727684
  427550
  489958
  456849
  682741
  338311
  539609
  779817
  786549
  505836
  480368
  530777
  545394
  549695
  665840
  676538
  647645
  650338
  680580
  811237
  789760
  724502
  731898
  724553
  492266
  520253
  571819
  423584
  814797
  814293
  469827
  550585
  570218
  663088
  697311
  609780
  787435
  731014
  780565
  475082
  472169
  563079
  414973
  430811
  586590
  530730
  548601
  704987
  707324
  390209
  678910
  774761
  779738
  788290
  773131
  770181
  777782
  391110
  418949
  541618
  674035
  674751
  693302
  610241
  586678
  598268
  775770
  746141
  769584
  527065
  676575
  599674
  639310
  782729
  804594
  801526
  716897
  661873
  519713
  676421
  644091
  397037
  462870
  523219
  505534
  740036
  454677
  406206
  610255
  509278
  786428
  799402
]
3.80 ms
(2.20%)
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
  338311
  386782
  390021
  390209
  391110
  397037
  406206
  410967
  414973
  418949
  423584
  426777
  427550
  430811
  454677
  456849
  462870
  464955
  469827
  472169
  475082
  480368
  489958
  492266
  495259
  505534
  505836
  509278
  519713
  520253
  523219
  527065
  530730
  530777
  539609
  541618
  542737
  545394
  548601
  549695
  550585
  563079
  565985
  570218
  571819
  586590
  586678
  596051
  598268
  599674
  606396
  608359
  609780
  610241
  610255
  625928
  639310
  644091
  647645
  650338
  661873
  663088
  665840
  672554
  674035
  674751
  676421
  676538
  676575
  678910
  680580
  680745
  682741
  688333
  690179
  693302
  693643
  697311
  704987
  707324
  710807
  716897
  724502
  724553
  727684
  731014
  731898
  732422
  740036
  741625
  746141
  756400
  769584
  770181
  773131
  774761
  775770
  777782
  779738
  779817
  780565
  782729
  786428
  786549
  787435
  788290
  789760
  794238
  798968
  799402
  799727
  801526
  804594
  811237
  811390
  814293
  814797
  814837
  814847
  815542
]
2.06 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big boobs massage"
]
1.84 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие boobs массаж"
]
1.83 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие boobs массаж"
]

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.