Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
181.91 ms
(88.91%)
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
  294
  383350
  397173
  422064
  442704
  465205
  468722
  472498
  478520
  481069
  491222
  509516
  520148
  524046
  528295
  529661
  530398
  533033
  535780
  536756
  537785
  538731
  538858
  540081
  540088
  540129
  540158
  543704
  547282
  547292
  547333
  547412
  548081
  548515
  548902
  550992
  553135
  553144
  553675
  554685
  555205
  555210
  555724
  557532
  560678
  560912
  561264
  561585
  566625
  567470
  568211
  570984
  571099
  571721
  572551
  576482
  576592
  579524
  585858
  586826
  586930
  592219
  593271
  596172
  603718
  604121
  604881
  609349
  609720
  615906
  626558
  629666
  629780
  630585
  633214
  634481
  634584
  635823
  641518
  643690
  647025
  651158
  652528
  656318
  658881
  659015
  666116
  667738
  675503
  684780
  687584
  687718
  690173
  694608
  705289
  707373
  712615
  721962
  757975
  758561
  759114
  765863
  784337
  805154
  813704
  814441
  816854
  821785
  823437
  823771
  823991
  823994
  824112
  825335
  825367
  825800
  826856
  826892
  827440
  827630
]
13.16 ms
(6.43%)
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
  784337
  758561
  765863
  759114
  805154
  422064
  468722
  478520
  442704
  465205
  524046
  509516
  566625
  572551
  491222
  757975
  586826
  609349
  630585
  383350
  294
  397173
  825335
  814441
  826856
  826892
  827440
  827630
  823437
  823771
  823991
  824112
  813704
  816854
  821785
  823994
  825367
  825800
  520148
  529661
  530398
  533033
  537785
  538731
  540158
  538858
  536756
  540081
  540088
  540129
  528295
  535780
  472498
  481069
  547292
  547412
  550992
  570984
  579524
  543704
  547333
  548902
  553144
  554685
  560678
  561585
  576482
  547282
  548515
  555205
  555210
  555724
  557532
  567470
  568211
  651158
  666116
  684780
  687718
  707373
  712615
  647025
  652528
  658881
  659015
  687584
  690173
  694608
  705289
  721962
  656318
  667738
  675503
  548081
  553135
  553675
  560912
  561264
  571099
  571721
  576592
  604121
  615906
  633214
  634584
  641518
  629666
  586930
  596172
  603718
  604881
  626558
  629780
  634481
  635823
  643690
  585858
  592219
  593271
  609720
]
2.98 ms
(1.46%)
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
  294
  383350
  397173
  422064
  442704
  465205
  468722
  472498
  478520
  481069
  491222
  509516
  520148
  524046
  528295
  529661
  530398
  533033
  535780
  536756
  537785
  538731
  538858
  540081
  540088
  540129
  540158
  543704
  547282
  547292
  547333
  547412
  548081
  548515
  548902
  550992
  553135
  553144
  553675
  554685
  555205
  555210
  555724
  557532
  560678
  560912
  561264
  561585
  566625
  567470
  568211
  570984
  571099
  571721
  572551
  576482
  576592
  579524
  585858
  586826
  586930
  592219
  593271
  596172
  603718
  604121
  604881
  609349
  609720
  615906
  626558
  629666
  629780
  630585
  633214
  634481
  634584
  635823
  641518
  643690
  647025
  651158
  652528
  656318
  658881
  659015
  666116
  667738
  675503
  684780
  687584
  687718
  690173
  694608
  705289
  707373
  712615
  721962
  757975
  758561
  759114
  765863
  784337
  805154
  813704
  814441
  816854
  821785
  823437
  823771
  823991
  823994
  824112
  825335
  825367
  825800
  826856
  826892
  827440
  827630
]
1.95 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ван эротик"
]
1.74 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bathroom erotic"
]
1.49 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "ван эротик"
]
1.36 ms
(0.66%)
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.