Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
182.20 ms
(88.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
  233102
  246506
  357782
  382292
  383818
  389516
  390304
  404127
  406235
  420091
  420341
  422252
  424582
  427219
  434281
  434429
  434567
  435263
  437448
  437727
  441820
  447542
  448337
  453697
  458778
  461696
  466219
  476397
  479176
  487833
  490790
  498668
  498875
  499643
  500178
  501746
  501786
  501799
  503395
  503892
  505042
  505937
  509780
  511681
  512593
  516542
  523978
  524380
  545809
  548601
  548720
  551244
  551419
  554146
  561672
  561721
  564459
  564462
  567764
  568369
  570218
  570459
  572030
  576014
  576280
  576357
  580742
  595865
  596618
  596629
  597540
  598007
  598059
  599327
  601869
  609896
  617869
  625036
  626877
  651924
  653243
  653248
  653250
  653261
  653561
  663533
  663536
  676444
  676491
  676517
  676538
  676927
  677006
  677028
  677029
  677400
  720985
  721124
  721368
  721408
  721447
  725570
  738889
  738904
  738910
  740645
  741958
  741996
  743079
  753443
  757549
  760942
  765278
  772991
  781678
  781743
  781752
  796205
  800587
  827919
]
13.63 ms
(6.59%)
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
  653561
  738889
  743079
  800587
  434567
  424582
  390304
  382292
  576357
  653243
  653261
  625036
  406235
  453697
  523978
  501799
  501746
  561672
  572030
  564459
  551244
  595865
  441820
  447542
  448337
  501786
  435263
  476397
  505937
  677006
  663536
  653248
  545809
  246506
  490790
  567764
  663533
  580742
  599327
  626877
  796205
  753443
  725570
  404127
  420091
  437448
  499643
  500178
  503892
  498875
  827919
  570218
  676491
  676517
  676538
  772991
  781678
  738910
  760942
  765278
  738904
  617869
  437727
  511681
  598059
  597540
  598007
  498668
  509780
  561721
  596618
  596629
  458778
  357782
  434429
  422252
  466219
  427219
  516542
  548601
  548720
  233102
  487833
  554146
  576280
  551419
  651924
  677029
  720985
  676927
  677400
  721408
  721447
  568369
  576014
  609896
  434281
  479176
  461696
  383818
  503395
  505042
  524380
  512593
  420341
  570459
  721124
  676444
  721368
  677028
  601869
  781752
  781743
  741958
  741996
  757549
  389516
  740645
  564462
  653250
]
3.73 ms
(1.80%)
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
  233102
  246506
  357782
  382292
  383818
  389516
  390304
  404127
  406235
  420091
  420341
  422252
  424582
  427219
  434281
  434429
  434567
  435263
  437448
  437727
  441820
  447542
  448337
  453697
  458778
  461696
  466219
  476397
  479176
  487833
  490790
  498668
  498875
  499643
  500178
  501746
  501786
  501799
  503395
  503892
  505042
  505937
  509780
  511681
  512593
  516542
  523978
  524380
  545809
  548601
  548720
  551244
  551419
  554146
  561672
  561721
  564459
  564462
  567764
  568369
  570218
  570459
  572030
  576014
  576280
  576357
  580742
  595865
  596618
  596629
  597540
  598007
  598059
  599327
  601869
  609896
  617869
  625036
  626877
  651924
  653243
  653248
  653250
  653261
  653561
  663533
  663536
  676444
  676491
  676517
  676538
  676927
  677006
  677028
  677029
  677400
  720985
  721124
  721368
  721408
  721447
  725570
  738889
  738904
  738910
  740645
  741958
  741996
  743079
  753443
  757549
  760942
  765278
  772991
  781678
  781743
  781752
  796205
  800587
  827919
]
2.08 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "massage russian"
]
1.82 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "массаж русск"
]
1.80 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.75%)
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.