Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.02 ms
(85.37%)
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
  116603
  382527
  382585
  386204
  386756
  388673
  390592
  399004
  401287
  410811
  429755
  462033
  462121
  515751
  528898
  542951
  543830
  546843
  548668
  548743
  550408
  550453
  550738
  551319
  552251
  552935
  557261
  558076
  559020
  559219
  559867
  559902
  560566
  560755
  562293
  562310
  562321
  566029
  566711
  568852
  569850
  569879
  569883
  570010
  570232
  570264
  570494
  570505
  570552
  570566
  571654
  571908
  571909
  572521
  573417
  573606
  573663
  573673
  573681
  573712
  573770
  573772
  573791
  574812
  575059
  575064
  575085
  575100
  575202
  575755
  576057
  576060
  576305
  576361
  576366
  576410
  578082
  578393
  580757
  581668
  586595
  591866
  597078
  597114
  598547
  599107
  603679
  609905
  620626
  621451
  622399
  624835
  629029
  645946
  654178
  656071
  656701
  657293
  658364
  659524
  659529
  659844
  660471
  660546
  660568
  661270
  668865
  671115
  671325
  683905
  702432
  715453
  722848
  723487
  735812
  740215
  742195
  746146
  748667
  814578
]
12.99 ms
(8.28%)
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
  740215
  657293
  388673
  401287
  116603
  429755
  742195
  645946
  671325
  386756
  814578
  569883
  656701
  658364
  660568
  668865
  660471
  659529
  659844
  735812
  609905
  603679
  629029
  574812
  570505
  382527
  683905
  386204
  390592
  462033
  462121
  598547
  551319
  566711
  557261
  559902
  571908
  715453
  660546
  659524
  552935
  550453
  559020
  562310
  570494
  571909
  572521
  575064
  560566
  562293
  571654
  573681
  573712
  575085
  575202
  576057
  542951
  543830
  550408
  558076
  570010
  570264
  573791
  576305
  576361
  566029
  569850
  570566
  573770
  578082
  580757
  597078
  599107
  656071
  410811
  548668
  548743
  573772
  575100
  576366
  576410
  573663
  560755
  562321
  570232
  573606
  723487
  671115
  654178
  661270
  568852
  621451
  748667
  552251
  550738
  702432
  569879
  570552
  573673
  597114
  528898
  559219
  559867
  591866
  622399
  624835
  586595
  399004
  620626
  746146
  722848
  382585
  515751
  573417
  575755
  578393
  575059
  576060
  581668
  546843
]
2.66 ms
(1.70%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.26 ms
(1.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "small tits sex"
]
2.13 ms
(1.36%)
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
  116603
  382527
  382585
  386204
  386756
  388673
  390592
  399004
  401287
  410811
  429755
  462033
  462121
  515751
  528898
  542951
  543830
  546843
  548668
  548743
  550408
  550453
  550738
  551319
  552251
  552935
  557261
  558076
  559020
  559219
  559867
  559902
  560566
  560755
  562293
  562310
  562321
  566029
  566711
  568852
  569850
  569879
  569883
  570010
  570232
  570264
  570494
  570505
  570552
  570566
  571654
  571908
  571909
  572521
  573417
  573606
  573663
  573673
  573681
  573712
  573770
  573772
  573791
  574812
  575059
  575064
  575085
  575100
  575202
  575755
  576057
  576060
  576305
  576361
  576366
  576410
  578082
  578393
  580757
  581668
  586595
  591866
  597078
  597114
  598547
  599107
  603679
  609905
  620626
  621451
  622399
  624835
  629029
  645946
  654178
  656071
  656701
  657293
  658364
  659524
  659529
  659844
  660471
  660546
  660568
  661270
  668865
  671115
  671325
  683905
  702432
  715453
  722848
  723487
  735812
  740215
  742195
  746146
  748667
  814578
]
1.57 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "маленькая сиськ секс"
]
1.34 ms
(0.86%)
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.