Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
179.64 ms
(87.35%)
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
  385608
  398902
  417709
  443949
  445766
  456125
  459902
  460531
  464553
  470345
  470360
  472305
  472865
  472966
  477156
  478211
  481641
  484075
  486274
  489779
  491010
  491377
  506978
  507141
  512877
  523072
  525062
  525932
  526404
  526427
  527596
  528903
  528911
  532351
  534569
  537306
  540708
  551221
  552823
  554046
  554808
  560493
  561629
  567078
  574300
  577953
  590606
  603697
  603959
  606220
  608683
  611413
  611954
  616457
  618005
  618965
  622661
  622681
  626143
  627894
  631185
  633563
  634276
  644847
  645446
  648192
  649870
  650226
  671494
  673097
  673996
  677524
  692824
  695665
  696049
  696062
  696685
  698709
  698819
  714040
  716339
  718391
  719907
  719933
  721918
  727899
  728276
  730023
  730441
  731031
  731147
  732584
  733021
  733540
  738421
  738604
  738951
  740761
  743615
  745074
  749860
  757026
  760902
  767391
  779702
  780734
  785103
  796248
  798630
  798746
  809333
  813070
  813599
  813979
  818738
  820504
  820564
  828127
]
16.47 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
  525932
  445766
  472305
  491010
  525062
  537306
  527596
  512877
  577953
  645446
  574300
  634276
  622661
  626143
  796248
  478211
  460531
  618005
  526404
  822647
  828127
  719933
  477156
  551221
  560493
  650226
  692824
  696049
  714040
  673996
  695665
  696062
  603959
  606220
  590606
  611413
  780734
  731031
  749860
  733021
  732584
  745074
  728276
  731147
  611954
  716339
  489779
  677524
  622681
  540708
  696685
  698709
  721918
  616457
  757026
  719907
  785103
  733540
  464553
  618965
  470360
  443949
  671494
  532351
  644847
  528911
  631185
  603697
  481641
  813979
  470345
  506978
  523072
  486274
  649870
  698819
  608683
  743615
  561629
  673097
  385608
  730441
  552823
  484075
  459902
  526427
  738421
  738951
  398902
  820504
  820564
  822935
  798746
  740761
  633563
  554808
  456125
  567078
  491377
  417709
  813599
  818738
  472865
  534569
  507141
  528903
  472966
  554046
  648192
  718391
  627894
  798630
  779702
  809333
  730023
  813070
  727899
  760902
  767391
  738604
]
2.54 ms
(1.24%)
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
  385608
  398902
  417709
  443949
  445766
  456125
  459902
  460531
  464553
  470345
  470360
  472305
  472865
  472966
  477156
  478211
  481641
  484075
  486274
  489779
  491010
  491377
  506978
  507141
  512877
  523072
  525062
  525932
  526404
  526427
  527596
  528903
  528911
  532351
  534569
  537306
  540708
  551221
  552823
  554046
  554808
  560493
  561629
  567078
  574300
  577953
  590606
  603697
  603959
  606220
  608683
  611413
  611954
  616457
  618005
  618965
  622661
  622681
  626143
  627894
  631185
  633563
  634276
  644847
  645446
  648192
  649870
  650226
  671494
  673097
  673996
  677524
  692824
  695665
  696049
  696062
  696685
  698709
  698819
  714040
  716339
  718391
  719907
  719933
  721918
  727899
  728276
  730023
  730441
  731031
  731147
  732584
  733021
  733540
  738421
  738604
  738951
  740761
  743615
  745074
  749860
  757026
  760902
  767391
  779702
  780734
  785103
  796248
  798630
  798746
  809333
  813070
  813599
  813979
  818738
  820504
  820564
  828127
]
1.93 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public sucking dick"
]
1.82 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на sucking улиц член"
]
1.67 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на sucking улиц член"
]

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.