Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.93 ms
(85.09%)
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
  391947
  406949
  427163
  444639
  456831
  489699
  514346
  534461
  537401
  572713
  578839
  588284
  588708
  607253
  612488
  614821
  616771
  619360
  627927
  634737
  636261
  638145
  652665
  658553
  662074
  667082
  667257
  670003
  671472
  680611
  696096
  701200
  701939
  709155
  709323
  715530
  716597
  716929
  719787
  726373
  727884
  729269
  734238
  734350
  734356
  735797
  739915
  744486
  746616
  747169
  747946
  748767
  749138
  754122
  757280
  757285
  758405
  760696
  761681
  763122
  763334
  765029
  765197
  765770
  766493
  766518
  771849
  772251
  772836
  775496
  775518
  777199
  777212
  777612
  777935
  778054
  778939
  779004
  779429
  779949
  781555
  782326
  782799
  785085
  785984
  786030
  787585
  788840
  789165
  790159
  790838
  791017
  791995
  792197
  792252
  792398
  794470
  794990
  795618
  795765
  797745
  799747
  800534
  802859
  803435
  803443
  808256
  809235
  809964
  814207
  814283
  816800
  818826
  819850
  824410
  826308
  826483
  826594
  826692
  827578
]
12.22 ms
(8.01%)
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
  799747
  791017
  757285
  795618
  761681
  794470
  809964
  391947
  818826
  775496
  534461
  489699
  696096
  779004
  744486
  701939
  794990
  719787
  716597
  588708
  787585
  760696
  726373
  772251
  748767
  778939
  406949
  667082
  667257
  709155
  578839
  734356
  634737
  739915
  788840
  803443
  727884
  749138
  729269
  777199
  777612
  444639
  826483
  826692
  826308
  777212
  791995
  792398
  734238
  765029
  765197
  779949
  790159
  427163
  816800
  827578
  819850
  537401
  715530
  716929
  785984
  777935
  786030
  800534
  803435
  766493
  766518
  772836
  782326
  797745
  735797
  758405
  747946
  775518
  779429
  781555
  785085
  792252
  809235
  456831
  572713
  680611
  671472
  614821
  616771
  619360
  636261
  607253
  627927
  612488
  701200
  709323
  514346
  790838
  670003
  652665
  658553
  662074
  638145
  802859
  814207
  814283
  789165
  771849
  763122
  763334
  765770
  792197
  826594
  824410
  588284
  778054
  782799
  795765
  808256
  754122
  757280
  747169
  734350
  746616
]
3.12 ms
(2.04%)
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
  391947
  406949
  427163
  444639
  456831
  489699
  514346
  534461
  537401
  572713
  578839
  588284
  588708
  607253
  612488
  614821
  616771
  619360
  627927
  634737
  636261
  638145
  652665
  658553
  662074
  667082
  667257
  670003
  671472
  680611
  696096
  701200
  701939
  709155
  709323
  715530
  716597
  716929
  719787
  726373
  727884
  729269
  734238
  734350
  734356
  735797
  739915
  744486
  746616
  747169
  747946
  748767
  749138
  754122
  757280
  757285
  758405
  760696
  761681
  763122
  763334
  765029
  765197
  765770
  766493
  766518
  771849
  772251
  772836
  775496
  775518
  777199
  777212
  777612
  777935
  778054
  778939
  779004
  779429
  779949
  781555
  782326
  782799
  785085
  785984
  786030
  787585
  788840
  789165
  790159
  790838
  791017
  791995
  792197
  792252
  792398
  794470
  794990
  795618
  795765
  797745
  799747
  800534
  802859
  803435
  803443
  808256
  809235
  809964
  814207
  814283
  816800
  818826
  819850
  824410
  826308
  826483
  826594
  826692
  827578
]
2.67 ms
(1.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur face fuck"
]
1.69 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск face секс"
]
1.60 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск face секс"
]

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.