Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.69 ms
(86.32%)
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
  188610
  233365
  323041
  388700
  388767
  390205
  391517
  391938
  391967
  392603
  394190
  394420
  400697
  400722
  400988
  401807
  409935
  411322
  411757
  421895
  422400
  422989
  424240
  424269
  424274
  424435
  434360
  436948
  440339
  443692
  443715
  443772
  443827
  451521
  452308
  454177
  454275
  454513
  456000
  460730
  460900
  462305
  462714
  465388
  466262
  466270
  466310
  467263
  467284
  467523
  468167
  470275
  470715
  470717
  470774
  473328
  473949
  474074
  474200
  474681
  474792
  475621
  475903
  475927
  476258
  476377
  477904
  478350
  479967
  480886
  486107
  486357
  487185
  489224
  494559
  495224
  495254
  496822
  502729
  502805
  505773
  506432
  506731
  507003
  509210
  514585
  516916
  517711
  518846
  522759
  523876
  546011
  552837
  555118
  560380
  563401
  563456
  564661
  572203
  580640
  589022
  609238
  620233
  620240
  620241
  662432
  669507
  703448
  712542
  712563
  716703
  727760
  729205
  740593
  761607
  778654
  784700
  791330
  804927
  813532
]
13.71 ms
(8.12%)
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
  424269
  456000
  479967
  784700
  391938
  506432
  452308
  400722
  392603
  394190
  563401
  703448
  546011
  778654
  443715
  409935
  454275
  388700
  390205
  475927
  443827
  470275
  411322
  462305
  813532
  467523
  466262
  474681
  514585
  475621
  580640
  473328
  477904
  424240
  509210
  486107
  486357
  609238
  323041
  476377
  473949
  572203
  424435
  424274
  470715
  516916
  478350
  620233
  727760
  467263
  436948
  421895
  465388
  466270
  468167
  454177
  422989
  443692
  487185
  496822
  518846
  495254
  451521
  454513
  589022
  552837
  480886
  507003
  662432
  522759
  804927
  564661
  712542
  712563
  716703
  411757
  233365
  560380
  462714
  474200
  494559
  505773
  400988
  460730
  422400
  476258
  502729
  443772
  506731
  394420
  563456
  467284
  669507
  791330
  440339
  391967
  502805
  466310
  517711
  391517
  740593
  620241
  729205
  761607
  388767
  470774
  523876
  474792
  460900
  495224
  400697
  188610
  489224
  555118
  434360
  470717
  401807
  620240
  474074
  475903
]
2.44 ms
(1.44%)
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
  188610
  233365
  323041
  388700
  388767
  390205
  391517
  391938
  391967
  392603
  394190
  394420
  400697
  400722
  400988
  401807
  409935
  411322
  411757
  421895
  422400
  422989
  424240
  424269
  424274
  424435
  434360
  436948
  440339
  443692
  443715
  443772
  443827
  451521
  452308
  454177
  454275
  454513
  456000
  460730
  460900
  462305
  462714
  465388
  466262
  466270
  466310
  467263
  467284
  467523
  468167
  470275
  470715
  470717
  470774
  473328
  473949
  474074
  474200
  474681
  474792
  475621
  475903
  475927
  476258
  476377
  477904
  478350
  479967
  480886
  486107
  486357
  487185
  489224
  494559
  495224
  495254
  496822
  502729
  502805
  505773
  506432
  506731
  507003
  509210
  514585
  516916
  517711
  518846
  522759
  523876
  546011
  552837
  555118
  560380
  563401
  563456
  564661
  572203
  580640
  589022
  609238
  620233
  620240
  620241
  662432
  669507
  703448
  712542
  712563
  716703
  727760
  729205
  740593
  761607
  778654
  784700
  791330
  804927
  813532
]
1.97 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "минет русской женщины…"
]
1.74 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс русск женщин"
]
1.63 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.96%)
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.