Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.27 ms
(83.03%)
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
  27514
  232085
  417046
  425405
  427214
  454707
  464137
  465429
  472799
  472812
  476971
  488984
  494270
  497660
  506514
  506544
  506978
  511047
  512932
  523286
  525931
  526974
  527602
  528675
  534335
  534628
  534958
  536066
  538905
  541815
  542916
  547581
  548840
  549363
  549883
  550107
  551524
  551562
  551899
  553167
  555695
  557531
  559343
  560121
  564860
  569530
  580978
  584014
  584293
  602222
  607177
  608679
  618657
  619259
  622029
  622036
  625679
  630749
  634745
  637301
  642979
  646929
  647203
  649830
  649839
  651916
  652357
  660279
  665206
  666054
  683570
  697558
  701770
  705802
  712570
  716361
  721270
  721755
  721882
  724405
  731705
  734218
  738651
  742126
  742668
  745223
  745998
  746038
  746095
  748126
  768999
  777591
  778505
  780702
  785526
  788609
  789037
  789065
  789078
  796338
  802316
  802917
  803698
  808299
  810105
  812239
  812243
  814302
  817549
  817639
  817671
  818738
  819124
  819195
  820536
  821215
  821538
  823515
  828201
]
15.37 ms
(9.79%)
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
  716361
  622036
  417046
  555695
  649830
  512932
  731705
  738651
  232085
  550107
  608679
  472799
  476971
  569530
  660279
  584014
  536066
  742668
  511047
  618657
  472812
  560121
  525931
  819195
  549883
  549363
  557531
  584293
  427214
  828201
  651916
  553167
  665206
  649839
  619259
  607177
  820536
  821215
  817671
  819124
  534958
  647203
  625679
  812239
  742126
  748126
  777591
  454707
  534335
  547581
  559343
  734218
  534628
  541815
  683570
  721755
  796338
  803698
  812243
  768999
  745998
  425405
  465429
  785526
  817639
  464137
  494270
  551524
  551899
  646929
  701770
  548840
  602222
  788609
  802316
  808299
  789037
  789065
  746095
  746038
  721270
  538905
  551562
  630749
  724405
  497660
  506544
  564860
  778505
  506978
  666054
  705802
  622029
  789078
  802917
  721882
  817549
  823515
  814302
  818738
  821538
  542916
  652357
  634745
  780702
  810105
  745223
  523286
  526974
  506514
  712570
  27514
  828355
  527602
  580978
  488984
  528675
  697558
  637301
  642979
]
3.47 ms
(2.21%)
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
  27514
  232085
  417046
  425405
  427214
  454707
  464137
  465429
  472799
  472812
  476971
  488984
  494270
  497660
  506514
  506544
  506978
  511047
  512932
  523286
  525931
  526974
  527602
  528675
  534335
  534628
  534958
  536066
  538905
  541815
  542916
  547581
  548840
  549363
  549883
  550107
  551524
  551562
  551899
  553167
  555695
  557531
  559343
  560121
  564860
  569530
  580978
  584014
  584293
  602222
  607177
  608679
  618657
  619259
  622029
  622036
  625679
  630749
  634745
  637301
  642979
  646929
  647203
  649830
  649839
  651916
  652357
  660279
  665206
  666054
  683570
  697558
  701770
  705802
  712570
  716361
  721270
  721755
  721882
  724405
  731705
  734218
  738651
  742126
  742668
  745223
  745998
  746038
  746095
  748126
  768999
  777591
  778505
  780702
  785526
  788609
  789037
  789065
  789078
  796338
  802316
  802917
  803698
  808299
  810105
  812239
  812243
  814302
  817549
  817639
  817671
  818738
  819124
  819195
  820536
  821215
  821538
  823515
  828201
]
2.25 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "tits public danc"
]
1.86 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сиськ на danc улиц"
]
1.85 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сиськ на danc улиц"
]
1.83 ms
(1.16%)
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.