Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.10 ms
(83.11%)
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
  396168
  451832
  453121
  460212
  464385
  465234
  468065
  474916
  477335
  481844
  484418
  487435
  488120
  489893
  491497
  498047
  504759
  512433
  515184
  516472
  516970
  517784
  518768
  519087
  519769
  519993
  520008
  520346
  520728
  521526
  523780
  524542
  525525
  525745
  526248
  527124
  527243
  527414
  534320
  537686
  542550
  547730
  551454
  552874
  553054
  555081
  556835
  557083
  558046
  558523
  559120
  560648
  561296
  562487
  563211
  563929
  564636
  564740
  565170
  565786
  566703
  567139
  568357
  569559
  575144
  576058
  576089
  578008
  578396
  580151
  586485
  587377
  589716
  590601
  590989
  591118
  591141
  591783
  591784
  595449
  595489
  596365
  597503
  598118
  598807
  598838
  599392
  599483
  599514
  600149
  600570
  600987
  601886
  602003
  603077
  604085
  608395
  608416
  608560
  612348
  615979
  618525
  620546
  621449
  622223
  624833
  624859
  625414
  625913
  627097
  637030
  653213
  653463
  654464
  659035
  659905
  676472
  677698
  677973
  679076
]
19.79 ms
(11.42%)
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
  608395
  521526
  519087
  653463
  555081
  557083
  563211
  604085
  526248
  484418
  520728
  527243
  453121
  474916
  481844
  591118
  527414
  598838
  625913
  653213
  615979
  600987
  602003
  551454
  565170
  598118
  580151
  637030
  477335
  659035
  677973
  654464
  518768
  523780
  464385
  519993
  520008
  525525
  465234
  468065
  517784
  516970
  519769
  488120
  566703
  618525
  553054
  562487
  595449
  504759
  563929
  677698
  586485
  587377
  591141
  600149
  460212
  512433
  625414
  515184
  567139
  547730
  558523
  564636
  556835
  565786
  624833
  624859
  591783
  600570
  558046
  598807
  622223
  621449
  608416
  627097
  559120
  537686
  487435
  491497
  676472
  542550
  597503
  608560
  578008
  552874
  568357
  576058
  569559
  560648
  596365
  590601
  590989
  564740
  451832
  612348
  575144
  534320
  527124
  601886
  396168
  589716
  516472
  599392
  576089
  599514
  561296
  659905
  591784
  599483
  489893
  520346
  525745
  524542
  578396
  679076
  620546
  595489
  603077
  498047
]
2.46 ms
(1.42%)
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
  396168
  451832
  453121
  460212
  464385
  465234
  468065
  474916
  477335
  481844
  484418
  487435
  488120
  489893
  491497
  498047
  504759
  512433
  515184
  516472
  516970
  517784
  518768
  519087
  519769
  519993
  520008
  520346
  520728
  521526
  523780
  524542
  525525
  525745
  526248
  527124
  527243
  527414
  534320
  537686
  542550
  547730
  551454
  552874
  553054
  555081
  556835
  557083
  558046
  558523
  559120
  560648
  561296
  562487
  563211
  563929
  564636
  564740
  565170
  565786
  566703
  567139
  568357
  569559
  575144
  576058
  576089
  578008
  578396
  580151
  586485
  587377
  589716
  590601
  590989
  591118
  591141
  591783
  591784
  595449
  595489
  596365
  597503
  598118
  598807
  598838
  599392
  599483
  599514
  600149
  600570
  600987
  601886
  602003
  603077
  604085
  608395
  608416
  608560
  612348
  615979
  618525
  620546
  621449
  622223
  624833
  624859
  625414
  625913
  627097
  637030
  653213
  653463
  654464
  659035
  659905
  676472
  677698
  677973
  679076
]
2.14 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "большой член в шортах"
]
1.68 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большой большие член в шорт"
]
1.66 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большой большие член в шорт"
]
1.56 ms
(0.90%)
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.