Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
179.70 ms
(86.31%)
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
  278472
  335462
  405146
  415509
  417672
  423531
  425957
  427204
  428701
  432256
  438100
  440257
  440749
  446303
  448332
  449180
  449558
  455623
  459871
  462135
  465263
  466786
  472672
  476443
  478144
  481545
  487475
  490471
  492010
  496220
  498210
  500475
  502754
  504991
  508219
  514111
  514202
  517580
  518266
  521884
  523091
  527312
  527328
  533403
  534583
  538114
  542296
  551166
  554955
  555234
  558252
  559258
  560029
  569574
  570087
  582031
  588819
  592293
  599006
  599236
  599510
  599754
  601198
  602712
  606890
  609187
  618841
  626915
  627505
  630723
  638878
  641109
  644877
  647212
  647661
  651348
  664514
  665082
  667052
  678992
  685933
  690516
  693539
  694877
  698341
  699871
  699916
  700845
  708311
  714755
  722046
  724265
  729903
  733145
  735246
  748699
  750030
  753645
  760217
  760303
  760313
  760595
  761211
  763886
  766462
  766473
  768360
  770486
  777903
  783399
  792843
  797817
  798735
  798852
  799518
  800791
  804821
  817485
  818788
  818804
]
18.16 ms
(8.72%)
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
  798735
  766462
  748699
  768360
  735246
  770486
  627505
  698341
  783399
  465263
  498210
  599510
  601198
  551166
  665082
  502754
  678992
  618841
  455623
  472672
  500475
  582031
  647212
  514111
  560029
  626915
  417672
  423531
  446303
  425957
  438100
  527312
  554955
  476443
  335462
  700845
  792843
  405146
  466786
  492010
  664514
  690516
  693539
  708311
  609187
  599006
  760217
  729903
  760303
  724265
  760595
  763886
  602712
  638878
  798852
  559258
  570087
  440257
  518266
  432256
  449558
  533403
  508219
  599236
  527328
  504991
  517580
  462135
  685933
  427204
  440749
  644877
  448332
  487475
  514202
  521884
  481545
  558252
  555234
  714755
  699871
  641109
  800791
  804821
  777903
  733145
  761211
  797817
  760313
  766473
  496220
  278472
  818804
  817485
  534583
  538114
  647661
  651348
  694877
  722046
  599754
  588819
  630723
  753645
  750030
  415509
  459871
  478144
  569574
  667052
  592293
  699916
  799518
  490471
  523091
  428701
  542296
  449180
  818788
  606890
]
2.99 ms
(1.44%)
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
  278472
  335462
  405146
  415509
  417672
  423531
  425957
  427204
  428701
  432256
  438100
  440257
  440749
  446303
  448332
  449180
  449558
  455623
  459871
  462135
  465263
  466786
  472672
  476443
  478144
  481545
  487475
  490471
  492010
  496220
  498210
  500475
  502754
  504991
  508219
  514111
  514202
  517580
  518266
  521884
  523091
  527312
  527328
  533403
  534583
  538114
  542296
  551166
  554955
  555234
  558252
  559258
  560029
  569574
  570087
  582031
  588819
  592293
  599006
  599236
  599510
  599754
  601198
  602712
  606890
  609187
  618841
  626915
  627505
  630723
  638878
  641109
  644877
  647212
  647661
  651348
  664514
  665082
  667052
  678992
  685933
  690516
  693539
  694877
  698341
  699871
  699916
  700845
  708311
  714755
  722046
  724265
  729903
  733145
  735246
  748699
  750030
  753645
  760217
  760303
  760313
  760595
  761211
  763886
  766462
  766473
  768360
  770486
  777903
  783399
  792843
  797817
  798735
  798852
  799518
  800791
  804821
  817485
  818788
  818804
]
2.28 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "car big ass"
]
1.87 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вмашин большая большие жоп"
]
1.67 ms
(0.80%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.73%)
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.