Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.38 ms
(88.99%)
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
  172556
  172685
  385709
  389893
  391705
  395909
  420237
  518976
  521412
  527131
  537790
  555148
  591006
  591029
  591040
  591051
  591451
  591476
  591492
  591511
  591516
  591522
  591559
  602432
  619093
  625117
  627345
  627575
  628075
  629788
  634613
  634892
  641319
  642187
  642288
  642348
  642354
  642377
  659397
  670938
  671485
  672907
  675618
  675878
  682234
  685400
  685478
  685518
  685519
  689830
  695760
  703533
  703587
  705315
  705385
  705391
  706417
  716004
  716262
  717441
  717546
  720171
  723233
  724032
  726564
  727764
  732592
  736090
  736092
  737614
  740981
  741506
  741632
  742220
  742763
  744394
  745101
  745256
  748396
  750435
  753815
  754347
  757113
  757247
  762956
  763402
  764057
  777615
  778488
  778526
  780764
  782120
  783816
  787719
  789443
  789462
  789597
  790518
  792899
  793812
  796369
  796569
  799638
  800077
  800644
  800750
  801175
  801623
  802078
  802098
  803256
  804405
  805098
  805108
  805652
  806260
  808969
  810942
  811000
  812147
]
10.79 ms
(5.98%)
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
  670938
  685400
  685519
  703533
  716262
  717441
  672907
  675878
  685478
  689830
  695760
  703587
  705315
  706417
  717546
  659397
  671485
  675618
  685518
  705391
  716004
  555148
  625117
  634613
  634892
  591006
  591051
  591516
  591559
  602432
  642348
  642354
  642377
  591029
  591040
  591492
  591511
  628075
  629788
  641319
  642187
  642288
  591451
  591476
  591522
  619093
  627345
  627575
  778526
  783816
  792899
  793812
  799638
  800077
  801175
  805652
  777615
  780764
  787719
  789443
  796569
  800750
  801623
  802078
  802098
  805098
  805108
  808969
  724032
  737614
  741632
  745256
  750435
  757247
  762956
  789462
  803256
  810942
  812147
  740981
  726564
  744394
  748396
  753815
  763402
  764057
  727764
  742220
  745101
  754347
  732592
  736090
  736092
  741506
  742763
  757113
  705385
  720171
  723233
  778488
  782120
  789597
  790518
  796369
  800644
  804405
  806260
  811000
  172685
  172556
  395909
  385709
  391705
  420237
  389893
  537790
  682234
  518976
  521412
  527131
]
2.75 ms
(1.53%)
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
  172556
  172685
  385709
  389893
  391705
  395909
  420237
  518976
  521412
  527131
  537790
  555148
  591006
  591029
  591040
  591051
  591451
  591476
  591492
  591511
  591516
  591522
  591559
  602432
  619093
  625117
  627345
  627575
  628075
  629788
  634613
  634892
  641319
  642187
  642288
  642348
  642354
  642377
  659397
  670938
  671485
  672907
  675618
  675878
  682234
  685400
  685478
  685518
  685519
  689830
  695760
  703533
  703587
  705315
  705385
  705391
  706417
  716004
  716262
  717441
  717546
  720171
  723233
  724032
  726564
  727764
  732592
  736090
  736092
  737614
  740981
  741506
  741632
  742220
  742763
  744394
  745101
  745256
  748396
  750435
  753815
  754347
  757113
  757247
  762956
  763402
  764057
  777615
  778488
  778526
  780764
  782120
  783816
  787719
  789443
  789462
  789597
  790518
  792899
  793812
  796369
  796569
  799638
  800077
  800644
  800750
  801175
  801623
  802078
  802098
  803256
  804405
  805098
  805108
  805652
  806260
  808969
  810942
  811000
  812147
]
1.77 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "кухн"
]
1.74 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кухн"
]
1.63 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.17 ms
(0.65%)
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.