Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.86 ms
(85.05%)
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
  398300
  412725
  414130
  415354
  416037
  416613
  419816
  420432
  427914
  439218
  445135
  445180
  446641
  451727
  452567
  454725
  456608
  458628
  478029
  512486
  542711
  548218
  548957
  550813
  551556
  564520
  565480
  568271
  568471
  574178
  577381
  583992
  584558
  585827
  590795
  597085
  598141
  598549
  600044
  601153
  619612
  626196
  627412
  632296
  634067
  641774
  643671
  648395
  648527
  656173
  656907
  657565
  658785
  658796
  660579
  667976
  668303
  673947
  674491
  675858
  678964
  680791
  686511
  690296
  700259
  716036
  735248
  735260
  739390
  740357
  740384
  740817
  740931
  743903
  745107
  745609
  747328
  749202
  749268
  751040
  751417
  761646
  765569
  766087
  767416
  769325
  770219
  770258
  770377
  775240
  778395
  778731
  782443
  782548
  782731
  782808
  783043
  785250
  785591
  786899
  791127
  791337
  792871
  793115
  793280
  795407
  798667
  799759
  799837
  803387
  804638
  804939
  806687
  806924
  807341
  808978
  811676
  812476
  812500
  818551
]
12.61 ms
(8.87%)
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
  414130
  416613
  456608
  451727
  675858
  584558
  619612
  598141
  785591
  446641
  445135
  452567
  419816
  439218
  512486
  658796
  747328
  427914
  478029
  454725
  565480
  577381
  542711
  568471
  804638
  420432
  416037
  398300
  445180
  412725
  818551
  458628
  568271
  574178
  583992
  551556
  564520
  648527
  656173
  668303
  648395
  657565
  658785
  660579
  667976
  673947
  680791
  690296
  656907
  674491
  678964
  686511
  700259
  716036
  548218
  548957
  550813
  597085
  600044
  585827
  626196
  634067
  643671
  598549
  590795
  601153
  627412
  632296
  641774
  775240
  782443
  782731
  782808
  786899
  798667
  799759
  807341
  812500
  778395
  785250
  792871
  793115
  806924
  808978
  811676
  812476
  739390
  740357
  743903
  749202
  751040
  761646
  766087
  782548
  791127
  791337
  795407
  799837
  803387
  804939
  806687
  740817
  745609
  751417
  769325
  770258
  770377
  740384
  740931
  745107
  765569
  767416
  770219
  735248
  735260
  749268
  778731
  783043
  793280
  415354
]
2.06 ms
(1.45%)
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
  398300
  412725
  414130
  415354
  416037
  416613
  419816
  420432
  427914
  439218
  445135
  445180
  446641
  451727
  452567
  454725
  456608
  458628
  478029
  512486
  542711
  548218
  548957
  550813
  551556
  564520
  565480
  568271
  568471
  574178
  577381
  583992
  584558
  585827
  590795
  597085
  598141
  598549
  600044
  601153
  619612
  626196
  627412
  632296
  634067
  641774
  643671
  648395
  648527
  656173
  656907
  657565
  658785
  658796
  660579
  667976
  668303
  673947
  674491
  675858
  678964
  680791
  686511
  690296
  700259
  716036
  735248
  735260
  739390
  740357
  740384
  740817
  740931
  743903
  745107
  745609
  747328
  749202
  749268
  751040
  751417
  761646
  765569
  766087
  767416
  769325
  770219
  770258
  770377
  775240
  778395
  778731
  782443
  782548
  782731
  782808
  783043
  785250
  785591
  786899
  791127
  791337
  792871
  793115
  793280
  795407
  798667
  799759
  799837
  803387
  804638
  804939
  806687
  806924
  807341
  808978
  811676
  812476
  812500
  818551
]
1.82 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo teen toys"
]
1.73 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "соло teen toys"
]
1.57 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло teen toys"
]
1.45 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.