Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
214.60 ms
(49.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young red"
]
193.60 ms
(44.46%)
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
  94308
  233224
  328446
  383273
  385026
  388647
  388739
  395565
  395704
  395924
  397917
  401804
  407722
  407727
  411626
  411727
  411729
  426558
  443800
  452369
  461428
  469484
  470538
  474843
  476679
  480439
  484556
  487315
  491503
  504272
  508162
  515170
  515175
  517014
  519469
  524322
  528456
  528851
  529602
  530143
  530328
  530537
  533613
  537845
  542467
  542957
  550024
  554321
  558013
  560577
  560699
  563137
  565430
  567719
  576655
  583542
  599496
  601952
  602625
  602942
  602947
  603587
  608354
  609274
  614518
  618404
  622794
  627726
  630840
  631970
  649940
  651887
  651945
  659396
  665444
  665487
  666780
  673608
  682199
  693299
  693956
  724702
  725369
  727924
  728244
  742507
  746340
  776845
  778699
  781733
  781761
  782155
  782159
  782194
  782246
  784669
  786462
  788293
  788879
  790207
  790493
  792637
  798681
  801864
  802431
  802453
  803091
  803093
  803398
  806381
  807324
  809313
  816536
  816755
  817010
  818208
  818651
  819621
  820306
  820715
]
18.07 ms
(4.15%)
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
  480439
  484556
  524322
  487315
  491503
  515170
  515175
  517014
  519469
  383273
  385026
  395565
  94308
  397917
  401804
  411727
  820306
  818651
  819621
  816536
  820715
  452369
  537845
  474843
  542467
  651945
  665487
  649940
  560699
  565430
  618404
  801864
  807324
  790207
  802431
  802453
  782159
  784669
  786462
  724702
  728244
  742507
  746340
  782155
  782246
  792637
  809313
  233224
  443800
  461428
  528456
  533613
  395924
  395704
  328446
  388739
  388647
  411626
  411729
  426558
  407727
  407722
  816755
  817010
  818208
  469484
  470538
  476679
  530143
  529602
  530328
  530537
  528851
  504272
  508162
  567719
  583542
  542957
  550024
  554321
  576655
  673608
  682199
  693299
  693956
  651887
  659396
  665444
  666780
  558013
  560577
  563137
  609274
  599496
  601952
  602625
  602942
  603587
  608354
  622794
  627726
  631970
  630840
  602947
  614518
  781733
  788879
  798681
  803398
  806381
  776845
  778699
  781761
  782194
  788293
  790493
  803091
  803093
  725369
  727924
]
3.19 ms
(0.73%)
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
  94308
  233224
  328446
  383273
  385026
  388647
  388739
  395565
  395704
  395924
  397917
  401804
  407722
  407727
  411626
  411727
  411729
  426558
  443800
  452369
  461428
  469484
  470538
  474843
  476679
  480439
  484556
  487315
  491503
  504272
  508162
  515170
  515175
  517014
  519469
  524322
  528456
  528851
  529602
  530143
  530328
  530537
  533613
  537845
  542467
  542957
  550024
  554321
  558013
  560577
  560699
  563137
  565430
  567719
  576655
  583542
  599496
  601952
  602625
  602942
  602947
  603587
  608354
  609274
  614518
  618404
  622794
  627726
  630840
  631970
  649940
  651887
  651945
  659396
  665444
  665487
  666780
  673608
  682199
  693299
  693956
  724702
  725369
  727924
  728244
  742507
  746340
  776845
  778699
  781733
  781761
  782155
  782159
  782194
  782246
  784669
  786462
  788293
  788879
  790207
  790493
  792637
  798681
  801864
  802431
  802453
  803091
  803093
  803398
  806381
  807324
  809313
  816536
  816755
  817010
  818208
  818651
  819621
  820306
  820715
]
2.20 ms
(0.51%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.18 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young red"
]
1.61 ms
(0.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young red"
]

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.