Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.61 ms
(55.30%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск шлюх"
]
148.41 ms
(38.78%)
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
  391910
  426725
  479293
  482882
  482892
  504464
  507411
  510309
  527159
  543680
  545029
  546907
  555067
  562299
  563405
  563583
  570260
  570371
  579979
  598445
  601271
  603961
  610396
  613433
  618773
  621400
  621519
  621671
  622887
  626862
  626878
  627059
  629072
  630737
  640236
  660074
  678722
  681355
  682726
  685391
  686383
  692288
  692449
  698238
  701992
  705360
  705472
  706542
  709190
  713323
  713940
  724891
  727111
  732725
  732806
  734052
  736886
  736975
  736985
  740597
  741080
  741766
  742818
  743030
  743464
  744890
  746229
  746699
  752732
  754052
  754060
  757613
  757630
  758035
  762746
  765941
  766076
  766717
  769072
  769952
  770567
  773830
  777264
  777663
  778075
  778088
  778149
  778932
  779863
  781512
  781666
  782120
  782262
  786620
  787106
  787496
  788431
  788866
  789926
  790075
  790817
  792438
  793241
  793765
  796726
  800003
  800644
  802554
  804389
  804896
  805352
  807290
  807484
  808794
  809613
  810532
  810722
  812131
  813283
]
14.01 ms
(3.66%)
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
  732725
  773830
  727111
  736886
  744890
  629072
  698238
  777264
  778088
  781666
  787106
  800003
  809613
  482892
  570371
  563405
  426725
  479293
  527159
  504464
  507411
  510309
  555067
  543680
  713323
  686383
  705360
  713940
  660074
  678722
  681355
  682726
  685391
  692449
  610396
  627059
  603961
  626878
  630737
  778075
  778149
  786620
  807484
  808794
  810722
  778932
  790075
  792438
  807290
  787496
  793241
  804896
  812131
  754052
  754060
  769952
  746229
  757613
  743030
  746699
  734052
  743464
  757630
  758035
  766717
  706542
  782120
  800644
  805352
  692288
  598445
  740597
  613433
  391910
  570260
  742818
  482882
  546907
  562299
  545029
  563583
  701992
  705472
  709190
  579979
  598922
  626862
  640236
  601271
  622887
  618773
  621400
  621519
  621671
  777663
  788431
  790817
  793765
  810532
  779863
  782262
  788866
  796726
  802554
  804389
  724891
  736975
  752732
  762746
  769072
  770567
  781512
  789926
  813283
  741080
  765941
  766076
  732806
  736985
  741766
]
4.29 ms
(1.12%)
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
  391910
  426725
  479293
  482882
  482892
  504464
  507411
  510309
  527159
  543680
  545029
  546907
  555067
  562299
  563405
  563583
  570260
  570371
  579979
  598445
  601271
  603961
  610396
  613433
  618773
  621400
  621519
  621671
  622887
  626862
  626878
  627059
  629072
  630737
  640236
  660074
  678722
  681355
  682726
  685391
  686383
  692288
  692449
  698238
  701992
  705360
  705472
  706542
  709190
  713323
  713940
  724891
  727111
  732725
  732806
  734052
  736886
  736975
  736985
  740597
  741080
  741766
  742818
  743030
  743464
  744890
  746229
  746699
  752732
  754052
  754060
  757613
  757630
  758035
  762746
  765941
  766076
  766717
  769072
  769952
  770567
  773830
  777264
  777663
  778075
  778088
  778149
  778932
  779863
  781512
  781666
  782120
  782262
  786620
  787106
  787496
  788431
  788866
  789926
  790075
  790817
  792438
  793241
  793765
  796726
  800003
  800644
  802554
  804389
  804896
  805352
  807290
  807484
  808794
  809613
  810532
  810722
  812131
  813283
]
1.60 ms
(0.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русская шлюх"
]
1.42 ms
(0.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск шлюх"
]
1.35 ms
(0.35%)
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.