Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.50 ms
(80.43%)
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
  24087
  118885
  145280
  197445
  246657
  382433
  383225
  383359
  384543
  384547
  385760
  389225
  389693
  396447
  402341
  416129
  418662
  424165
  426499
  426781
  431046
  436977
  462850
  465219
  469673
  475347
  492656
  492798
  499852
  503706
  504173
  513258
  520764
  530346
  544349
  551896
  552373
  552741
  553593
  559965
  562284
  571304
  573324
  576534
  588520
  590651
  591176
  593983
  599748
  601725
  606195
  609761
  615581
  615611
  616964
  620050
  621255
  623725
  635647
  638738
  642111
  643159
  645388
  649440
  660787
  660867
  662158
  665633
  675415
  684449
  685450
  691785
  701909
  702146
  702377
  707384
  707906
  710037
  713104
  718306
  732216
  741824
  743024
  748519
  750507
  750988
  754614
  754675
  754682
  754715
  754830
  754859
  754894
  759019
  759039
  761849
  764717
  766301
  778183
  779498
  780543
  782881
  785167
  785785
  787683
  787862
  790712
  790808
  793580
  795108
  795109
  798409
  801049
  803529
  803883
  810160
  811162
  812276
  812365
]
24.26 ms
(13.69%)
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
  562284
  492798
  504173
  499852
  620050
  636661
  588520
  426499
  590651
  492656
  431046
  465219
  462850
  591176
  812276
  665633
  707384
  601725
  732216
  389225
  593983
  389693
  384547
  718306
  754682
  754859
  520764
  702146
  635647
  396447
  615581
  780543
  754614
  750988
  643159
  384543
  246657
  573324
  615611
  782881
  754715
  764717
  416129
  710037
  475347
  402341
  754675
  785167
  424165
  530346
  623725
  552741
  713104
  553593
  778183
  803529
  803883
  759039
  810160
  469673
  385760
  741824
  779498
  790712
  795108
  801049
  790808
  795109
  748519
  798409
  24087
  503706
  649440
  645388
  684449
  787683
  754830
  785785
  599748
  513258
  383359
  436977
  383225
  759019
  544349
  559965
  642111
  621255
  418662
  551896
  552373
  197445
  701909
  685450
  702377
  660787
  662158
  750507
  609761
  811162
  793580
  426781
  660867
  675415
  616964
  606195
  638738
  754894
  787862
  766301
  743024
  382433
  145280
  571304
  707906
  691785
  576534
  812365
  761849
  118885
]
2.86 ms
(1.62%)
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
  24087
  118885
  145280
  197445
  246657
  382433
  383225
  383359
  384543
  384547
  385760
  389225
  389693
  396447
  402341
  416129
  418662
  424165
  426499
  426781
  431046
  436977
  462850
  465219
  469673
  475347
  492656
  492798
  499852
  503706
  504173
  513258
  520764
  530346
  544349
  551896
  552373
  552741
  553593
  559965
  562284
  571304
  573324
  576534
  588520
  590651
  591176
  593983
  599748
  601725
  606195
  609761
  615581
  615611
  616964
  620050
  621255
  623725
  635647
  638738
  642111
  643159
  645388
  649440
  660787
  660867
  662158
  665633
  675415
  684449
  685450
  691785
  701909
  702146
  702377
  707384
  707906
  710037
  713104
  718306
  732216
  741824
  743024
  748519
  750507
  750988
  754614
  754675
  754682
  754715
  754830
  754859
  754894
  759019
  759039
  761849
  764717
  766301
  778183
  779498
  780543
  782881
  785167
  785785
  787683
  787862
  790712
  790808
  793580
  795108
  795109
  798409
  801049
  803529
  803883
  810160
  811162
  812276
  812365
]
2.34 ms
(1.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.04 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bathroom girl"
]
1.67 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ван девушк"
]
1.50 ms
(0.85%)
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.