Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.62 ms
(84.85%)
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
  129935
  382378
  388812
  399024
  401252
  407449
  449252
  451608
  467150
  470591
  472579
  489920
  490038
  498877
  500708
  506487
  515110
  516853
  529152
  532406
  532927
  533267
  537982
  549331
  549941
  552629
  556656
  559219
  559520
  562769
  562996
  566971
  568314
  570204
  570492
  570513
  570593
  570613
  571557
  571901
  573306
  573676
  573710
  574608
  576276
  593915
  595690
  602638
  646246
  651909
  654403
  654426
  655624
  658728
  662768
  663932
  667490
  667510
  667562
  670546
  671004
  672161
  672396
  672444
  673506
  675474
  676527
  677040
  677047
  677402
  677714
  677921
  678577
  678580
  679061
  679078
  679079
  679082
  679084
  679103
  679105
  679107
  679367
  683802
  685220
  686248
  688578
  689758
  694557
  696164
  698045
  699787
  701296
  705547
  708919
  714542
  718955
  719190
  720798
  721338
  721364
  721429
  722719
  722833
  723073
  732420
  734345
  814132
  815425
  815450
  818307
  818612
  819901
  820817
  821645
  822154
  822905
  824146
  824999
  827956
]
11.42 ms
(7.71%)
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
  576276
  651909
  646246
  559520
  593915
  595690
  602638
  734345
  549941
  559219
  573710
  562996
  570593
  571557
  573306
  573676
  574608
  570204
  570492
  570513
  570613
  732420
  698045
  129935
  382378
  388812
  399024
  401252
  407449
  815450
  819901
  821645
  814132
  818612
  820817
  822905
  815425
  818307
  822154
  824146
  827956
  824999
  449252
  451608
  467150
  472579
  489920
  515110
  529152
  533267
  500708
  516853
  537982
  498877
  506487
  532406
  532927
  470591
  490038
  549331
  556656
  568314
  571901
  552629
  562769
  566971
  654403
  658728
  663932
  667490
  670546
  671004
  672161
  672396
  672444
  673506
  677402
  677714
  678577
  678580
  679061
  679078
  679079
  679367
  683802
  714542
  718955
  719190
  720798
  721338
  721364
  721429
  722833
  655624
  662768
  667510
  679107
  685220
  699787
  722719
  723073
  654426
  667562
  675474
  676527
  677040
  677047
  677921
  679082
  679084
  679103
  679105
  686248
  688578
  689758
  694557
  696164
  701296
  705547
  708919
]
3.67 ms
(2.48%)
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
  129935
  382378
  388812
  399024
  401252
  407449
  449252
  451608
  467150
  470591
  472579
  489920
  490038
  498877
  500708
  506487
  515110
  516853
  529152
  532406
  532927
  533267
  537982
  549331
  549941
  552629
  556656
  559219
  559520
  562769
  562996
  566971
  568314
  570204
  570492
  570513
  570593
  570613
  571557
  571901
  573306
  573676
  573710
  574608
  576276
  593915
  595690
  602638
  646246
  651909
  654403
  654426
  655624
  658728
  662768
  663932
  667490
  667510
  667562
  670546
  671004
  672161
  672396
  672444
  673506
  675474
  676527
  677040
  677047
  677402
  677714
  677921
  678577
  678580
  679061
  679078
  679079
  679082
  679084
  679103
  679105
  679107
  679367
  683802
  685220
  686248
  688578
  689758
  694557
  696164
  698045
  699787
  701296
  705547
  708919
  714542
  718955
  719190
  720798
  721338
  721364
  721429
  722719
  722833
  723073
  732420
  734345
  814132
  815425
  815450
  818307
  818612
  819901
  820817
  821645
  822154
  822905
  824146
  824999
  827956
]
2.25 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy маленькая"
]
2.14 ms
(1.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy маленькая"
]
1.55 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy small"
]
1.41 ms
(0.95%)
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.