Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
150.76 ms
(84.15%)
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
  34353
  95673
  145163
  181284
  385034
  386751
  388770
  391986
  396044
  400157
  403690
  410748
  414374
  415857
  420178
  421827
  423929
  424446
  425924
  426078
  428852
  432583
  439523
  440767
  440896
  441824
  444321
  446017
  448951
  450286
  452602
  455496
  457541
  457701
  458083
  463858
  466049
  466209
  466256
  466271
  469386
  469396
  476379
  478041
  478530
  482761
  482773
  484008
  493781
  497699
  498243
  498448
  499318
  499383
  500546
  503377
  508336
  513431
  516481
  519230
  521130
  522868
  532117
  541398
  547506
  565625
  576685
  583182
  593985
  602293
  606283
  616856
  618094
  634661
  638543
  644688
  664649
  682296
  686185
  691626
  695103
  707605
  714117
  716858
  718996
  721721
  725197
  725440
  725456
  726966
  729287
  729923
  734960
  737554
  758904
  759980
  765306
  766592
  769503
  770501
  786527
  793573
  795909
  797191
  801261
  802157
  811510
  812054
  815081
  815542
  815931
  816535
  816545
  818528
  819241
  820327
  820345
  822930
  823471
  824500
]
17.61 ms
(9.83%)
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
  145163
  428852
  414374
  396044
  425924
  441824
  458083
  500546
  682296
  714117
  593985
  616856
  602293
  797191
  766592
  729287
  403690
  457701
  498448
  497699
  770501
  466256
  466209
  466049
  521130
  386751
  482761
  415857
  522868
  181284
  421827
  618094
  519230
  493781
  686185
  452602
  34353
  691626
  95673
  444321
  469396
  469386
  457541
  440896
  391986
  499383
  583182
  664649
  503377
  820327
  478041
  716858
  565625
  725197
  759980
  802157
  718996
  385034
  482773
  476379
  423929
  388770
  420178
  455496
  466271
  448951
  541398
  424446
  400157
  815931
  818528
  823471
  816545
  815542
  820345
  822930
  824500
  816535
  547506
  695103
  606283
  638543
  786527
  729923
  765306
  801261
  811510
  812054
  737554
  726966
  734960
  815081
  644688
  634661
  410748
  498243
  576685
  450286
  440767
  446017
  484008
  532117
  707605
  793573
  758904
  795909
  725456
  769503
  725440
  721721
  432583
  426078
  508336
  819241
  478530
  439523
  463858
  513431
  516481
  499318
]
3.18 ms
(1.78%)
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
  34353
  95673
  145163
  181284
  385034
  386751
  388770
  391986
  396044
  400157
  403690
  410748
  414374
  415857
  420178
  421827
  423929
  424446
  425924
  426078
  428852
  432583
  439523
  440767
  440896
  441824
  444321
  446017
  448951
  450286
  452602
  455496
  457541
  457701
  458083
  463858
  466049
  466209
  466256
  466271
  469386
  469396
  476379
  478041
  478530
  482761
  482773
  484008
  493781
  497699
  498243
  498448
  499318
  499383
  500546
  503377
  508336
  513431
  516481
  519230
  521130
  522868
  532117
  541398
  547506
  565625
  576685
  583182
  593985
  602293
  606283
  616856
  618094
  634661
  638543
  644688
  664649
  682296
  686185
  691626
  695103
  707605
  714117
  716858
  718996
  721721
  725197
  725440
  725456
  726966
  729287
  729923
  734960
  737554
  758904
  759980
  765306
  766592
  769503
  770501
  786527
  793573
  795909
  797191
  801261
  802157
  811510
  812054
  815081
  815542
  815931
  816535
  816545
  818528
  819241
  820327
  820345
  822930
  823471
  824500
]
2.23 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother mother panties"
]
1.89 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин мам женщин трусик нижн бел"
]
1.83 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.92%)
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.