Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.83 ms
(84.10%)
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
  381959
  400719
  418258
  421618
  424164
  427035
  428188
  429957
  432412
  433636
  433787
  433878
  435880
  435882
  437710
  438450
  438659
  439268
  439271
  440715
  441405
  441517
  441589
  441755
  448080
  449114
  456125
  459021
  459109
  459203
  460891
  463328
  465448
  467791
  470591
  471346
  471693
  472054
  473277
  474273
  479182
  479293
  481212
  485846
  486461
  487443
  489319
  490741
  494158
  495335
  496733
  497480
  503470
  511693
  511811
  512553
  513486
  516304
  521644
  521806
  521837
  527981
  528639
  539403
  541040
  551808
  557004
  557478
  562757
  564955
  569573
  579210
  579426
  579615
  581918
  582522
  584108
  595455
  597087
  612487
  612521
  631257
  650104
  669246
  685213
  686531
  688741
  688847
  689829
  700119
  707721
  709501
  712361
  719741
  723909
  723973
  729449
  733644
  737813
  743658
  756520
  757732
  762247
  766070
  780735
  781005
  790253
  791660
  792461
  792725
  793309
  795657
  795712
  799684
  799891
  803232
  803850
  804032
  806606
]
14.58 ms
(8.90%)
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
  579426
  584108
  597087
  439271
  418258
  435880
  439268
  459203
  471346
  435882
  449114
  428188
  471693
  479182
  437710
  511693
  521837
  459109
  541040
  799891
  421618
  441755
  424164
  481212
  467791
  485846
  562757
  557004
  569573
  579615
  463328
  473277
  433636
  441517
  456125
  459021
  465448
  432412
  433787
  440715
  441405
  448080
  460891
  479293
  433878
  472054
  487443
  521644
  527981
  495335
  512553
  539403
  551808
  513486
  494158
  381959
  762247
  743658
  650104
  803232
  427035
  757732
  712361
  438450
  486461
  438659
  686531
  685213
  689829
  780735
  790253
  733644
  707721
  795657
  688741
  688847
  793309
  781005
  766070
  400719
  429957
  470591
  709501
  557478
  595455
  723909
  233298
  503470
  564955
  490741
  497480
  528639
  791660
  631257
  581918
  612487
  612521
  792461
  795712
  723973
  804032
  737813
  792725
  579210
  496733
  516304
  521806
  719741
  806606
  729449
  700119
  489319
  582522
  799684
  803850
  756520
  669246
  441589
  474273
  511811
]
3.35 ms
(2.05%)
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
  381959
  400719
  418258
  421618
  424164
  427035
  428188
  429957
  432412
  433636
  433787
  433878
  435880
  435882
  437710
  438450
  438659
  439268
  439271
  440715
  441405
  441517
  441589
  441755
  448080
  449114
  456125
  459021
  459109
  459203
  460891
  463328
  465448
  467791
  470591
  471346
  471693
  472054
  473277
  474273
  479182
  479293
  481212
  485846
  486461
  487443
  489319
  490741
  494158
  495335
  496733
  497480
  503470
  511693
  511811
  512553
  513486
  516304
  521644
  521806
  521837
  527981
  528639
  539403
  541040
  551808
  557004
  557478
  562757
  564955
  569573
  579210
  579426
  579615
  581918
  582522
  584108
  595455
  597087
  612487
  612521
  631257
  650104
  669246
  685213
  686531
  688741
  688847
  689829
  700119
  707721
  709501
  712361
  719741
  723909
  723973
  729449
  733644
  737813
  743658
  756520
  757732
  762247
  766070
  780735
  781005
  790253
  791660
  792461
  792725
  793309
  795657
  795712
  799684
  799891
  803232
  803850
  804032
  806606
]
2.59 ms
(1.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "молодая измена русска…"
]
1.96 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "молодая девушк жен русск"
]
1.88 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "молодая девушк жен русск"
]
1.69 ms
(1.03%)
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.