Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
182.86 ms
(88.32%)
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
  381951
  386913
  397886
  401820
  404762
  417457
  419535
  420487
  421327
  429292
  429570
  442647
  443674
  450649
  451455
  451509
  452642
  463698
  466394
  466653
  467550
  467873
  468462
  470306
  470487
  470936
  471600
  474076
  474496
  474582
  477961
  477966
  477970
  477994
  478074
  478487
  480760
  482782
  484705
  484718
  486492
  488365
  490897
  496097
  500415
  501611
  501622
  502001
  502843
  503837
  503992
  507263
  509206
  511023
  512717
  515676
  516801
  520889
  521596
  522200
  522624
  541642
  543609
  544504
  547570
  547890
  548016
  548517
  548907
  551063
  554321
  555017
  555020
  555114
  555131
  557742
  558297
  559233
  562190
  563203
  565039
  567097
  569919
  572605
  574755
  578492
  583468
  592450
  596286
  599867
  600019
  600171
  600348
  603364
  607707
  610857
  620215
  661977
  665932
  689621
  710549
  714159
  715370
  719940
  725334
  725375
  729886
  741094
  744915
  769217
  769223
  780540
  785970
  800085
  802856
  808707
  815121
  815545
  817163
  826469
]
14.23 ms
(6.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
  599867
  600171
  607707
  600019
  503837
  507263
  548016
  452642
  555114
  477966
  484705
  501611
  512717
  541642
  470306
  815545
  815121
  478074
  443674
  463698
  474496
  478487
  555131
  420487
  467550
  509206
  386913
  496097
  421327
  482782
  715370
  725334
  729886
  442647
  620215
  554321
  592450
  471600
  466653
  744915
  450649
  470936
  417457
  451455
  826469
  817163
  477970
  689621
  780540
  800085
  802856
  725375
  710549
  719940
  785970
  543609
  714159
  741094
  501622
  474076
  480760
  555020
  547890
  569919
  397886
  404762
  477961
  419535
  488365
  502843
  503992
  484718
  490897
  665932
  583468
  548907
  551063
  557742
  578492
  600348
  559233
  522200
  470487
  474582
  486492
  467873
  468462
  466394
  502001
  520889
  516801
  429292
  603364
  808707
  562190
  477994
  521596
  661977
  511023
  572605
  548517
  565039
  547570
  567097
  596286
  429570
  769223
  769217
  381951
  451509
  522624
  500415
  515676
  544504
  555017
  558297
  563203
  574755
  610857
  401820
]
2.71 ms
(1.31%)
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
  381951
  386913
  397886
  401820
  404762
  417457
  419535
  420487
  421327
  429292
  429570
  442647
  443674
  450649
  451455
  451509
  452642
  463698
  466394
  466653
  467550
  467873
  468462
  470306
  470487
  470936
  471600
  474076
  474496
  474582
  477961
  477966
  477970
  477994
  478074
  478487
  480760
  482782
  484705
  484718
  486492
  488365
  490897
  496097
  500415
  501611
  501622
  502001
  502843
  503837
  503992
  507263
  509206
  511023
  512717
  515676
  516801
  520889
  521596
  522200
  522624
  541642
  543609
  544504
  547570
  547890
  548016
  548517
  548907
  551063
  554321
  555017
  555020
  555114
  555131
  557742
  558297
  559233
  562190
  563203
  565039
  567097
  569919
  572605
  574755
  578492
  583468
  592450
  596286
  599867
  600019
  600171
  600348
  603364
  607707
  610857
  620215
  661977
  665932
  689621
  710549
  714159
  715370
  719940
  725334
  725375
  729886
  741094
  744915
  769217
  769223
  780540
  785970
  800085
  802856
  808707
  815121
  815545
  817163
  826469
]
2.11 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "зрелые маленькая груд…"
]
1.77 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "зрелая женщин маленькая сиськ"
]
1.76 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "зрелая женщин маленькая сиськ"
]
1.60 ms
(0.77%)
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.