Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.83 ms
(83.91%)
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
  12880
  117596
  150396
  240689
  389775
  390625
  393423
  396475
  397106
  397838
  398690
  405808
  412789
  415345
  420303
  421404
  465103
  469546
  473609
  482216
  482844
  484398
  484583
  500504
  509910
  513474
  517796
  518835
  519240
  520130
  529806
  529809
  530176
  537625
  538114
  539392
  546102
  546188
  549218
  549786
  552149
  557311
  559317
  563937
  575614
  576780
  579850
  580462
  582927
  585828
  590096
  591232
  591407
  596284
  602587
  602784
  605120
  606970
  607559
  611496
  612063
  613670
  614536
  614932
  615960
  622288
  624406
  624550
  626636
  627928
  631073
  634691
  635527
  636358
  641522
  643282
  644456
  645175
  646545
  647759
  652521
  654222
  654282
  656624
  659176
  661064
  664564
  664681
  665954
  667990
  670948
  671696
  673196
  674272
  678858
  682379
  692098
  705127
  705224
  707939
  709347
  710278
  710522
  716807
  718743
  721254
  737465
  775601
  778770
  781053
  787595
  792657
  792976
  795249
  800741
  812424
  813636
  813751
  813858
]
14.76 ms
(9.77%)
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
  737465
  500504
  519240
  465103
  469546
  549786
  624550
  473609
  509910
  518835
  484583
  520130
  484398
  513474
  117596
  150396
  240689
  393423
  12880
  389775
  390625
  396475
  397106
  397838
  398690
  405808
  420303
  412789
  415345
  421404
  813636
  813751
  813858
  529809
  530176
  538114
  517796
  529806
  539392
  537625
  482216
  482844
  552149
  559317
  563937
  575614
  579850
  557311
  576780
  582927
  645175
  647759
  654222
  654282
  656624
  661064
  665954
  667990
  671696
  709347
  710278
  714087
  718743
  721254
  646545
  673196
  682379
  692098
  705127
  705224
  710522
  652521
  659176
  664564
  664681
  670948
  674272
  678858
  707939
  716807
  546102
  546188
  549218
  580462
  590096
  596284
  612063
  624406
  631073
  634691
  591232
  591407
  602587
  611496
  614932
  622288
  635527
  636358
  644456
  585828
  607559
  614536
  626636
  627928
  602784
  605120
  606970
  613670
  615960
  641522
  643282
  792657
  792976
  800741
  812424
  775601
  778770
  781053
  787595
  795249
]
2.55 ms
(1.68%)
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
  12880
  117596
  150396
  240689
  389775
  390625
  393423
  396475
  397106
  397838
  398690
  405808
  412789
  415345
  420303
  421404
  465103
  469546
  473609
  482216
  482844
  484398
  484583
  500504
  509910
  513474
  517796
  518835
  519240
  520130
  529806
  529809
  530176
  537625
  538114
  539392
  546102
  546188
  549218
  549786
  552149
  557311
  559317
  563937
  575614
  576780
  579850
  580462
  582927
  585828
  590096
  591232
  591407
  596284
  602587
  602784
  605120
  606970
  607559
  611496
  612063
  613670
  614536
  614932
  615960
  622288
  624406
  624550
  626636
  627928
  631073
  634691
  635527
  636358
  641522
  643282
  644456
  645175
  646545
  647759
  652521
  654222
  654282
  656624
  659176
  661064
  664564
  664681
  665954
  667990
  670948
  671696
  673196
  674272
  678858
  682379
  692098
  705127
  705224
  707939
  709347
  710278
  710522
  716807
  718743
  721254
  737465
  775601
  778770
  781053
  787595
  792657
  792976
  795249
  800741
  812424
  813636
  813751
  813858
]
2.01 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "подруги изменяют мужя…"
]
1.72 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "подружк жен жен"
]
1.68 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "подружк жен жен"
]
1.61 ms
(1.07%)
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.