Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
116.08 ms
(79.99%)
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
  45853
  66792
  187443
  383429
  400835
  401003
  407863
  409251
  412101
  421855
  426697
  428153
  432497
  433078
  433363
  433618
  444071
  457759
  460431
  462712
  463710
  469498
  476633
  477676
  478424
  489381
  492012
  492926
  500314
  509878
  512198
  515651
  516055
  525965
  526569
  527580
  528843
  529017
  530674
  534006
  538318
  540234
  548010
  552317
  554423
  554434
  559865
  559889
  571378
  581292
  585525
  586211
  587781
  589928
  591159
  601429
  608696
  617834
  621761
  622927
  623784
  675081
  682857
  688195
  688958
  692971
  714434
  715073
  716156
  716795
  718756
  723828
  726560
  732538
  735845
  736561
  739350
  740861
  742323
  744227
  744374
  747935
  750666
  757568
  757763
  758893
  760679
  760760
  762118
  767675
  770591
  777765
  778017
  778103
  778755
  778945
  780831
  781352
  782262
  784295
  785883
  788773
  790178
  790191
  795030
  796818
  804319
  804339
  805202
  808050
  809186
  809771
  811510
  813200
  813949
  814168
  817744
  824303
  825909
]
18.22 ms
(12.56%)
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
  538318
  554423
  688958
  692971
  682857
  688195
  716795
  559889
  586211
  598922
  601429
  608696
  621761
  623784
  585525
  589928
  778945
  780831
  804339
  808050
  778017
  782262
  809186
  723828
  758893
  767675
  790178
  796818
  811510
  750666
  757763
  762118
  747935
  732538
  735845
  739350
  726560
  740861
  744227
  744374
  757568
  760679
  760760
  770591
  617834
  714434
  718756
  778103
  778755
  781352
  788773
  790191
  805202
  813200
  469498
  477676
  795030
  736561
  433363
  401003
  409251
  187443
  509878
  460431
  412101
  500314
  528843
  534006
  478424
  492012
  559865
  622927
  742323
  421855
  426697
  516055
  512198
  675081
  444071
  554434
  515651
  489381
  525965
  457759
  66792
  571378
  526569
  581292
  492926
  463710
  587781
  591159
  777765
  785883
  804319
  432497
  400835
  433618
  45853
  715073
  716156
  784295
  809771
  433078
  383429
  407863
  428153
  813949
  825909
  814168
  817744
  824303
  462712
  540234
  529017
  530674
  527580
  476633
  552317
  548010
]
2.49 ms
(1.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "через колготки и трус%…"
]
2.42 ms
(1.67%)
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
  45853
  66792
  187443
  383429
  400835
  401003
  407863
  409251
  412101
  421855
  426697
  428153
  432497
  433078
  433363
  433618
  444071
  457759
  460431
  462712
  463710
  469498
  476633
  477676
  478424
  489381
  492012
  492926
  500314
  509878
  512198
  515651
  516055
  525965
  526569
  527580
  528843
  529017
  530674
  534006
  538318
  540234
  548010
  552317
  554423
  554434
  559865
  559889
  571378
  581292
  585525
  586211
  587781
  589928
  591159
  601429
  608696
  617834
  621761
  622927
  623784
  675081
  682857
  688195
  688958
  692971
  714434
  715073
  716156
  716795
  718756
  723828
  726560
  732538
  735845
  736561
  739350
  740861
  742323
  744227
  744374
  747935
  750666
  757568
  757763
  758893
  760679
  760760
  762118
  767675
  770591
  777765
  778017
  778103
  778755
  778945
  780831
  781352
  782262
  784295
  785883
  788773
  790178
  790191
  795030
  796818
  804319
  804339
  805202
  808050
  809186
  809771
  811510
  813200
  813949
  814168
  817744
  824303
  825909
]
2.27 ms
(1.56%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(1.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "колготк трусик нижн бел"
]
1.77 ms
(1.22%)
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.