Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.52 ms
(86.28%)
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
  389234
  390650
  391921
  398972
  401613
  401642
  419549
  420304
  423869
  423968
  434709
  438430
  438488
  443579
  443626
  443627
  443632
  445638
  453194
  454393
  454561
  455121
  456022
  456979
  459469
  459959
  462604
  463982
  466346
  468157
  468337
  470410
  470431
  475431
  485947
  492450
  495278
  502835
  507751
  517682
  520227
  526747
  527919
  528036
  530098
  530127
  530430
  530860
  532634
  532635
  539329
  543970
  545414
  552275
  554488
  557406
  558252
  562426
  567083
  568228
  574649
  576487
  578525
  579510
  582440
  582457
  582747
  583287
  584010
  584039
  584045
  595253
  605184
  605565
  610647
  617390
  620119
  633954
  640350
  658453
  658469
  658477
  664368
  664587
  696115
  698123
  705781
  706889
  707518
  712672
  715567
  724878
  726078
  732782
  733503
  742608
  749016
  757543
  758154
  771642
  772062
  781843
  781889
  781925
  784964
  792819
  794199
  796797
  797341
  801527
  801570
  804271
  804368
  806301
  811727
  812055
  813808
  813818
  824067
  827290
]
16.44 ms
(8.47%)
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
  579510
  582457
  705781
  706889
  712672
  696115
  633954
  605184
  792819
  749016
  781843
  726078
  724878
  742608
  757543
  401642
  423869
  423968
  420304
  595253
  794199
  813818
  419549
  530098
  552275
  582747
  664587
  664368
  584039
  617390
  605565
  438488
  454393
  456022
  470431
  475431
  453194
  468337
  507751
  517682
  530860
  558252
  576487
  545414
  698123
  715567
  781889
  801527
  801570
  806301
  812055
  811727
  796797
  462604
  466346
  391921
  526747
  390650
  401613
  485947
  530430
  578525
  658453
  658469
  459469
  463982
  445638
  492450
  389234
  434709
  443627
  438430
  443626
  827290
  824067
  813808
  455121
  468157
  520227
  532635
  532634
  539329
  502835
  528036
  530127
  554488
  557406
  562426
  567083
  574649
  543970
  582440
  583287
  658477
  707518
  568228
  584010
  584045
  610647
  620119
  640350
  784964
  797341
  732782
  733503
  772062
  758154
  771642
  781925
  443632
  456979
  459959
  398972
  454561
  470410
  527919
  495278
  804271
  804368
  443579
]
3.23 ms
(1.66%)
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
  389234
  390650
  391921
  398972
  401613
  401642
  419549
  420304
  423869
  423968
  434709
  438430
  438488
  443579
  443626
  443627
  443632
  445638
  453194
  454393
  454561
  455121
  456022
  456979
  459469
  459959
  462604
  463982
  466346
  468157
  468337
  470410
  470431
  475431
  485947
  492450
  495278
  502835
  507751
  517682
  520227
  526747
  527919
  528036
  530098
  530127
  530430
  530860
  532634
  532635
  539329
  543970
  545414
  552275
  554488
  557406
  558252
  562426
  567083
  568228
  574649
  576487
  578525
  579510
  582440
  582457
  582747
  583287
  584010
  584039
  584045
  595253
  605184
  605565
  610647
  617390
  620119
  633954
  640350
  658453
  658469
  658477
  664368
  664587
  696115
  698123
  705781
  706889
  707518
  712672
  715567
  724878
  726078
  732782
  733503
  742608
  749016
  757543
  758154
  771642
  772062
  781843
  781889
  781925
  784964
  792819
  794199
  796797
  797341
  801527
  801570
  804271
  804368
  806301
  811727
  812055
  813808
  813818
  824067
  827290
]
1.98 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur bbw"
]
1.82 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск bbw"
]
1.44 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск bbw"
]

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.