Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.56 ms
(87.49%)
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
  4279
  7206
  7308
  52595
  79031
  302443
  382594
  382954
  386589
  388424
  390747
  391715
  396045
  397244
  397417
  397739
  400821
  401985
  401989
  408502
  416847
  426026
  426316
  427246
  432374
  432404
  432479
  432624
  433039
  433078
  433729
  437558
  439031
  439467
  446645
  447103
  453218
  455551
  456236
  457569
  457761
  461832
  463808
  465781
  468105
  468256
  469171
  473745
  483443
  488023
  491138
  496740
  498587
  499806
  503682
  512500
  517662
  520490
  527795
  528962
  533972
  535187
  536141
  540904
  543353
  544194
  563303
  565480
  583992
  595572
  597060
  598010
  609285
  617106
  619360
  624159
  626083
  626247
  626252
  626569
  626647
  639527
  655280
  656607
  657514
  671613
  689750
  706359
  709623
  712714
  714656
  723236
  725021
  743073
  744040
  753397
  753831
  760906
  762191
  765296
  765431
  766810
  768854
  769369
  775909
  778494
  781011
  789151
  790466
  791847
  802513
  805510
  811439
  816607
  817200
  817709
  819705
  827644
  827929
  828164
]
13.20 ms
(6.98%)
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
  433729
  446645
  817709
  819705
  827929
  827644
  535187
  528962
  498587
  544194
  656607
  712714
  714656
  619360
  768854
  769369
  791847
  427246
  388424
  391715
  401985
  775909
  725021
  766810
  753397
  397417
  432374
  626647
  626247
  382594
  811439
  52595
  397739
  426316
  453218
  517662
  457761
  455551
  469171
  432624
  468105
  468256
  503682
  520490
  598010
  473745
  626252
  533972
  386589
  465781
  496740
  488023
  461832
  828164
  4279
  543353
  565480
  439467
  457569
  499806
  597060
  626569
  432404
  432479
  456236
  433078
  433039
  491138
  816607
  817200
  536141
  563303
  583992
  540904
  657514
  671613
  723236
  709623
  626083
  624159
  790466
  778494
  781011
  789151
  743073
  765431
  802513
  760906
  765296
  744040
  609285
  805510
  7206
  79031
  447103
  426026
  463808
  382954
  408502
  439031
  595572
  655280
  689750
  706359
  762191
  617106
  639527
  302443
  397244
  390747
  396045
  400821
  483443
  7308
  527795
  512500
  753831
  401989
  437558
  416847
]
3.75 ms
(1.98%)
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
  4279
  7206
  7308
  52595
  79031
  302443
  382594
  382954
  386589
  388424
  390747
  391715
  396045
  397244
  397417
  397739
  400821
  401985
  401989
  408502
  416847
  426026
  426316
  427246
  432374
  432404
  432479
  432624
  433039
  433078
  433729
  437558
  439031
  439467
  446645
  447103
  453218
  455551
  456236
  457569
  457761
  461832
  463808
  465781
  468105
  468256
  469171
  473745
  483443
  488023
  491138
  496740
  498587
  499806
  503682
  512500
  517662
  520490
  527795
  528962
  533972
  535187
  536141
  540904
  543353
  544194
  563303
  565480
  583992
  595572
  597060
  598010
  609285
  617106
  619360
  624159
  626083
  626247
  626252
  626569
  626647
  639527
  655280
  656607
  657514
  671613
  689750
  706359
  709623
  712714
  714656
  723236
  725021
  743073
  744040
  753397
  753831
  760906
  762191
  765296
  765431
  766810
  768854
  769369
  775909
  778494
  781011
  789151
  790466
  791847
  802513
  805510
  811439
  816607
  817200
  817709
  819705
  827644
  827929
  828164
]
1.90 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen in stockings"
]
1.60 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen чулк нижн бел"
]
1.40 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen чулк нижн бел"
]

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.