Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.11 ms
(83.76%)
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
  293121
  305556
  418569
  427418
  431603
  440526
  441424
  444647
  453595
  457713
  457721
  459252
  464570
  468683
  470721
  487316
  490157
  490158
  492042
  492816
  495487
  504175
  504767
  505786
  509884
  517256
  519321
  522248
  527782
  528679
  534366
  535176
  543705
  549495
  550658
  553186
  568180
  568276
  573787
  580413
  583652
  590309
  591281
  598028
  600374
  600881
  603707
  605060
  609572
  612586
  615001
  615612
  616913
  618719
  620189
  621775
  626285
  636190
  642807
  651759
  652722
  670733
  678453
  679472
  680649
  687331
  693301
  695843
  696794
  696817
  697153
  697996
  700209
  701605
  703422
  703793
  705443
  709721
  713766
  715158
  715787
  721811
  721946
  723144
  724306
  733230
  733832
  734630
  735627
  736535
  737508
  739901
  740981
  741567
  743037
  745315
  745535
  749940
  751772
  754232
  754875
  755578
  766484
  767998
  771602
  776042
  782128
  784104
  785667
  788592
  794676
  796178
  796621
  800154
  805125
  810711
  813453
  818203
  820380
  825428
]
13.08 ms
(8.49%)
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
  693301
  696817
  703422
  703793
  679472
  695843
  697153
  701605
  721811
  651759
  670733
  678453
  696794
  697996
  705443
  713766
  598028
  636190
  642807
  600374
  618719
  621775
  626285
  600881
  605060
  616913
  591281
  609572
  615612
  813453
  620189
  700209
  709721
  468683
  492042
  505786
  487316
  431603
  464570
  687331
  615001
  612586
  767998
  755578
  743037
  754875
  441424
  825428
  820380
  818203
  522248
  549495
  580413
  543705
  573787
  715158
  652722
  715787
  583652
  603707
  794676
  810711
  785667
  788592
  796621
  800154
  733230
  737508
  754232
  766484
  733832
  740981
  741567
  745315
  749940
  724306
  735627
  745535
  771602
  739901
  776042
  782128
  796178
  517256
  293121
  470721
  568180
  680649
  723144
  805125
  734630
  751772
  784104
  736535
  721946
  305556
  490158
  444647
  418569
  504767
  534366
  509884
  568276
  504175
  457713
  457721
  553186
  490157
  519321
  495487
  527782
  440526
  453595
  492816
  459252
  427418
  590309
  535176
  528679
  550658
]
3.86 ms
(2.50%)
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
  293121
  305556
  418569
  427418
  431603
  440526
  441424
  444647
  453595
  457713
  457721
  459252
  464570
  468683
  470721
  487316
  490157
  490158
  492042
  492816
  495487
  504175
  504767
  505786
  509884
  517256
  519321
  522248
  527782
  528679
  534366
  535176
  543705
  549495
  550658
  553186
  568180
  568276
  573787
  580413
  583652
  590309
  591281
  598028
  600374
  600881
  603707
  605060
  609572
  612586
  615001
  615612
  616913
  618719
  620189
  621775
  626285
  636190
  642807
  651759
  652722
  670733
  678453
  679472
  680649
  687331
  693301
  695843
  696794
  696817
  697153
  697996
  700209
  701605
  703422
  703793
  705443
  709721
  713766
  715158
  715787
  721811
  721946
  723144
  724306
  733230
  733832
  734630
  735627
  736535
  737508
  739901
  740981
  741567
  743037
  745315
  745535
  749940
  751772
  754232
  754875
  755578
  766484
  767998
  771602
  776042
  782128
  784104
  785667
  788592
  794676
  796178
  796621
  800154
  805125
  810711
  813453
  818203
  820380
  825428
]
2.51 ms
(1.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "реально скрытые камер…"
]
2.08 ms
(1.35%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск скрыт камер"
]
1.65 ms
(1.07%)
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.