Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.79 ms
(79.15%)
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
  415112
  416303
  418009
  425518
  426699
  427981
  434601
  443871
  444606
  446112
  447500
  452617
  457789
  465824
  467155
  469576
  470309
  470441
  477441
  478065
  482350
  486086
  491664
  491702
  492098
  492340
  492392
  495096
  506213
  507666
  509100
  515749
  517246
  519576
  519907
  521135
  521739
  521740
  522056
  523290
  523996
  524490
  524992
  525432
  525464
  525702
  527642
  528146
  528254
  529200
  532753
  536657
  536766
  537685
  540688
  541366
  541588
  541886
  542550
  542954
  543844
  544202
  544455
  550409
  556025
  558847
  564675
  567140
  567145
  573640
  573694
  574519
  574527
  574546
  574916
  575144
  575197
  575810
  576080
  576113
  576645
  576711
  576713
  577362
  579647
  581401
  586629
  590667
  597480
  598475
  599478
  601314
  613220
  615716
  619539
  620674
  620686
  621170
  621201
  621985
  621988
  622824
  622831
  623813
  623818
  625001
  625359
  625440
  631597
  636519
  645918
  646214
  652907
  653567
  659025
  659419
  670089
  677108
]
21.82 ms
(13.52%)
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
  426699
  446112
  477441
  416303
  425518
  452617
  447500
  491702
  492392
  495096
  491664
  522056
  523996
  525702
  443871
  418009
  469576
  492098
  532753
  537685
  528146
  506213
  536657
  536766
  567140
  567145
  576713
  574519
  541366
  544202
  574916
  576645
  646214
  659025
  677108
  575810
  576711
  586629
  631597
  415112
  465824
  467155
  515749
  524992
  527642
  528254
  619539
  620686
  521740
  517246
  492340
  507666
  519907
  525432
  540688
  573694
  579647
  581401
  544455
  670089
  623813
  636519
  615716
  621985
  470309
  482350
  457789
  486086
  434601
  625001
  525464
  470441
  541886
  558847
  564675
  659419
  645918
  597480
  621201
  623818
  622831
  444606
  478065
  523290
  519576
  542954
  577362
  543844
  550409
  575144
  573640
  574546
  652907
  653567
  620674
  599478
  621170
  598475
  622824
  621988
  427981
  521135
  521739
  529200
  524490
  509100
  542550
  574527
  541588
  556025
  576080
  576113
  575197
  601314
  590667
  625359
  613220
  625440
]
3.09 ms
(1.91%)
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
  415112
  416303
  418009
  425518
  426699
  427981
  434601
  443871
  444606
  446112
  447500
  452617
  457789
  465824
  467155
  469576
  470309
  470441
  477441
  478065
  482350
  486086
  491664
  491702
  492098
  492340
  492392
  495096
  506213
  507666
  509100
  515749
  517246
  519576
  519907
  521135
  521739
  521740
  522056
  523290
  523996
  524490
  524992
  525432
  525464
  525702
  527642
  528146
  528254
  529200
  532753
  536657
  536766
  537685
  540688
  541366
  541588
  541886
  542550
  542954
  543844
  544202
  544455
  550409
  556025
  558847
  564675
  567140
  567145
  573640
  573694
  574519
  574527
  574546
  574916
  575144
  575197
  575810
  576080
  576113
  576645
  576711
  576713
  577362
  579647
  581401
  586629
  590667
  597480
  598475
  599478
  601314
  613220
  615716
  619539
  620674
  620686
  621170
  621201
  621985
  621988
  622824
  622831
  623813
  623818
  625001
  625359
  625440
  631597
  636519
  645918
  646214
  652907
  653567
  659025
  659419
  670089
  677108
]
2.54 ms
(1.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "licking porn"
]
2.47 ms
(1.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "лиза porn"
]
1.97 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "лиза porn"
]
1.78 ms
(1.10%)
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.