Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.59 ms
(83.96%)
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
  389729
  390382
  390794
  391287
  391380
  412618
  421821
  421826
  421843
  421851
  421862
  421870
  421882
  421914
  421918
  422172
  422283
  422821
  423886
  426701
  429586
  433353
  433372
  433376
  439549
  439623
  439682
  439704
  439711
  439756
  439763
  439772
  439809
  443725
  448296
  448996
  449738
  450855
  453167
  454501
  457418
  457575
  462711
  465551
  466762
  467285
  468091
  474799
  475174
  475870
  477596
  479038
  483632
  483637
  485366
  490910
  491704
  493191
  493193
  493254
  494967
  495226
  495227
  500796
  502813
  510504
  510518
  513960
  516037
  516484
  521220
  523837
  523848
  524778
  526512
  526521
  526527
  527641
  537020
  542739
  542784
  545492
  546955
  549825
  550221
  555158
  555803
  560392
  560875
  560898
  563141
  563220
  564565
  573729
  576125
  578034
  579317
  581454
  584541
  585086
  586962
  588992
  590546
  596841
  599368
  600087
  600094
  601274
  603055
  608226
  609432
  611507
  616944
  619107
  625239
  649516
  761127
  778820
  779591
  805259
]
19.90 ms
(10.09%)
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
  422283
  439682
  429586
  462711
  510518
  493193
  479038
  542739
  546955
  550221
  563220
  389729
  423886
  426701
  474799
  475174
  421821
  439756
  468091
  475870
  391287
  421918
  433376
  466762
  439704
  439763
  465551
  421826
  421870
  433372
  439711
  477596
  527641
  483632
  483637
  490910
  493191
  495226
  510504
  493254
  494967
  500796
  502813
  523848
  537020
  485366
  495227
  523837
  608226
  599368
  619107
  422172
  439549
  585086
  453167
  545492
  560875
  560898
  581454
  564565
  555803
  560392
  649516
  555158
  563141
  576125
  584541
  600094
  596841
  601274
  611507
  616944
  590546
  600087
  609432
  779591
  778820
  805259
  761127
  421843
  457575
  467285
  421862
  421914
  439809
  391380
  412618
  422821
  448996
  450855
  390794
  421851
  433353
  443725
  448296
  449738
  491704
  524778
  526521
  516037
  521220
  526527
  586962
  588992
  439623
  390382
  421882
  439772
  457418
  454501
  516484
  513960
  526512
  625239
  579317
  542784
  549825
  573729
  578034
  603055
]
3.85 ms
(1.95%)
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
  389729
  390382
  390794
  391287
  391380
  412618
  421821
  421826
  421843
  421851
  421862
  421870
  421882
  421914
  421918
  422172
  422283
  422821
  423886
  426701
  429586
  433353
  433372
  433376
  439549
  439623
  439682
  439704
  439711
  439756
  439763
  439772
  439809
  443725
  448296
  448996
  449738
  450855
  453167
  454501
  457418
  457575
  462711
  465551
  466762
  467285
  468091
  474799
  475174
  475870
  477596
  479038
  483632
  483637
  485366
  490910
  491704
  493191
  493193
  493254
  494967
  495226
  495227
  500796
  502813
  510504
  510518
  513960
  516037
  516484
  521220
  523837
  523848
  524778
  526512
  526521
  526527
  527641
  537020
  542739
  542784
  545492
  546955
  549825
  550221
  555158
  555803
  560392
  560875
  560898
  563141
  563220
  564565
  573729
  576125
  578034
  579317
  581454
  584541
  585086
  586962
  588992
  590546
  596841
  599368
  600087
  600094
  601274
  603055
  608226
  609432
  611507
  616944
  619107
  625239
  649516
  761127
  778820
  779591
  805259
]
2.48 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian mom doggy"
]
1.87 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск mom рак"
]
1.68 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск mom рак"
]

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.