Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.03 ms
(85.77%)
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
  569277
  584342
  589399
  593183
  593300
  595540
  599909
  605923
  606539
  608432
  609261
  611282
  611683
  611948
  612052
  613271
  613593
  614950
  616075
  621592
  621883
  624212
  624368
  627577
  627738
  629334
  630160
  633471
  636119
  637389
  639186
  639912
  641745
  644014
  645538
  650067
  656514
  667179
  668100
  675253
  682623
  683006
  687354
  689584
  690468
  690528
  692100
  695456
  695547
  698468
  701581
  705305
  708454
  710208
  710224
  711850
  714111
  716588
  716593
  718071
  718523
  721385
  723687
  726756
  741147
  748299
  752460
  753929
  756077
  763878
  769981
  771400
  772447
  773259
  774248
  776745
  777344
  777715
  777800
  778572
  779356
  779711
  779848
  780461
  782809
  784434
  785389
  786198
  786374
  786427
  786824
  788337
  789201
  789495
  789610
  791819
  792073
  792747
  792843
  794568
  794952
  797669
  797903
  800119
  800214
  801378
  801424
  806002
  806194
  807068
  808351
  809174
  810399
  810560
  810667
  810797
  811109
  811968
  812415
  813412
]
15.41 ms
(8.16%)
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
  683006
  692100
  695456
  695547
  698468
  701581
  705305
  708454
  710208
  721385
  645538
  650067
  656514
  667179
  668100
  675253
  682623
  687354
  689584
  690468
  690528
  710224
  711850
  714111
  716588
  716593
  718071
  718523
  569277
  584342
  593300
  605923
  611683
  616075
  624368
  627577
  633471
  641745
  644014
  589399
  613271
  614950
  624212
  629334
  639912
  593183
  606539
  608432
  609261
  611282
  611948
  613593
  627738
  636119
  637389
  595540
  599909
  612052
  621592
  621883
  630160
  639186
  776745
  777344
  777715
  777800
  778572
  779356
  779711
  779848
  780461
  782809
  785389
  786198
  786374
  786824
  789201
  789495
  792073
  792747
  792843
  797669
  800119
  800214
  801378
  801424
  807068
  809174
  812415
  813412
  786427
  788337
  794568
  806002
  808351
  810560
  811109
  811968
  723687
  741147
  748299
  752460
  753929
  756077
  763878
  769981
  771400
  772447
  773259
  774248
  784434
  789610
  791819
  794952
  797903
  806194
  810399
  810667
  810797
  726756
]
3.92 ms
(2.07%)
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
  569277
  584342
  589399
  593183
  593300
  595540
  599909
  605923
  606539
  608432
  609261
  611282
  611683
  611948
  612052
  613271
  613593
  614950
  616075
  621592
  621883
  624212
  624368
  627577
  627738
  629334
  630160
  633471
  636119
  637389
  639186
  639912
  641745
  644014
  645538
  650067
  656514
  667179
  668100
  675253
  682623
  683006
  687354
  689584
  690468
  690528
  692100
  695456
  695547
  698468
  701581
  705305
  708454
  710208
  710224
  711850
  714111
  716588
  716593
  718071
  718523
  721385
  723687
  726756
  741147
  748299
  752460
  753929
  756077
  763878
  769981
  771400
  772447
  773259
  774248
  776745
  777344
  777715
  777800
  778572
  779356
  779711
  779848
  780461
  782809
  784434
  785389
  786198
  786374
  786427
  786824
  788337
  789201
  789495
  789610
  791819
  792073
  792747
  792843
  794568
  794952
  797669
  797903
  800119
  800214
  801378
  801424
  806002
  806194
  807068
  808351
  809174
  810399
  810560
  810667
  810797
  811109
  811968
  812415
  813412
]
2.01 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "беловолосая длинные hair"
]
1.96 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беловолосая длинные hair"
]
1.91 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blonde long hair"
]
1.67 ms
(0.89%)
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.