Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.23 ms
(88.99%)
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
  187842
  384288
  454537
  461680
  461767
  468349
  472877
  480718
  483561
  489848
  489849
  491583
  491584
  495437
  496730
  497635
  501510
  505441
  511481
  522705
  529331
  535384
  536421
  536440
  537264
  538259
  543629
  551892
  552584
  553996
  555282
  556469
  559996
  560961
  566770
  567952
  568068
  571126
  572707
  574173
  576505
  577576
  586853
  587296
  589070
  589487
  591736
  592361
  592686
  593207
  593985
  594463
  600539
  600540
  604206
  604226
  604360
  605585
  608122
  609989
  611206
  612960
  617683
  619582
  624196
  626144
  650726
  660418
  666364
  668533
  676642
  683028
  695911
  696722
  702038
  703582
  703584
  709819
  714895
  715123
  721329
  727736
  727743
  729337
  730315
  730347
  730479
  733700
  734324
  739855
  749909
  752708
  757395
  759641
  759917
  761048
  765279
  765313
  765699
  765774
  767315
  767607
  771324
  774696
  775180
  777734
  780873
  782940
  786048
  786537
  788851
  790861
  792645
  793770
  795701
  796668
  798183
  805287
  813537
  814232
]
10.78 ms
(5.84%)
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
  560961
  592686
  591736
  574173
  553996
  752708
  489849
  468349
  491584
  497635
  535384
  511481
  566770
  576505
  714895
  624196
  593207
  587296
  774696
  727743
  782940
  805287
  729337
  730315
  611206
  617683
  454537
  604206
  489848
  765279
  730479
  605585
  790861
  771324
  461767
  187842
  814232
  505441
  536440
  537264
  522705
  536421
  555282
  551892
  577576
  715123
  650726
  676642
  702038
  703584
  592361
  786048
  798183
  727736
  749909
  608122
  538259
  543629
  721329
  775180
  759917
  757395
  604226
  568068
  589487
  600539
  660418
  695911
  813537
  612960
  668533
  703582
  709819
  626144
  593985
  786537
  788851
  733700
  767607
  793770
  734324
  761048
  739855
  777734
  792645
  795701
  796668
  496730
  767315
  730347
  480718
  572707
  491583
  552584
  586853
  483561
  589070
  501510
  529331
  556469
  571126
  666364
  683028
  594463
  619582
  600540
  604360
  567952
  765699
  384288
  472877
  609989
  780873
  765313
  759641
  765774
  696722
  559996
  461680
  495437
]
2.26 ms
(1.22%)
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
  187842
  384288
  454537
  461680
  461767
  468349
  472877
  480718
  483561
  489848
  489849
  491583
  491584
  495437
  496730
  497635
  501510
  505441
  511481
  522705
  529331
  535384
  536421
  536440
  537264
  538259
  543629
  551892
  552584
  553996
  555282
  556469
  559996
  560961
  566770
  567952
  568068
  571126
  572707
  574173
  576505
  577576
  586853
  587296
  589070
  589487
  591736
  592361
  592686
  593207
  593985
  594463
  600539
  600540
  604206
  604226
  604360
  605585
  608122
  609989
  611206
  612960
  617683
  619582
  624196
  626144
  650726
  660418
  666364
  668533
  676642
  683028
  695911
  696722
  702038
  703582
  703584
  709819
  714895
  715123
  721329
  727736
  727743
  729337
  730315
  730347
  730479
  733700
  734324
  739855
  749909
  752708
  757395
  759641
  759917
  761048
  765279
  765313
  765699
  765774
  767315
  767607
  771324
  774696
  775180
  777734
  780873
  782940
  786048
  786537
  788851
  790861
  792645
  793770
  795701
  796668
  798183
  805287
  813537
  814232
]
1.85 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сперм анал"
]
1.84 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм анал"
]
1.82 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кончает в жопку"
]
1.77 ms
(0.96%)
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.