Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.62 ms
(82.61%)
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
  12203
  33974
  40360
  121555
  168687
  172262
  191356
  233135
  233166
  233321
  237293
  240982
  266134
  305556
  323041
  358933
  365875
  378046
  381940
  383036
  383719
  387213
  390927
  392489
  393399
  395228
  396960
  400722
  405490
  408940
  408978
  409680
  415779
  416044
  418916
  424447
  429788
  430543
  433350
  433929
  435701
  438005
  439764
  442392
  443173
  448949
  450881
  455125
  456287
  461047
  461294
  471491
  472161
  480553
  480679
  481345
  481986
  482450
  489648
  489758
  493050
  497701
  499183
  500053
  508360
  508745
  508996
  510273
  513652
  514160
  514919
  518438
  519984
  520480
  522191
  525062
  526013
  527181
  531564
  544639
  548040
  549153
  549172
  551491
  556648
  557807
  558781
  560238
  561470
  566405
  588992
  611283
  611369
  618309
  623471
  629436
  699976
  701763
  715143
  719872
  724107
  726240
  728554
  730132
  737277
  742763
  745884
  750862
  761593
  767998
  768758
  778559
  778663
  788075
  795140
  796316
  796679
  801381
  801807
  803851
]
19.36 ms
(11.38%)
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
  396960
  803851
  514160
  429788
  233166
  448949
  778663
  323041
  233135
  12203
  438005
  40360
  305556
  513652
  33974
  387213
  418916
  549172
  629436
  778559
  408940
  237293
  482450
  520480
  378046
  266134
  433929
  408978
  358933
  456287
  489648
  424447
  439764
  240982
  788075
  510273
  551491
  393399
  390927
  365875
  409680
  168687
  395228
  405490
  557807
  519984
  699976
  383719
  493050
  191356
  500053
  527181
  480553
  514919
  471491
  430543
  750862
  518438
  560238
  761593
  548040
  442392
  549153
  508360
  481345
  588992
  558781
  233321
  480679
  531564
  701763
  796679
  415779
  561470
  728554
  121555
  416044
  435701
  611369
  383036
  508996
  400722
  443173
  392489
  381940
  499183
  623471
  172262
  433350
  481986
  544639
  724107
  737277
  745884
  796316
  730132
  497701
  461294
  801807
  526013
  556648
  522191
  489758
  611283
  472161
  566405
  618309
  801381
  719872
  715143
  461047
  767998
  726240
  768758
  742763
  525062
  455125
  450881
  508745
  795140
]
2.79 ms
(1.64%)
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
  12203
  33974
  40360
  121555
  168687
  172262
  191356
  233135
  233166
  233321
  237293
  240982
  266134
  305556
  323041
  358933
  365875
  378046
  381940
  383036
  383719
  387213
  390927
  392489
  393399
  395228
  396960
  400722
  405490
  408940
  408978
  409680
  415779
  416044
  418916
  424447
  429788
  430543
  433350
  433929
  435701
  438005
  439764
  442392
  443173
  448949
  450881
  455125
  456287
  461047
  461294
  471491
  472161
  480553
  480679
  481345
  481986
  482450
  489648
  489758
  493050
  497701
  499183
  500053
  508360
  508745
  508996
  510273
  513652
  514160
  514919
  518438
  519984
  520480
  522191
  525062
  526013
  527181
  531564
  544639
  548040
  549153
  549172
  551491
  556648
  557807
  558781
  560238
  561470
  566405
  588992
  611283
  611369
  618309
  623471
  629436
  699976
  701763
  715143
  719872
  724107
  726240
  728554
  730132
  737277
  742763
  745884
  750862
  761593
  767998
  768758
  778559
  778663
  788075
  795140
  796316
  796679
  801381
  801807
  803851
]
2.02 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.96 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð┐ð¥ÐÇð¢ð¥ Ðü Ðüð¥ÐüðÁð┤ð¥ð╝ ð© ð╝ð░ð╝ð%ÔǪ"
]
1.90 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "порн сосед мам женщин"
]
1.57 ms
(0.92%)
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.