Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
258.43 ms
(90.19%)
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
  6983
  187818
  400728
  402439
  405939
  411507
  417478
  420063
  420849
  425627
  426266
  429584
  433965
  437778
  441559
  446993
  447937
  453954
  458156
  476183
  481428
  484540
  489288
  511246
  511378
  511638
  514756
  516138
  522084
  525505
  527541
  529040
  532846
  535332
  535814
  553006
  558421
  575948
  582805
  583935
  585499
  588929
  596584
  597849
  600182
  604144
  604625
  606514
  613929
  617711
  621419
  623651
  624159
  634541
  636951
  637690
  637754
  639222
  639985
  640731
  645232
  649254
  655832
  657127
  659396
  664462
  669299
  670208
  670919
  671077
  674452
  674713
  679662
  682244
  686357
  687453
  688885
  693322
  694400
  696126
  698248
  708446
  711089
  720911
  722262
  722590
  723428
  732354
  735946
  740087
  740879
  749686
  757024
  761578
  767252
  767269
  771015
  772729
  773664
  781564
  781899
  784102
  785727
  785868
  787044
  789642
  791093
  794647
  802805
  803356
  804562
  805438
  809211
  812993
  820118
  820594
  820977
  821189
  826800
]
18.57 ms
(6.48%)
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
  417478
  582805
  669299
  674713
  785868
  791093
  639985
  826800
  674452
  657127
  671077
  617711
  794647
  772729
  781899
  802805
  732354
  640731
  426266
  437778
  529040
  511638
  575948
  682244
  708446
  711089
  679662
  688885
  585499
  623651
  624159
  588929
  787044
  749686
  767269
  803356
  6983
  433965
  405939
  820594
  645232
  722590
  740087
  420063
  429584
  649254
  670208
  804562
  812993
  458156
  722262
  596584
  781564
  441559
  514756
  639222
  636951
  740879
  553006
  659396
  606514
  411507
  720911
  447937
  532846
  637754
  805438
  773664
  420849
  696126
  767252
  535814
  527541
  540323
  535332
  558421
  583935
  664462
  687453
  693322
  698248
  789642
  784102
  481428
  686357
  771015
  821189
  670919
  694400
  613929
  757024
  785727
  453954
  522084
  655832
  597849
  425627
  723428
  604144
  402439
  187818
  820977
  525505
  511378
  516138
  484540
  637690
  600182
  621419
  634541
  809211
  735946
  761578
  604625
  400728
  820118
  476183
  446993
  489288
  511246
]
2.55 ms
(0.89%)
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
  6983
  187818
  400728
  402439
  405939
  411507
  417478
  420063
  420849
  425627
  426266
  429584
  433965
  437778
  441559
  446993
  447937
  453954
  458156
  476183
  481428
  484540
  489288
  511246
  511378
  511638
  514756
  516138
  522084
  525505
  527541
  529040
  532846
  535332
  535814
  553006
  558421
  575948
  582805
  583935
  585499
  588929
  596584
  597849
  600182
  604144
  604625
  606514
  613929
  617711
  621419
  623651
  624159
  634541
  636951
  637690
  637754
  639222
  639985
  640731
  645232
  649254
  655832
  657127
  659396
  664462
  669299
  670208
  670919
  671077
  674452
  674713
  679662
  682244
  686357
  687453
  688885
  693322
  694400
  696126
  698248
  708446
  711089
  720911
  722262
  722590
  723428
  732354
  735946
  740087
  740879
  749686
  757024
  761578
  767252
  767269
  771015
  772729
  773664
  781564
  781899
  784102
  785727
  785868
  787044
  789642
  791093
  794647
  802805
  803356
  804562
  805438
  809211
  812993
  820118
  820594
  820977
  821189
  826800
]
2.14 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "first ass sex"
]
1.84 ms
(0.64%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "first жоп секс"
]
1.64 ms
(0.57%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "first жоп секс"
]

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.