Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
180.16 ms
(87.47%)
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
  402722
  421155
  424780
  424837
  433185
  462098
  465336
  465628
  465712
  469762
  472486
  478608
  479872
  499852
  501655
  507663
  508275
  512052
  516048
  518364
  518521
  519034
  520737
  521446
  521931
  524361
  524544
  524555
  525965
  526003
  526853
  527135
  527414
  531446
  532644
  541379
  541632
  541770
  542565
  543840
  550820
  552623
  553070
  554370
  554639
  555953
  557246
  561115
  563441
  563535
  564810
  566538
  566960
  567139
  568848
  569065
  569929
  574258
  576007
  577350
  580775
  583553
  586519
  586616
  589344
  590362
  591312
  591438
  592347
  593849
  593868
  594437
  595226
  599449
  601976
  603150
  603493
  603954
  604478
  605862
  609652
  610806
  611392
  612416
  613839
  614080
  614479
  614747
  615765
  617039
  617134
  617167
  617342
  618924
  619651
  620620
  621330
  621489
  622351
  622398
  622773
  623468
  624473
  624875
  625239
  625322
  631981
  634138
  634218
  652610
  653524
  653568
  662412
  667750
  671863
  672682
  674762
  681637
  696582
  782516
]
16.79 ms
(8.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
  478608
  518364
  561115
  550820
  576007
  667750
  624875
  595226
  782516
  631981
  465628
  617134
  603150
  421155
  526853
  542565
  564810
  589344
  634138
  586616
  531446
  568848
  624473
  592347
  577350
  618924
  462098
  524361
  652610
  569065
  605862
  612416
  525965
  472486
  526003
  519034
  586519
  593868
  553070
  609652
  619651
  617167
  625322
  580775
  583553
  662412
  594437
  615765
  521446
  516048
  527135
  557246
  590362
  591312
  613839
  653524
  566538
  617342
  621489
  617039
  512052
  524544
  555953
  653568
  566960
  574258
  599449
  402722
  469762
  527414
  501655
  569929
  681637
  614747
  622773
  567139
  424780
  524555
  508275
  433185
  563535
  696582
  672682
  593849
  521931
  520737
  563441
  591438
  604478
  532644
  601976
  518521
  554639
  554370
  603493
  614479
  620620
  625239
  541770
  507663
  541379
  622398
  610806
  671863
  623468
  424837
  465712
  541632
  622351
  479872
  674762
  603954
  465336
  543840
  552623
  634218
  614080
  611392
  621330
  499852
]
2.39 ms
(1.16%)
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
  402722
  421155
  424780
  424837
  433185
  462098
  465336
  465628
  465712
  469762
  472486
  478608
  479872
  499852
  501655
  507663
  508275
  512052
  516048
  518364
  518521
  519034
  520737
  521446
  521931
  524361
  524544
  524555
  525965
  526003
  526853
  527135
  527414
  531446
  532644
  541379
  541632
  541770
  542565
  543840
  550820
  552623
  553070
  554370
  554639
  555953
  557246
  561115
  563441
  563535
  564810
  566538
  566960
  567139
  568848
  569065
  569929
  574258
  576007
  577350
  580775
  583553
  586519
  586616
  589344
  590362
  591312
  591438
  592347
  593849
  593868
  594437
  595226
  599449
  601976
  603150
  603493
  603954
  604478
  605862
  609652
  610806
  611392
  612416
  613839
  614080
  614479
  614747
  615765
  617039
  617134
  617167
  617342
  618924
  619651
  620620
  621330
  621489
  622351
  622398
  622773
  623468
  624473
  624875
  625239
  625322
  631981
  634138
  634218
  652610
  653524
  653568
  662412
  667750
  671863
  672682
  674762
  681637
  696582
  782516
]
2.15 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в рот сверху"
]
1.68 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.76%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в рот наездниц поз"
]
1.23 ms
(0.60%)
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.