Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.37 ms
(84.19%)
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
  187349
  384898
  401228
  412180
  414184
  416002
  416025
  418719
  418720
  418877
  419765
  420593
  424608
  426519
  427898
  428356
  428603
  429149
  434808
  435745
  437592
  438333
  439439
  445356
  446586
  447231
  449231
  450250
  455974
  456007
  456726
  457194
  459151
  459397
  459749
  462886
  464659
  467703
  470071
  473302
  474596
  475488
  477688
  478995
  481367
  484972
  490328
  493311
  494298
  497038
  498357
  502549
  509833
  510522
  511153
  511856
  511951
  512477
  512937
  513007
  513588
  514097
  514935
  516024
  517422
  520234
  520405
  520618
  520972
  522206
  523309
  523796
  523903
  526073
  526789
  528186
  529548
  537889
  537901
  546725
  546824
  551886
  555899
  557209
  562856
  563444
  565768
  569082
  569784
  575451
  575708
  579379
  587919
  588016
  588052
  589145
  589758
  589795
  590602
  591214
  602957
  605015
  605529
  606759
  619753
  629212
  630900
  630915
  631466
  633216
  637540
  648880
  657136
  663294
  674474
  712684
  721551
  788573
  799421
  808060
]
17.76 ms
(9.81%)
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
  590602
  439439
  512937
  474596
  674474
  629212
  633216
  446586
  419765
  555899
  605529
  631466
  475488
  418877
  523309
  416002
  457194
  513007
  481367
  648880
  588016
  384898
  435745
  449231
  450250
  490328
  522206
  528186
  513588
  575451
  575708
  579379
  546824
  565768
  619753
  602957
  462886
  459749
  473302
  497038
  447231
  523796
  494298
  526789
  569784
  562856
  712684
  569082
  187349
  456007
  502549
  514935
  520618
  520234
  657136
  788573
  428356
  424608
  516024
  418719
  426519
  437592
  484972
  512477
  605015
  589758
  589145
  799421
  428603
  418720
  427898
  438333
  511153
  520972
  663294
  537889
  537901
  589795
  546725
  414184
  467703
  498357
  514097
  529548
  563444
  606759
  630915
  429149
  520405
  412180
  464659
  511856
  588052
  511951
  526073
  401228
  637540
  587919
  420593
  455974
  459397
  523903
  510522
  478995
  808060
  445356
  470071
  434808
  456726
  416025
  459151
  517422
  493311
  557209
  551886
  721551
  591214
  630900
  477688
  509833
]
2.83 ms
(1.56%)
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
  187349
  384898
  401228
  412180
  414184
  416002
  416025
  418719
  418720
  418877
  419765
  420593
  424608
  426519
  427898
  428356
  428603
  429149
  434808
  435745
  437592
  438333
  439439
  445356
  446586
  447231
  449231
  450250
  455974
  456007
  456726
  457194
  459151
  459397
  459749
  462886
  464659
  467703
  470071
  473302
  474596
  475488
  477688
  478995
  481367
  484972
  490328
  493311
  494298
  497038
  498357
  502549
  509833
  510522
  511153
  511856
  511951
  512477
  512937
  513007
  513588
  514097
  514935
  516024
  517422
  520234
  520405
  520618
  520972
  522206
  523309
  523796
  523903
  526073
  526789
  528186
  529548
  537889
  537901
  546725
  546824
  551886
  555899
  557209
  562856
  563444
  565768
  569082
  569784
  575451
  575708
  579379
  587919
  588016
  588052
  589145
  589758
  589795
  590602
  591214
  602957
  605015
  605529
  606759
  619753
  629212
  630900
  630915
  631466
  633216
  637540
  648880
  657136
  663294
  674474
  712684
  721551
  788573
  799421
  808060
]
2.35 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "watch sex"
]
2.33 ms
(1.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "watch секс"
]
1.84 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "watch секс"
]
1.52 ms
(0.84%)
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.