Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
181.78 ms
(89.21%)
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
  321277
  389283
  413131
  413641
  423584
  423673
  425359
  428267
  428888
  431639
  444428
  447853
  454195
  467978
  487275
  490692
  491862
  492440
  502205
  506310
  513743
  514047
  517693
  518601
  521999
  525822
  528871
  528881
  530635
  532399
  533185
  536528
  537872
  541180
  541468
  542880
  547028
  549226
  553440
  561887
  563902
  563916
  565111
  569199
  574318
  574706
  576572
  582444
  584038
  587559
  592930
  597857
  598338
  601194
  607676
  607685
  613163
  615964
  622733
  623338
  623811
  626253
  626263
  627076
  631740
  633120
  633830
  635230
  638183
  638477
  642045
  643018
  644876
  662847
  663984
  664835
  664967
  667574
  668620
  668809
  669346
  669786
  673719
  700042
  701713
  706250
  710536
  715865
  720434
  722330
  722519
  723728
  738371
  738475
  742033
  770237
  774908
  775773
  780653
  781898
  782007
  788166
  788255
  788858
  790326
  791961
  797308
  799542
  802416
  802701
  803373
  804445
  804504
  806301
  806959
  806983
  807390
  807402
  810704
  811275
]
11.99 ms
(5.89%)
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
  613163
  638183
  775773
  423673
  514047
  492440
  530635
  533185
  547028
  541468
  574706
  413131
  513743
  669786
  715865
  633830
  774908
  804445
  806301
  806983
  810704
  701713
  782007
  807402
  321277
  807390
  521999
  491862
  467978
  506310
  517693
  528871
  518601
  584038
  553440
  574318
  662847
  592930
  627076
  598338
  797308
  770237
  622733
  423584
  536528
  710536
  700042
  642045
  791961
  802416
  788166
  723728
  738371
  742033
  706250
  806959
  428888
  413641
  431639
  428267
  528881
  541180
  542880
  563916
  664967
  667574
  576572
  623811
  790326
  804504
  615964
  738475
  389283
  669346
  587559
  788858
  487275
  561887
  673719
  720434
  722519
  633120
  638477
  803373
  811275
  623338
  788255
  425359
  444428
  582444
  663984
  549226
  597857
  644876
  447853
  454195
  490692
  537872
  525822
  532399
  502205
  565111
  569199
  722330
  664835
  668809
  668620
  563902
  607676
  631740
  607685
  626263
  635230
  643018
  601194
  626253
  780653
  781898
  799542
  802701
]
3.02 ms
(1.48%)
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
  321277
  389283
  413131
  413641
  423584
  423673
  425359
  428267
  428888
  431639
  444428
  447853
  454195
  467978
  487275
  490692
  491862
  492440
  502205
  506310
  513743
  514047
  517693
  518601
  521999
  525822
  528871
  528881
  530635
  532399
  533185
  536528
  537872
  541180
  541468
  542880
  547028
  549226
  553440
  561887
  563902
  563916
  565111
  569199
  574318
  574706
  576572
  582444
  584038
  587559
  592930
  597857
  598338
  601194
  607676
  607685
  613163
  615964
  622733
  623338
  623811
  626253
  626263
  627076
  631740
  633120
  633830
  635230
  638183
  638477
  642045
  643018
  644876
  662847
  663984
  664835
  664967
  667574
  668620
  668809
  669346
  669786
  673719
  700042
  701713
  706250
  710536
  715865
  720434
  722330
  722519
  723728
  738371
  738475
  742033
  770237
  774908
  775773
  780653
  781898
  782007
  788166
  788255
  788858
  790326
  791961
  797308
  799542
  802416
  802701
  803373
  804445
  804504
  806301
  806959
  806983
  807390
  807402
  810704
  811275
]
2.04 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "огромные сиськ boobs"
]
1.76 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "huge tits boobs"
]
1.43 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.