Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.99 ms
(82.96%)
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
  233298
  390242
  396206
  402736
  417284
  418364
  421618
  423909
  424006
  424070
  424139
  424164
  425150
  425285
  426820
  429825
  433379
  433755
  433878
  434428
  439350
  443924
  444859
  447200
  447300
  450006
  453214
  455582
  455656
  457354
  457514
  459454
  460895
  461804
  462507
  462738
  463328
  464250
  465837
  466297
  468420
  469904
  470129
  471346
  472054
  472323
  473420
  476407
  476892
  479519
  480854
  483271
  483815
  485637
  487682
  491129
  493039
  496882
  499047
  500651
  501434
  502962
  505072
  508650
  509645
  520609
  521330
  524980
  526333
  537960
  538396
  538451
  543548
  543762
  547703
  551417
  552190
  558592
  562148
  562757
  563248
  570567
  573559
  577513
  579426
  579615
  596670
  600118
  604217
  611431
  621592
  644501
  654572
  656360
  658407
  692747
  723879
  725779
  745360
  745684
  746873
  761666
  761950
  766236
  768740
  770943
  777939
  778245
  778532
  778574
  780822
  784433
  789435
  792406
  793241
  795108
  795668
  799825
  799909
  814461
]
17.29 ms
(10.55%)
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
  656360
  462507
  573559
  469904
  465837
  455656
  424006
  429825
  483815
  434428
  444859
  453214
  491129
  795668
  795108
  784433
  768740
  745360
  426820
  479519
  501434
  521330
  538451
  793241
  723879
  777939
  780822
  447200
  423909
  462738
  233298
  460895
  473420
  485637
  799825
  792406
  538396
  596670
  537960
  455582
  547703
  562148
  425285
  483271
  424070
  476892
  450006
  508650
  421618
  424164
  562757
  579615
  463328
  476407
  425150
  417284
  433878
  472054
  570567
  424139
  447300
  502962
  470129
  390242
  433755
  468420
  433379
  500651
  499047
  526333
  552190
  466297
  520609
  654572
  658407
  778574
  789435
  766236
  505072
  543548
  551417
  604217
  472323
  402736
  509645
  725779
  459454
  461804
  487682
  579426
  577513
  480854
  457354
  464250
  471346
  439350
  524980
  814461
  692747
  644501
  621592
  778245
  778532
  746873
  745684
  761950
  770943
  761666
  611431
  600118
  457514
  496882
  563248
  418364
  443924
  396206
  543762
  799909
  558592
  493039
]
2.85 ms
(1.74%)
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
  233298
  390242
  396206
  402736
  417284
  418364
  421618
  423909
  424006
  424070
  424139
  424164
  425150
  425285
  426820
  429825
  433379
  433755
  433878
  434428
  439350
  443924
  444859
  447200
  447300
  450006
  453214
  455582
  455656
  457354
  457514
  459454
  460895
  461804
  462507
  462738
  463328
  464250
  465837
  466297
  468420
  469904
  470129
  471346
  472054
  472323
  473420
  476407
  476892
  479519
  480854
  483271
  483815
  485637
  487682
  491129
  493039
  496882
  499047
  500651
  501434
  502962
  505072
  508650
  509645
  520609
  521330
  524980
  526333
  537960
  538396
  538451
  543548
  543762
  547703
  551417
  552190
  558592
  562148
  562757
  563248
  570567
  573559
  577513
  579426
  579615
  596670
  600118
  604217
  611431
  621592
  644501
  654572
  656360
  658407
  692747
  723879
  725779
  745360
  745684
  746873
  761666
  761950
  766236
  768740
  770943
  777939
  778245
  778532
  778574
  780822
  784433
  789435
  792406
  793241
  795108
  795668
  799825
  799909
  814461
]
2.18 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð╝ð¥ð╗ð¥ð┤ÐâÐÄ ÐÇÐâÐüÐüð║ÐâÐÄ ÐÇð░ð║ð¥ð%ÔǪ"
]
1.99 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "молодая девушк русск рак"
]
1.83 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.