Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
218.38 ms
(49.03%)
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
  6669
  95668
  383249
  383429
  384390
  384762
  386893
  388062
  388755
  389538
  390525
  392191
  393476
  393571
  393670
  396050
  397304
  397912
  398176
  398195
  401122
  401336
  401531
  402450
  405749
  408330
  410636
  411215
  415875
  439034
  447149
  451495
  452864
  456198
  461680
  462027
  464042
  464198
  464235
  468176
  468421
  468690
  469503
  470406
  471769
  472446
  477253
  477515
  478078
  479174
  479712
  485903
  487059
  487724
  488298
  489881
  490536
  490848
  490859
  491601
  493515
  494431
  495008
  495437
  496730
  497730
  498081
  499083
  499457
  502784
  503308
  508916
  509104
  509606
  511270
  512711
  512911
  513457
  514957
  517715
  519243
  522190
  525905
  530496
  531283
  531769
  533460
  533782
  534331
  534748
  535522
  535618
  537217
  537245
  537664
  538664
  538824
  539559
  540056
  541062
  544209
  546666
  557269
  644974
  698711
  710250
  720195
  723159
  723579
  737553
  747437
  760931
  761132
  815939
  817329
  820459
  821892
  822205
  823092
  824094
]
206.76 ms
(46.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "white anal"
]
12.79 ms
(2.87%)
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
  534748
  496730
  533782
  494431
  495008
  502784
  525905
  462027
  468421
  471769
  472446
  487724
  389538
  393670
  452864
  383249
  451495
  456198
  468690
  478078
  479174
  411215
  509606
  512911
  464198
  461680
  464042
  495437
  508916
  511270
  539559
  439034
  497730
  498081
  384762
  393476
  6669
  386893
  397912
  398195
  410636
  723579
  821892
  815939
  820459
  824094
  817329
  477253
  493515
  479712
  530496
  534331
  535522
  537217
  531769
  517715
  540056
  531283
  464235
  557269
  546666
  760931
  761132
  747437
  698711
  720195
  396050
  401336
  401531
  408330
  405749
  388062
  393571
  384390
  383429
  392191
  95668
  388755
  390525
  397304
  398176
  401122
  402450
  415875
  822205
  644974
  823092
  469503
  485903
  487059
  489881
  490536
  490848
  490859
  447149
  470406
  477515
  491601
  499083
  513457
  519243
  522190
  533460
  535618
  537245
  537664
  509104
  512711
  514957
  538664
  538824
  499457
  503308
  468176
  488298
  541062
  544209
  710250
  723159
  737553
]
2.67 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
  6669
  95668
  383249
  383429
  384390
  384762
  386893
  388062
  388755
  389538
  390525
  392191
  393476
  393571
  393670
  396050
  397304
  397912
  398176
  398195
  401122
  401336
  401531
  402450
  405749
  408330
  410636
  411215
  415875
  439034
  447149
  451495
  452864
  456198
  461680
  462027
  464042
  464198
  464235
  468176
  468421
  468690
  469503
  470406
  471769
  472446
  477253
  477515
  478078
  479174
  479712
  485903
  487059
  487724
  488298
  489881
  490536
  490848
  490859
  491601
  493515
  494431
  495008
  495437
  496730
  497730
  498081
  499083
  499457
  502784
  503308
  508916
  509104
  509606
  511270
  512711
  512911
  513457
  514957
  517715
  519243
  522190
  525905
  530496
  531283
  531769
  533460
  533782
  534331
  534748
  535522
  535618
  537217
  537245
  537664
  538664
  538824
  539559
  540056
  541062
  544209
  546666
  557269
  644974
  698711
  710250
  720195
  723159
  723579
  737553
  747437
  760931
  761132
  815939
  817329
  820459
  821892
  822205
  823092
  824094
]
1.75 ms
(0.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(0.38%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "white анал"
]
1.37 ms
(0.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "white анал"
]

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.