Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.51 ms
(83.62%)
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
  395517
  395729
  395932
  396768
  401637
  403000
  403384
  405288
  407567
  414252
  415451
  418396
  426003
  430858
  431667
  432351
  440694
  467216
  468015
  469433
  469897
  471860
  486008
  489960
  490646
  499714
  500700
  515734
  522879
  530879
  532052
  537549
  537583
  538865
  539828
  539830
  541626
  542493
  542876
  549308
  553064
  581498
  585127
  592494
  594491
  597018
  597044
  598783
  601720
  607368
  607716
  616557
  622695
  623554
  625881
  629874
  630782
  631015
  637411
  638566
  640677
  650204
  650431
  651006
  660389
  671733
  672258
  673746
  674374
  674528
  688554
  690100
  690410
  698580
  699638
  699723
  704535
  712026
  714756
  722480
  724855
  728114
  734806
  735991
  743185
  743254
  748153
  756642
  757526
  764745
  766036
  767560
  769999
  772573
  787274
  790675
  794606
  795159
  801243
  803760
  805516
  805724
  807969
  810655
  815189
  815250
  815356
  815377
  815511
  816054
  817134
  817920
  818459
  818499
  819118
  821077
  821142
  822704
  823798
]
13.95 ms
(9.76%)
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
  817920
  815189
  815250
  815511
  486008
  539828
  532052
  674528
  672258
  690100
  699723
  714756
  651006
  722480
  638566
  640677
  607368
  637411
  597018
  630782
  803760
  748153
  787274
  766036
  728114
  724855
  756642
  794606
  414252
  396768
  407567
  426003
  432351
  468015
  515734
  541626
  823798
  601720
  818499
  821142
  816054
  822704
  817134
  821077
  815356
  815377
  819118
  537583
  581498
  650431
  698580
  704535
  650204
  674374
  712026
  673746
  622695
  625881
  801243
  807969
  735991
  743185
  790675
  795159
  805724
  764745
  734806
  769999
  743254
  757526
  767560
  623554
  629874
  699638
  805516
  810655
  440694
  499714
  542876
  597044
  467216
  403384
  395729
  430858
  469433
  469897
  500700
  431667
  690410
  594491
  607716
  796642
  772573
  418396
  395517
  405288
  395932
  471860
  490646
  403000
  401637
  415451
  818459
  585127
  489960
  522879
  537549
  538865
  530879
  539830
  549308
  553064
  542493
  660389
  688554
  671733
  598783
  616557
  631015
  592494
]
2.82 ms
(1.97%)
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
  395517
  395729
  395932
  396768
  401637
  403000
  403384
  405288
  407567
  414252
  415451
  418396
  426003
  430858
  431667
  432351
  440694
  467216
  468015
  469433
  469897
  471860
  486008
  489960
  490646
  499714
  500700
  515734
  522879
  530879
  532052
  537549
  537583
  538865
  539828
  539830
  541626
  542493
  542876
  549308
  553064
  581498
  585127
  592494
  594491
  597018
  597044
  598783
  601720
  607368
  607716
  616557
  622695
  623554
  625881
  629874
  630782
  631015
  637411
  638566
  640677
  650204
  650431
  651006
  660389
  671733
  672258
  673746
  674374
  674528
  688554
  690100
  690410
  698580
  699638
  699723
  704535
  712026
  714756
  722480
  724855
  728114
  734806
  735991
  743185
  743254
  748153
  756642
  757526
  764745
  766036
  767560
  769999
  772573
  787274
  790675
  794606
  795159
  801243
  803760
  805516
  805724
  807969
  810655
  815189
  815250
  815356
  815377
  815511
  816054
  817134
  817920
  818459
  818499
  819118
  821077
  821142
  822704
  823798
]
1.94 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beauty hairy"
]
1.72 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "beauty волосатая"
]
1.51 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "beauty волосатая"
]
1.46 ms
(1.02%)
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.