Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.78 ms
(84.90%)
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
  3371
  395699
  407797
  412132
  425523
  450224
  464213
  466138
  469823
  474505
  483366
  494036
  496805
  500482
  500622
  504189
  506820
  513927
  529234
  534692
  538968
  540792
  543359
  545075
  545946
  547085
  547132
  547147
  547172
  550002
  558696
  560017
  562058
  566370
  567953
  568172
  576678
  578722
  582001
  582840
  584211
  588285
  590848
  594547
  595070
  597106
  602667
  602700
  612037
  616556
  621780
  621782
  635735
  637543
  642458
  652627
  653355
  655693
  656834
  663446
  666007
  666037
  668135
  673924
  674606
  675347
  675694
  685130
  689068
  689779
  689930
  690081
  691373
  694180
  701214
  702155
  712644
  714546
  716380
  718150
  724681
  728918
  730129
  731126
  731157
  732842
  733058
  736239
  737969
  738113
  739346
  740789
  742953
  742986
  746057
  746307
  748430
  754235
  760949
  766008
  766451
  767690
  772010
  773454
  773960
  782815
  795311
  795321
  796774
  797033
  798843
  800828
  800916
  800996
  802376
  804545
  810034
  810304
  813715
]
13.18 ms
(8.55%)
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
  766008
  395699
  690081
  560017
  474505
  685130
  566370
  494036
  529234
  666007
  668135
  694180
  621782
  621780
  545075
  547147
  567953
  675694
  731126
  728918
  773454
  738113
  724681
  538968
  550002
  673924
  689068
  653355
  689779
  691373
  702155
  716380
  597106
  602667
  602700
  800996
  795321
  798843
  810034
  742986
  804545
  732842
  733058
  737969
  742953
  748430
  772010
  730129
  739346
  746057
  760949
  795311
  810304
  576678
  407797
  412132
  483366
  450224
  500482
  562058
  595070
  466138
  469823
  506820
  513927
  655693
  504189
  500622
  578722
  543359
  689930
  718150
  802376
  425523
  540792
  588285
  663446
  547172
  568172
  584211
  594547
  776489
  731157
  773960
  736239
  740789
  3371
  813715
  464213
  534692
  496805
  545946
  582840
  547085
  547132
  582001
  666037
  674606
  714546
  652627
  656834
  675347
  701214
  712644
  558696
  590848
  616556
  642458
  612037
  635735
  637543
  782815
  796774
  800828
  746307
  766451
  767690
  797033
  800916
  754235
]
2.67 ms
(1.73%)
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
  3371
  395699
  407797
  412132
  425523
  450224
  464213
  466138
  469823
  474505
  483366
  494036
  496805
  500482
  500622
  504189
  506820
  513927
  529234
  534692
  538968
  540792
  543359
  545075
  545946
  547085
  547132
  547147
  547172
  550002
  558696
  560017
  562058
  566370
  567953
  568172
  576678
  578722
  582001
  582840
  584211
  588285
  590848
  594547
  595070
  597106
  602667
  602700
  612037
  616556
  621780
  621782
  635735
  637543
  642458
  652627
  653355
  655693
  656834
  663446
  666007
  666037
  668135
  673924
  674606
  675347
  675694
  685130
  689068
  689779
  689930
  690081
  691373
  694180
  701214
  702155
  712644
  714546
  716380
  718150
  724681
  728918
  730129
  731126
  731157
  732842
  733058
  736239
  737969
  738113
  739346
  740789
  742953
  742986
  746057
  746307
  748430
  754235
  760949
  766008
  766451
  767690
  772010
  773454
  773960
  782815
  795311
  795321
  796774
  797033
  798843
  800828
  800916
  800996
  802376
  804545
  810034
  810304
  813715
]
2.04 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жена и друг порно"
]
1.87 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен друг порн"
]
1.66 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.