Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.97 ms
(85.95%)
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
  305626
  388757
  395944
  417796
  418559
  419490
  423767
  425957
  443669
  443974
  444087
  444629
  446415
  446457
  447706
  449643
  455600
  455619
  458528
  461394
  462101
  465951
  466310
  467165
  467397
  467451
  467486
  467494
  468982
  469410
  469672
  469675
  470288
  470947
  474797
  475857
  476334
  477366
  480896
  482530
  482533
  483362
  486111
  487095
  487889
  489092
  492163
  492259
  495192
  495689
  499482
  503920
  504776
  507730
  511534
  511541
  512835
  514113
  516442
  516509
  518349
  520319
  521239
  522416
  522975
  523472
  525263
  530270
  545695
  547874
  548570
  548594
  548642
  553147
  553703
  553717
  554758
  557939
  559063
  560429
  563475
  565617
  566615
  575522
  579359
  579362
  581618
  582790
  586429
  586500
  586527
  590451
  590500
  591077
  596580
  599434
  599826
  601152
  607344
  610600
  610686
  617186
  617638
  620280
  623813
  623849
  625142
  681899
  683074
  687511
  698933
  702850
  709543
  726570
  788300
  789711
  799402
  799642
  803784
  817507
]
12.29 ms
(8.32%)
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
  476334
  443669
  449643
  474797
  458528
  487095
  522416
  487889
  503920
  486111
  511534
  467486
  419490
  446457
  518349
  565617
  579362
  579359
  582790
  623849
  591077
  599826
  607344
  467451
  504776
  516442
  709543
  799642
  522975
  395944
  305626
  444629
  469672
  468982
  489092
  516509
  530270
  499482
  523472
  467165
  563475
  683074
  586527
  596580
  625142
  586500
  599434
  601152
  788300
  803784
  726570
  617186
  789711
  467494
  475857
  480896
  443974
  467397
  417796
  423767
  444087
  455600
  469410
  425957
  446415
  477366
  455619
  483362
  507730
  511541
  512835
  817507
  447706
  525263
  521239
  470288
  548594
  553703
  553717
  560429
  548642
  698933
  623813
  702850
  462101
  466310
  492163
  545695
  586429
  610686
  620280
  514113
  799402
  388757
  418559
  482530
  482533
  465951
  470947
  495689
  495192
  520319
  492259
  557939
  575522
  548570
  559063
  566615
  547874
  553147
  581618
  681899
  687511
  554758
  590451
  590500
  617638
  610600
  469675
  461394
]
2.52 ms
(1.71%)
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
  305626
  388757
  395944
  417796
  418559
  419490
  423767
  425957
  443669
  443974
  444087
  444629
  446415
  446457
  447706
  449643
  455600
  455619
  458528
  461394
  462101
  465951
  466310
  467165
  467397
  467451
  467486
  467494
  468982
  469410
  469672
  469675
  470288
  470947
  474797
  475857
  476334
  477366
  480896
  482530
  482533
  483362
  486111
  487095
  487889
  489092
  492163
  492259
  495192
  495689
  499482
  503920
  504776
  507730
  511534
  511541
  512835
  514113
  516442
  516509
  518349
  520319
  521239
  522416
  522975
  523472
  525263
  530270
  545695
  547874
  548570
  548594
  548642
  553147
  553703
  553717
  554758
  557939
  559063
  560429
  563475
  565617
  566615
  575522
  579359
  579362
  581618
  582790
  586429
  586500
  586527
  590451
  590500
  591077
  596580
  599434
  599826
  601152
  607344
  610600
  610686
  617186
  617638
  620280
  623813
  623849
  625142
  681899
  683074
  687511
  698933
  702850
  709543
  726570
  788300
  789711
  799402
  799642
  803784
  817507
]
1.65 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hidden young"
]
1.50 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "скрыт young"
]
1.30 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "скрыт young"
]

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.