Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.50 ms
(82.82%)
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
  154240
  365924
  379600
  381884
  381903
  382057
  383700
  383912
  388722
  389044
  392750
  395134
  395643
  397807
  398174
  398530
  398954
  403324
  405954
  407365
  407376
  408318
  411198
  411345
  411352
  414601
  417865
  422298
  429084
  432568
  439752
  440997
  441124
  444145
  449082
  450117
  450143
  450286
  452940
  453269
  453313
  454247
  457515
  457989
  458000
  460175
  460746
  460757
  460906
  465546
  465834
  466206
  466801
  467279
  467469
  469106
  469355
  469372
  469575
  470158
  471696
  474080
  474113
  475842
  476284
  477961
  478378
  479073
  479100
  479102
  479103
  479145
  481881
  482525
  483655
  484160
  484564
  484632
  484686
  485454
  487338
  488959
  490197
  491989
  495881
  497205
  502929
  508451
  513845
  514445
  515841
  515910
  516227
  516470
  516483
  516562
  526039
  526736
  526745
  526832
  529367
  533534
  533607
  546715
  560391
  563066
  563173
  569943
  580340
  589656
  590347
  591284
  591977
  605409
  618793
  620098
  665446
  741764
  751627
  815095
]
17.53 ms
(11.21%)
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
  466801
  475842
  533607
  460175
  469575
  474080
  563066
  563173
  569943
  546715
  591977
  741764
  411352
  457515
  479102
  411345
  439752
  452940
  454247
  460906
  467279
  476284
  403324
  460757
  467469
  469372
  474113
  477961
  479145
  379600
  388722
  444145
  458000
  465834
  466206
  479073
  479100
  479103
  450286
  470158
  478378
  516470
  516562
  483655
  526745
  526832
  484564
  487338
  488959
  490197
  491989
  497205
  502929
  516483
  484686
  514445
  515841
  515910
  392750
  441124
  422298
  815095
  450143
  495881
  484160
  665446
  590347
  751627
  469106
  398954
  365924
  408318
  414601
  460746
  482525
  580340
  620098
  453313
  469355
  481881
  508451
  516227
  529367
  513845
  533534
  526736
  429084
  485454
  560391
  589656
  591284
  605409
  618793
  484632
  526039
  432568
  465546
  383700
  383912
  154240
  395134
  395643
  381884
  381903
  382057
  389044
  397807
  398174
  398530
  405954
  417865
  407365
  407376
  411198
  440997
  450117
  453269
  457989
  471696
  449082
]
2.51 ms
(1.60%)
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
  154240
  365924
  379600
  381884
  381903
  382057
  383700
  383912
  388722
  389044
  392750
  395134
  395643
  397807
  398174
  398530
  398954
  403324
  405954
  407365
  407376
  408318
  411198
  411345
  411352
  414601
  417865
  422298
  429084
  432568
  439752
  440997
  441124
  444145
  449082
  450117
  450143
  450286
  452940
  453269
  453313
  454247
  457515
  457989
  458000
  460175
  460746
  460757
  460906
  465546
  465834
  466206
  466801
  467279
  467469
  469106
  469355
  469372
  469575
  470158
  471696
  474080
  474113
  475842
  476284
  477961
  478378
  479073
  479100
  479102
  479103
  479145
  481881
  482525
  483655
  484160
  484564
  484632
  484686
  485454
  487338
  488959
  490197
  491989
  495881
  497205
  502929
  508451
  513845
  514445
  515841
  515910
  516227
  516470
  516483
  516562
  526039
  526736
  526745
  526832
  529367
  533534
  533607
  546715
  560391
  563066
  563173
  569943
  580340
  589656
  590347
  591284
  591977
  605409
  618793
  620098
  665446
  741764
  751627
  815095
]
1.79 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "женскийрод mature"
]
1.78 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bitch mature"
]
1.54 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "женскийрод mature"
]

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.