Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.78 ms
(54.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
151.85 ms
(39.29%)
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
  110884
  154257
  160126
  385021
  388057
  416652
  416697
  424593
  428257
  432274
  439071
  441125
  442511
  443091
  443097
  443861
  444684
  445103
  446781
  447315
  448108
  449070
  450697
  451022
  456244
  457483
  460001
  461612
  462377
  465454
  466475
  466991
  468946
  469220
  470473
  471663
  471664
  471666
  471669
  471693
  473213
  475336
  477149
  480206
  480452
  481935
  483711
  483738
  488820
  493490
  493730
  493734
  495737
  496337
  496345
  497667
  497693
  500327
  500336
  500338
  502286
  505143
  505387
  507951
  508895
  510532
  511864
  514236
  514240
  514849
  517272
  522340
  525603
  526504
  529338
  529988
  531347
  534563
  534586
  536470
  547467
  548157
  550922
  550926
  556906
  573270
  578319
  580069
  583665
  590255
  590373
  592362
  595145
  597160
  597534
  609071
  616292
  619703
  623187
  628094
  631461
  643100
  656826
  662046
  669058
  671008
  672939
  680816
  716086
  722378
  725628
  741247
  745112
  745114
  745121
  752605
  752657
  788529
  811765
  813605
]
17.92 ms
(4.64%)
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
  508895
  462377
  456244
  432274
  480452
  493490
  446781
  481935
  628094
  445103
  483711
  514236
  529988
  578319
  160126
  444684
  502286
  511864
  500336
  471666
  480206
  573270
  662046
  550926
  465454
  466991
  473213
  496345
  500327
  505143
  497693
  475336
  550922
  671008
  580069
  595145
  752605
  388057
  471664
  449070
  471669
  461612
  471693
  514849
  547467
  447315
  110884
  442511
  443097
  534586
  505387
  525603
  609071
  597534
  466475
  493730
  517272
  616292
  811765
  745112
  529338
  385021
  514240
  680816
  424593
  441125
  416697
  439071
  443091
  460001
  672939
  623187
  590373
  471663
  470473
  522340
  643100
  741247
  813605
  631461
  590255
  619703
  443861
  534563
  556906
  531347
  496337
  500338
  448108
  507951
  451022
  457483
  468946
  483738
  526504
  495737
  548157
  583665
  597160
  592362
  469220
  477149
  450697
  488820
  428257
  510532
  716086
  722378
  656826
  788529
  745114
  752657
  725628
  745121
  497667
  669058
  416652
  536470
  154257
  493734
]
2.34 ms
(0.60%)
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
  110884
  154257
  160126
  385021
  388057
  416652
  416697
  424593
  428257
  432274
  439071
  441125
  442511
  443091
  443097
  443861
  444684
  445103
  446781
  447315
  448108
  449070
  450697
  451022
  456244
  457483
  460001
  461612
  462377
  465454
  466475
  466991
  468946
  469220
  470473
  471663
  471664
  471666
  471669
  471693
  473213
  475336
  477149
  480206
  480452
  481935
  483711
  483738
  488820
  493490
  493730
  493734
  495737
  496337
  496345
  497667
  497693
  500327
  500336
  500338
  502286
  505143
  505387
  507951
  508895
  510532
  511864
  514236
  514240
  514849
  517272
  522340
  525603
  526504
  529338
  529988
  531347
  534563
  534586
  536470
  547467
  548157
  550922
  550926
  556906
  573270
  578319
  580069
  583665
  590255
  590373
  592362
  595145
  597160
  597534
  609071
  616292
  619703
  623187
  628094
  631461
  643100
  656826
  662046
  669058
  671008
  672939
  680816
  716086
  722378
  725628
  741247
  745112
  745114
  745121
  752605
  752657
  788529
  811765
  813605
]
2.13 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur fisting anal"
]
1.81 ms
(0.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск фистинг анал"
]
1.67 ms
(0.43%)
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.