Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
117.45 ms
(83.58%)
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
  34146
  43271
  118226
  213118
  236765
  265746
  326115
  361978
  383160
  387227
  388440
  395724
  396906
  401204
  403049
  404602
  406322
  408306
  409886
  409948
  411381
  413645
  414368
  415591
  418478
  418761
  420215
  422182
  423120
  424119
  429741
  430315
  430602
  432154
  432799
  435651
  440193
  448932
  450658
  451886
  453683
  454017
  454501
  455496
  456437
  456697
  460624
  462777
  463980
  464969
  466278
  469371
  469396
  469582
  470232
  470722
  471126
  474069
  476351
  477550
  478374
  478544
  482361
  486217
  487362
  489423
  491938
  497708
  511830
  517932
  520744
  531533
  549171
  571241
  571998
  581932
  612927
  612977
  626533
  633561
  636005
  636283
  651636
  694135
  715085
  718581
  720455
  720728
  724332
  725584
  727757
  728254
  732917
  733537
  733913
  735459
  740599
  761674
  770454
  770501
  779750
  803498
  804010
  810813
  813255
  814874
  815250
  815456
  815521
  815665
  815765
  816237
  816295
  816405
  816650
  817116
  817383
  818349
  818613
  822815
]
12.68 ms
(9.02%)
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
  732917
  422182
  213118
  456697
  118226
  814874
  815665
  822815
  815456
  816237
  816405
  818349
  815250
  815521
  816295
  817116
  818613
  815765
  531533
  694135
  651636
  720728
  810813
  724332
  728254
  733537
  740599
  735459
  482361
  420215
  418478
  409886
  456437
  236765
  408306
  486217
  571241
  409948
  469582
  395724
  326115
  470232
  430315
  549171
  581932
  396906
  404602
  817383
  816650
  477550
  715085
  612927
  636005
  626533
  779750
  733913
  761674
  804010
  770454
  34146
  423120
  440193
  413645
  432154
  636283
  511830
  387227
  265746
  464969
  463980
  770501
  43271
  466278
  478374
  491938
  720455
  403049
  487362
  430602
  401204
  489423
  571998
  476351
  727757
  388440
  718581
  454017
  471126
  460624
  469371
  361978
  451886
  813255
  450658
  424119
  462777
  414368
  520744
  406322
  453683
  725584
  497708
  474069
  803498
  470722
  432799
  469396
  478544
  415591
  429741
  455496
  448932
  435651
  633561
  454501
  517932
  411381
  418761
  383160
  612977
]
3.16 ms
(2.25%)
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
  34146
  43271
  118226
  213118
  236765
  265746
  326115
  361978
  383160
  387227
  388440
  395724
  396906
  401204
  403049
  404602
  406322
  408306
  409886
  409948
  411381
  413645
  414368
  415591
  418478
  418761
  420215
  422182
  423120
  424119
  429741
  430315
  430602
  432154
  432799
  435651
  440193
  448932
  450658
  451886
  453683
  454017
  454501
  455496
  456437
  456697
  460624
  462777
  463980
  464969
  466278
  469371
  469396
  469582
  470232
  470722
  471126
  474069
  476351
  477550
  478374
  478544
  482361
  486217
  487362
  489423
  491938
  497708
  511830
  517932
  520744
  531533
  549171
  571241
  571998
  581932
  612927
  612977
  626533
  633561
  636005
  636283
  651636
  694135
  715085
  718581
  720455
  720728
  724332
  725584
  727757
  728254
  732917
  733537
  733913
  735459
  740599
  761674
  770454
  770501
  779750
  803498
  804010
  810813
  813255
  814874
  815250
  815456
  815521
  815665
  815765
  816237
  816295
  816405
  816650
  817116
  817383
  818349
  818613
  822815
]
2.02 ms
(1.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мамка делает миньет"
]
1.83 ms
(1.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин минет оральн секс"
]
1.66 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.