Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.56 ms
(82.57%)
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
  419264
  472883
  475510
  488510
  491583
  496458
  511061
  513966
  518425
  521636
  522436
  525173
  525855
  526794
  529113
  530458
  538514
  550668
  551962
  552584
  552653
  554260
  556104
  556791
  557567
  559729
  562482
  562975
  563330
  564354
  564679
  566331
  566334
  566585
  567040
  568531
  572707
  578796
  579220
  579873
  583513
  584034
  584563
  586010
  586853
  588900
  591816
  591874
  591938
  592146
  593389
  594463
  594995
  596479
  596523
  603181
  604658
  605598
  605809
  606858
  608881
  609042
  609998
  610055
  610322
  612242
  612960
  614045
  616674
  616885
  617732
  619582
  623961
  625753
  626324
  626452
  626895
  627326
  629663
  630156
  630359
  632143
  632176
  634035
  634897
  635022
  644201
  654376
  654919
  660331
  662181
  666364
  666695
  666935
  668782
  669255
  674907
  677969
  679823
  680459
  681237
  683073
  684695
  687814
  700724
  709458
  721869
  727771
  732868
  732911
  758706
  763350
  764200
  765322
  766707
  791218
  796509
  804552
  805259
  814435
]
19.97 ms
(10.88%)
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
  551962
  556791
  557567
  579220
  562482
  564354
  566334
  677969
  687814
  683073
  660331
  662181
  669255
  680459
  552653
  559729
  563330
  579873
  584034
  609042
  609998
  634035
  644201
  586010
  588900
  591816
  596523
  604658
  608881
  634897
  593389
  612242
  605598
  626895
  627326
  632176
  796509
  758706
  606858
  617732
  630156
  630359
  814435
  472883
  525173
  521636
  564679
  679823
  681237
  684695
  700724
  709458
  610322
  616885
  623961
  626324
  804552
  766707
  727771
  764200
  765322
  732911
  626452
  721869
  791218
  419264
  526794
  674907
  654919
  614045
  594995
  616674
  732868
  763350
  530458
  488510
  556104
  805259
  625753
  538514
  496458
  566331
  578796
  572707
  666935
  612960
  591874
  603181
  610055
  632143
  475510
  491583
  522436
  518425
  525855
  511061
  513966
  529113
  566585
  583513
  584563
  552584
  568531
  654376
  666364
  666695
  668782
  550668
  554260
  562975
  567040
  592146
  594463
  619582
  586853
  591938
  596479
  605809
  629663
  635022
]
4.40 ms
(2.40%)
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
  419264
  472883
  475510
  488510
  491583
  496458
  511061
  513966
  518425
  521636
  522436
  525173
  525855
  526794
  529113
  530458
  538514
  550668
  551962
  552584
  552653
  554260
  556104
  556791
  557567
  559729
  562482
  562975
  563330
  564354
  564679
  566331
  566334
  566585
  567040
  568531
  572707
  578796
  579220
  579873
  583513
  584034
  584563
  586010
  586853
  588900
  591816
  591874
  591938
  592146
  593389
  594463
  594995
  596479
  596523
  603181
  604658
  605598
  605809
  606858
  608881
  609042
  609998
  610055
  610322
  612242
  612960
  614045
  616674
  616885
  617732
  619582
  623961
  625753
  626324
  626452
  626895
  627326
  629663
  630156
  630359
  632143
  632176
  634035
  634897
  635022
  644201
  654376
  654919
  660331
  662181
  666364
  666695
  666935
  668782
  669255
  674907
  677969
  679823
  680459
  681237
  683073
  684695
  687814
  700724
  709458
  721869
  727771
  732868
  732911
  758706
  763350
  764200
  765322
  766707
  791218
  796509
  804552
  805259
  814435
]
2.04 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "кремпа сперм"
]
2.01 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кончились внутри меня…"
]
1.85 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(0.93%)
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.