Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.53 ms
(57.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс домашн любительск 18 19 лет"
]
125.49 ms
(34.26%)
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
  412238
  417937
  417940
  418627
  421658
  423761
  423835
  426147
  429146
  429431
  442879
  443129
  444080
  444643
  448903
  451611
  453516
  453633
  455558
  459538
  460805
  462011
  462618
  464788
  466431
  466594
  466882
  469944
  470554
  470738
  470740
  470810
  471559
  472036
  472360
  473611
  476431
  477630
  480090
  480962
  481731
  483331
  484044
  485332
  487251
  487465
  490306
  492335
  494373
  495379
  500397
  501069
  501603
  503155
  504036
  505155
  509180
  510208
  511575
  515010
  518167
  518800
  520304
  521050
  525005
  525007
  525584
  526287
  526929
  527094
  537766
  537947
  549593
  551141
  551236
  552211
  552346
  552813
  556192
  557400
  560240
  560984
  564158
  566751
  567185
  567188
  568162
  568965
  571354
  575179
  579527
  579830
  584692
  586926
  589181
  591201
  591336
  593200
  594030
  594825
  596266
  599056
  614806
  621577
  626212
  626773
  689442
  723935
  731509
  735446
  739423
  744683
  763842
  785288
  790511
  793575
  795389
  806877
  810122
  814997
]
21.47 ms
(5.86%)
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
  806877
  476431
  549593
  552346
  568162
  444643
  423835
  500397
  501069
  511575
  525005
  494373
  443129
  473611
  526287
  460805
  470810
  462618
  418627
  571354
  744683
  421658
  459538
  470738
  429146
  814997
  469944
  466882
  795389
  790511
  448903
  470740
  584692
  451611
  568965
  594825
  484044
  477630
  466431
  552813
  566751
  480090
  426147
  472036
  557400
  526929
  739423
  810122
  621577
  551236
  481731
  626773
  614806
  504036
  429431
  521050
  501603
  470554
  589181
  785288
  763842
  464788
  731509
  525584
  560984
  594030
  575179
  471559
  483331
  485332
  509180
  515010
  525007
  527094
  487251
  455558
  466594
  505155
  520304
  412238
  537947
  793575
  735446
  503155
  556192
  423761
  490306
  417940
  480962
  567188
  492335
  417937
  442879
  453516
  537766
  579830
  551141
  586926
  472360
  510208
  518800
  552211
  591336
  560240
  599056
  462011
  579527
  689442
  596266
  495379
  487465
  564158
  567185
  593200
  444080
  518167
  591201
  453633
  626212
  723935
]
2.58 ms
(0.70%)
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
  412238
  417937
  417940
  418627
  421658
  423761
  423835
  426147
  429146
  429431
  442879
  443129
  444080
  444643
  448903
  451611
  453516
  453633
  455558
  459538
  460805
  462011
  462618
  464788
  466431
  466594
  466882
  469944
  470554
  470738
  470740
  470810
  471559
  472036
  472360
  473611
  476431
  477630
  480090
  480962
  481731
  483331
  484044
  485332
  487251
  487465
  490306
  492335
  494373
  495379
  500397
  501069
  501603
  503155
  504036
  505155
  509180
  510208
  511575
  515010
  518167
  518800
  520304
  521050
  525005
  525007
  525584
  526287
  526929
  527094
  537766
  537947
  549593
  551141
  551236
  552211
  552346
  552813
  556192
  557400
  560240
  560984
  564158
  566751
  567185
  567188
  568162
  568965
  571354
  575179
  579527
  579830
  584692
  586926
  589181
  591201
  591336
  593200
  594030
  594825
  596266
  599056
  614806
  621577
  626212
  626773
  689442
  723935
  731509
  735446
  739423
  744683
  763842
  785288
  790511
  793575
  795389
  806877
  810122
  814997
]
1.83 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "минет оральн секс домашн любительск 18 19 лет"
]
1.70 ms
(0.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "минет домашнее 18-летни%…"
]
1.66 ms
(0.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.