Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.40 ms
(60.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
119.14 ms
(33.94%)
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
  544912
  544924
  550800
  553516
  558516
  558631
  558673
  559510
  564620
  569277
  575221
  575228
  575258
  576130
  576133
  577989
  580988
  583570
  584218
  585869
  585920
  586035
  586127
  587151
  587787
  587831
  589235
  589614
  589941
  590295
  590489
  592609
  592740
  593183
  595491
  595548
  596039
  596074
  596179
  596222
  598153
  598943
  599091
  599223
  599406
  599601
  599647
  600183
  600223
  600810
  600942
  601860
  602320
  602387
  603125
  604970
  605177
  605240
  605262
  607365
  607379
  607382
  611066
  613142
  614592
  618228
  618932
  621588
  622077
  625462
  626454
  628592
  628722
  631260
  631354
  633012
  642085
  642314
  646020
  649388
  649495
  651457
  652975
  659472
  659476
  660296
  661440
  661514
  661534
  662004
  664776
  670405
  670762
  671417
  673566
  675446
  678621
  679280
  679283
  683286
  683296
  685692
  687424
  693424
  697663
  700268
  704243
  705221
  705654
  708351
  708521
  709682
  709824
  709846
  711731
  711734
  717716
  722305
  723291
  723298
]
12.02 ms
(3.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
  708521
  717716
  646020
  651457
  659476
  660296
  661440
  661514
  661534
  670405
  670762
  673566
  675446
  678621
  683296
  687424
  697663
  700268
  704243
  705221
  705654
  708351
  709824
  709846
  722305
  723291
  649388
  649495
  652975
  659472
  662004
  664776
  671417
  679280
  679283
  683286
  685692
  693424
  709682
  711731
  711734
  723298
  544912
  544924
  550800
  553516
  558516
  558631
  558673
  559510
  564620
  569277
  575221
  575228
  575258
  576130
  576133
  577989
  580988
  583570
  584218
  585920
  586035
  586127
  587151
  589941
  590489
  599406
  602320
  607365
  614592
  618932
  625462
  626454
  631354
  642085
  590295
  592609
  592740
  599223
  599601
  602387
  605177
  605262
  607379
  611066
  613142
  618228
  621588
  622077
  633012
  585869
  587787
  587831
  593183
  595491
  595548
  596074
  596179
  596222
  598153
  598943
  599091
  600223
  601860
  604970
  607382
  628592
  628722
  631260
  642314
  589235
  589614
  596039
  599647
  600183
  600810
  600942
  603125
  605240
]
3.04 ms
(0.87%)
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
  544912
  544924
  550800
  553516
  558516
  558631
  558673
  559510
  564620
  569277
  575221
  575228
  575258
  576130
  576133
  577989
  580988
  583570
  584218
  585869
  585920
  586035
  586127
  587151
  587787
  587831
  589235
  589614
  589941
  590295
  590489
  592609
  592740
  593183
  595491
  595548
  596039
  596074
  596179
  596222
  598153
  598943
  599091
  599223
  599406
  599601
  599647
  600183
  600223
  600810
  600942
  601860
  602320
  602387
  603125
  604970
  605177
  605240
  605262
  607365
  607379
  607382
  611066
  613142
  614592
  618228
  618932
  621588
  622077
  625462
  626454
  628592
  628722
  631260
  631354
  633012
  642085
  642314
  646020
  649388
  649495
  651457
  652975
  659472
  659476
  660296
  661440
  661514
  661534
  662004
  664776
  670405
  670762
  671417
  673566
  675446
  678621
  679280
  679283
  683286
  683296
  685692
  687424
  693424
  697663
  700268
  704243
  705221
  705654
  708351
  708521
  709682
  709824
  709846
  711731
  711734
  717716
  722305
  723291
  723298
]
2.14 ms
(0.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo skinny"
]
1.74 ms
(0.49%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло худые"
]
1.50 ms
(0.43%)
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.