Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.64 ms
(85.66%)
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
  326205
  383270
  387005
  387325
  393742
  403276
  405858
  406711
  415871
  417749
  419927
  420156
  421044
  421575
  422051
  444803
  448259
  451671
  458397
  459537
  459777
  462577
  465902
  466329
  466458
  467762
  467942
  469629
  474889
  476590
  477783
  477907
  480113
  480697
  482814
  485552
  488576
  490553
  493024
  496528
  499160
  500420
  500710
  503825
  506144
  508944
  511564
  513994
  516901
  517768
  518555
  519266
  519740
  520017
  521726
  539216
  540658
  542509
  548734
  548820
  552483
  552656
  552703
  553974
  557077
  558843
  560153
  565354
  567081
  569442
  573238
  573984
  590174
  590592
  591380
  597530
  612247
  613405
  621193
  621725
  647844
  662476
  672975
  682883
  683314
  695127
  696764
  704208
  707730
  707786
  713651
  722141
  724887
  726177
  727056
  731697
  741212
  746053
  765007
  767329
  768552
  772793
  777878
  777905
  778748
  779573
  779974
  780086
  780965
  782557
  782697
  786319
  788828
  789859
  790592
  790701
  791699
  794001
  800562
  805141
]
12.89 ms
(7.85%)
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
  696764
  707786
  786319
  790701
  789859
  772793
  794001
  768552
  724887
  731697
  613405
  777878
  778748
  779974
  459777
  422051
  482814
  496528
  552656
  560153
  591380
  448259
  458397
  467762
  519740
  500710
  508944
  499160
  513994
  516901
  511564
  405858
  415871
  503825
  782697
  767329
  474889
  383270
  552483
  417749
  421575
  480697
  467942
  520017
  421044
  451671
  459537
  477783
  542509
  780086
  477907
  480113
  444803
  493024
  573238
  465902
  500420
  490553
  387005
  466458
  539216
  790592
  779573
  780965
  469629
  540658
  707730
  683314
  722141
  682883
  713651
  621725
  777905
  791699
  765007
  741212
  403276
  565354
  548734
  558843
  387325
  662476
  621193
  406711
  518555
  548820
  488576
  746053
  466329
  567081
  647844
  704208
  506144
  553974
  552703
  590592
  476590
  393742
  569442
  590174
  695127
  557077
  519266
  420156
  517768
  326205
  419927
  521726
  462577
  485552
  573984
  672975
  612247
  597530
  800562
  805141
  782557
  726177
  727056
  788828
]
3.24 ms
(1.98%)
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
  326205
  383270
  387005
  387325
  393742
  403276
  405858
  406711
  415871
  417749
  419927
  420156
  421044
  421575
  422051
  444803
  448259
  451671
  458397
  459537
  459777
  462577
  465902
  466329
  466458
  467762
  467942
  469629
  474889
  476590
  477783
  477907
  480113
  480697
  482814
  485552
  488576
  490553
  493024
  496528
  499160
  500420
  500710
  503825
  506144
  508944
  511564
  513994
  516901
  517768
  518555
  519266
  519740
  520017
  521726
  539216
  540658
  542509
  548734
  548820
  552483
  552656
  552703
  553974
  557077
  558843
  560153
  565354
  567081
  569442
  573238
  573984
  590174
  590592
  591380
  597530
  612247
  613405
  621193
  621725
  647844
  662476
  672975
  682883
  683314
  695127
  696764
  704208
  707730
  707786
  713651
  722141
  724887
  726177
  727056
  731697
  741212
  746053
  765007
  767329
  768552
  772793
  777878
  777905
  778748
  779573
  779974
  780086
  780965
  782557
  782697
  786319
  788828
  789859
  790592
  790701
  791699
  794001
  800562
  805141
]
2.04 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм в рот красивая"
]
2.01 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сперм в рот красивая"
]
1.94 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð║ð¥ð¢Ðçð░ðÁÐé ð▓ ÐÇð¥Ðé ð║ÐÇð░Ðüð¥Ðéð║ðÔǪ"
]
1.42 ms
(0.87%)
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.