Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
187.10 ms
(88.13%)
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
  6666
  151062
  401764
  410663
  413958
  432625
  448636
  451213
  457228
  459963
  462763
  470400
  492176
  519772
  536432
  539275
  541678
  552697
  564103
  564524
  568093
  575846
  586006
  592300
  592644
  603391
  603785
  604362
  618360
  619273
  619828
  619974
  624196
  625599
  625960
  627362
  627788
  632111
  640457
  656931
  657177
  662142
  662181
  663721
  669003
  670904
  683092
  683270
  687317
  694132
  704377
  711870
  714672
  720103
  724048
  724074
  726282
  727739
  730347
  731346
  735602
  739230
  739389
  740009
  740241
  740819
  740882
  745135
  745682
  746884
  750265
  752565
  754070
  756551
  757178
  759759
  759926
  761594
  761706
  762085
  765234
  765285
  765353
  765657
  765756
  765835
  765940
  766600
  766680
  767017
  767235
  767326
  771041
  775686
  783271
  784740
  785832
  788592
  788650
  788897
  790515
  790523
  791416
  792100
  795628
  795822
  796126
  796142
  796162
  797065
  797189
  797310
  800508
  800633
  817721
  818327
  819431
  820165
  824028
  827484
]
15.30 ms
(7.21%)
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
  766680
  759759
  767017
  765756
  714672
  726282
  797065
  401764
  541678
  575846
  711870
  619974
  604362
  656931
  752565
  657177
  817721
  824028
  767235
  745682
  740819
  745135
  740241
  539275
  820165
  564103
  788592
  765835
  739230
  470400
  586006
  603391
  783271
  800508
  740882
  754070
  761594
  767326
  735602
  765353
  739389
  746884
  765657
  784740
  788650
  790523
  791416
  410663
  662181
  618360
  592644
  765940
  759926
  790515
  792100
  756551
  730347
  731346
  462763
  662142
  663721
  670904
  603785
  795628
  761706
  762085
  765285
  771041
  625960
  640457
  704377
  627788
  724048
  151062
  519772
  819431
  796142
  750265
  775686
  413958
  451213
  459963
  669003
  720103
  796162
  797189
  765234
  766600
  795822
  796126
  797310
  457228
  683270
  683092
  632111
  800633
  757178
  619828
  624196
  592300
  619273
  627362
  785832
  727739
  724074
  687317
  6666
  492176
  448636
  536432
  564524
  694132
  568093
  625599
  552697
  432625
  818327
  827484
  788897
  740009
]
2.81 ms
(1.32%)
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
  6666
  151062
  401764
  410663
  413958
  432625
  448636
  451213
  457228
  459963
  462763
  470400
  492176
  519772
  536432
  539275
  541678
  552697
  564103
  564524
  568093
  575846
  586006
  592300
  592644
  603391
  603785
  604362
  618360
  619273
  619828
  619974
  624196
  625599
  625960
  627362
  627788
  632111
  640457
  656931
  657177
  662142
  662181
  663721
  669003
  670904
  683092
  683270
  687317
  694132
  704377
  711870
  714672
  720103
  724048
  724074
  726282
  727739
  730347
  731346
  735602
  739230
  739389
  740009
  740241
  740819
  740882
  745135
  745682
  746884
  750265
  752565
  754070
  756551
  757178
  759759
  759926
  761594
  761706
  762085
  765234
  765285
  765353
  765657
  765756
  765835
  765940
  766600
  766680
  767017
  767235
  767326
  771041
  775686
  783271
  784740
  785832
  788592
  788650
  788897
  790515
  790523
  791416
  792100
  795628
  795822
  796126
  796142
  796162
  797065
  797189
  797310
  800508
  800633
  817721
  818327
  819431
  820165
  824028
  827484
]
1.88 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hard anal homemade"
]
1.75 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hard анал домашн любительск"
]
1.74 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hard анал домашн любительск"
]
1.71 ms
(0.80%)
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.