Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.12 ms
(83.24%)
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
  61322
  151014
  233365
  247381
  370794
  382268
  383367
  386544
  386686
  389044
  389351
  389567
  389612
  390403
  390427
  390918
  391913
  392031
  394206
  395422
  395601
  395933
  396952
  396956
  397911
  398955
  399633
  400999
  407365
  411360
  411372
  411757
  411897
  424422
  424468
  424478
  424483
  424485
  428463
  428843
  443119
  443673
  443677
  443705
  443706
  443834
  455872
  464436
  464545
  490902
  491412
  491994
  495886
  500422
  523031
  527753
  552325
  552582
  562976
  565530
  586582
  589687
  608049
  609962
  630215
  682532
  688554
  717645
  721421
  721500
  724476
  724702
  726692
  726831
  728291
  729655
  735829
  736834
  737070
  737152
  740101
  741906
  743834
  745382
  752876
  758608
  770111
  770478
  772117
  774176
  779224
  781446
  781704
  782287
  786277
  788601
  788812
  788885
  789740
  789954
  790023
  792507
  792636
  792639
  801350
  801375
  801864
  802453
  803017
  803088
  807376
  807596
  807636
  808496
  811002
  815263
  815841
  816326
  821922
  825143
]
14.56 ms
(10.18%)
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
  770478
  788601
  807636
  808496
  724476
  741906
  729655
  743834
  745382
  758608
  774176
  737152
  752876
  608049
  779224
  786277
  788812
  788885
  792636
  390403
  390427
  395933
  397911
  400999
  411897
  424468
  428463
  443119
  443706
  247381
  386544
  389351
  389567
  389612
  398955
  411757
  424422
  370794
  392031
  395601
  411360
  411372
  424485
  443834
  464436
  464545
  233365
  386686
  391913
  394206
  443677
  443705
  424478
  424483
  443673
  490902
  495886
  500422
  523031
  491412
  491994
  527753
  770111
  740101
  383367
  151014
  395422
  382268
  61322
  389044
  390918
  396952
  396956
  399633
  428843
  407365
  815263
  816326
  825143
  815841
  821922
  455872
  552325
  562976
  565530
  552582
  688554
  721500
  717645
  721421
  682532
  630215
  589687
  586582
  609962
  781446
  781704
  790023
  801350
  801375
  801864
  807596
  789954
  792507
  802453
  807376
  772117
  782287
  789740
  792639
  803017
  803088
  811002
  724702
  726831
  728291
  735829
  736834
  726692
  737070
]
2.52 ms
(1.76%)
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
  61322
  151014
  233365
  247381
  370794
  382268
  383367
  386544
  386686
  389044
  389351
  389567
  389612
  390403
  390427
  390918
  391913
  392031
  394206
  395422
  395601
  395933
  396952
  396956
  397911
  398955
  399633
  400999
  407365
  411360
  411372
  411757
  411897
  424422
  424468
  424478
  424483
  424485
  428463
  428843
  443119
  443673
  443677
  443705
  443706
  443834
  455872
  464436
  464545
  490902
  491412
  491994
  495886
  500422
  523031
  527753
  552325
  552582
  562976
  565530
  586582
  589687
  608049
  609962
  630215
  682532
  688554
  717645
  721421
  721500
  724476
  724702
  726692
  726831
  728291
  729655
  735829
  736834
  737070
  737152
  740101
  741906
  743834
  745382
  752876
  758608
  770111
  770478
  772117
  774176
  779224
  781446
  781704
  782287
  786277
  788601
  788812
  788885
  789740
  789954
  790023
  792507
  792636
  792639
  801350
  801375
  801864
  802453
  803017
  803088
  807376
  807596
  807636
  808496
  811002
  815263
  815841
  816326
  821922
  825143
]
2.30 ms
(1.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "лижет у старой"
]
1.60 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "лиза старая женщин"
]
1.48 ms
(1.03%)
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.