Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
213.97 ms
(54.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "her жоп"
]
155.18 ms
(39.52%)
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
  28625
  62124
  118472
  170069
  278472
  394670
  406044
  408499
  420328
  486209
  504687
  511906
  513163
  514957
  516014
  516308
  526849
  531849
  533090
  534100
  535993
  537837
  555632
  566274
  567126
  571941
  585853
  589058
  611040
  623290
  623959
  624939
  625688
  626362
  627412
  627772
  630096
  638904
  648481
  662146
  666820
  668084
  679190
  685540
  693490
  698719
  703328
  703480
  707819
  707840
  710223
  710364
  714011
  717817
  720328
  724074
  724131
  725156
  725194
  725253
  726671
  731259
  731301
  732622
  735084
  735898
  736925
  740002
  740876
  740929
  743170
  744775
  747625
  750362
  751181
  752405
  759939
  761030
  762941
  763503
  764151
  764865
  765632
  766821
  766959
  766971
  767268
  773384
  778717
  780763
  782446
  782604
  783197
  783567
  783819
  784337
  785811
  786012
  788099
  790080
  794131
  796131
  796157
  799354
  800473
  800549
  800631
  803721
  804086
  805277
  807285
  807370
  809806
  810037
  813295
  813805
  813915
  816201
  823922
  826030
]
14.30 ms
(3.64%)
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
  504687
  526849
  555632
  566274
  703480
  648481
  685540
  626362
  630096
  585853
  627772
  785811
  796131
  800631
  782446
  782604
  803721
  725156
  766959
  788099
  725194
  731259
  763503
  735898
  765632
  783197
  28625
  394670
  406044
  420328
  516308
  813915
  679190
  717817
  627412
  743170
  764151
  714011
  766821
  752405
  761030
  767268
  804086
  810037
  118472
  535993
  531849
  486209
  668084
  707840
  662146
  698719
  710364
  703328
  707819
  720328
  778717
  783567
  786012
  813295
  736925
  747625
  750362
  751181
  773384
  783819
  796157
  800549
  805277
  807285
  724131
  735084
  744775
  762941
  732622
  807370
  809806
  516014
  826030
  513163
  514957
  589058
  623290
  638904
  623959
  740002
  724074
  764865
  740929
  611040
  759939
  537837
  567126
  624939
  625688
  780763
  790080
  726671
  731301
  766971
  799354
  62124
  710223
  816201
  823922
  666820
  693490
  725253
  784337
  794131
  800473
  740876
  170069
  278472
  408499
  813805
  534100
  533090
  511906
  571941
]
3.45 ms
(0.88%)
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
  28625
  62124
  118472
  170069
  278472
  394670
  406044
  408499
  420328
  486209
  504687
  511906
  513163
  514957
  516014
  516308
  526849
  531849
  533090
  534100
  535993
  537837
  555632
  566274
  567126
  571941
  585853
  589058
  611040
  623290
  623959
  624939
  625688
  626362
  627412
  627772
  630096
  638904
  648481
  662146
  666820
  668084
  679190
  685540
  693490
  698719
  703328
  703480
  707819
  707840
  710223
  710364
  714011
  717817
  720328
  724074
  724131
  725156
  725194
  725253
  726671
  731259
  731301
  732622
  735084
  735898
  736925
  740002
  740876
  740929
  743170
  744775
  747625
  750362
  751181
  752405
  759939
  761030
  762941
  763503
  764151
  764865
  765632
  766821
  766959
  766971
  767268
  773384
  778717
  780763
  782446
  782604
  783197
  783567
  783819
  784337
  785811
  786012
  788099
  790080
  794131
  796131
  796157
  799354
  800473
  800549
  800631
  803721
  804086
  805277
  807285
  807370
  809806
  810037
  813295
  813805
  813915
  816201
  823922
  826030
]
2.21 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "in her ass"
]
1.94 ms
(0.49%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "her жоп"
]

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.