Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.54 ms
(83.97%)
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
  421848
  421881
  433323
  439631
  439676
  439816
  444346
  449925
  450544
  453493
  453710
  455465
  456684
  460281
  460338
  460370
  461840
  464835
  465313
  466077
  466342
  476950
  478374
  482248
  483569
  484713
  485460
  486336
  486884
  488812
  491208
  492799
  496575
  496854
  497779
  500803
  503702
  503975
  504897
  506941
  509440
  510824
  511791
  511844
  513954
  516119
  517708
  519128
  519493
  520145
  520657
  521021
  521115
  523829
  524083
  524135
  524323
  525197
  526066
  526587
  528212
  528428
  528528
  528708
  528877
  528927
  532331
  532604
  533137
  538333
  539739
  539744
  539745
  539758
  543425
  543434
  545832
  549822
  550475
  556009
  559617
  561458
  562028
  562061
  565578
  566850
  571103
  572711
  578631
  582444
  586713
  586786
  589683
  591065
  592862
  593296
  596929
  597736
  598214
  599482
  602672
  602790
  605971
  606019
  608041
  611283
  616978
  619201
  619836
  620252
  621203
  621655
  623089
  623150
  625441
  627773
  638115
  668140
  680428
  682303
]
18.01 ms
(10.53%)
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
  524083
  562028
  582444
  566850
  571103
  549822
  598214
  616978
  620252
  421848
  478374
  460338
  461840
  421881
  476950
  513954
  517708
  528212
  503702
  496854
  511844
  523829
  528708
  597736
  520145
  621203
  578631
  559617
  466342
  504897
  491208
  516119
  503975
  511791
  509440
  619836
  525197
  510824
  521115
  482248
  528428
  519128
  539739
  680428
  556009
  623150
  455465
  439816
  460370
  526587
  543425
  611283
  439676
  538333
  519493
  465313
  524135
  497779
  586713
  492799
  602790
  496575
  520657
  453493
  453710
  539744
  506941
  521021
  532331
  526066
  532604
  539758
  486884
  439631
  466077
  450544
  456684
  464835
  500803
  528877
  621655
  543434
  562061
  565578
  606019
  619201
  589683
  638115
  668140
  539745
  602672
  608041
  528927
  533137
  550475
  625441
  444346
  485460
  524323
  627773
  486336
  605971
  460281
  488812
  682303
  623089
  593296
  596929
  599482
  592862
  433323
  484713
  483569
  528528
  586786
  572711
  561458
  449925
  591065
  545832
]
2.47 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
  421848
  421881
  433323
  439631
  439676
  439816
  444346
  449925
  450544
  453493
  453710
  455465
  456684
  460281
  460338
  460370
  461840
  464835
  465313
  466077
  466342
  476950
  478374
  482248
  483569
  484713
  485460
  486336
  486884
  488812
  491208
  492799
  496575
  496854
  497779
  500803
  503702
  503975
  504897
  506941
  509440
  510824
  511791
  511844
  513954
  516119
  517708
  519128
  519493
  520145
  520657
  521021
  521115
  523829
  524083
  524135
  524323
  525197
  526066
  526587
  528212
  528428
  528528
  528708
  528877
  528927
  532331
  532604
  533137
  538333
  539739
  539744
  539745
  539758
  543425
  543434
  545832
  549822
  550475
  556009
  559617
  561458
  562028
  562061
  565578
  566850
  571103
  572711
  578631
  582444
  586713
  586786
  589683
  591065
  592862
  593296
  596929
  597736
  598214
  599482
  602672
  602790
  605971
  606019
  608041
  611283
  616978
  619201
  619836
  620252
  621203
  621655
  623089
  623150
  625441
  627773
  638115
  668140
  680428
  682303
]
2.18 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"Ðüð╝ð¥ÐéÐÇðÁÐéÐî ðÂðÁð¢ð░ ð▓ Ðàð░ð╗ð░ÐéðÔǪ"
]
1.71 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "смотрет жен в халат"
]
1.52 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(0.88%)
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.