Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.18 ms
(85.18%)
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
  118086
  154206
  154707
  155198
  357499
  383742
  383924
  385390
  389339
  391994
  392311
  414271
  418594
  422713
  423927
  428282
  432680
  435539
  439572
  440995
  443087
  444537
  445470
  446797
  448090
  449586
  462337
  465125
  466739
  467557
  476158
  476847
  484065
  487200
  489338
  490380
  493477
  496340
  498037
  498697
  500290
  506105
  510818
  519313
  519760
  526042
  526608
  528318
  529347
  530011
  531524
  532856
  534082
  537232
  541325
  545305
  545384
  546042
  553734
  558010
  559360
  567323
  569656
  569995
  580139
  583033
  587273
  590255
  593105
  597167
  600087
  601071
  603691
  605711
  608076
  609892
  614328
  614978
  622297
  624399
  628113
  631448
  633887
  634071
  639804
  639809
  648673
  651674
  658789
  660380
  675545
  679972
  680164
  695559
  709555
  710194
  710877
  715790
  717535
  722388
  725619
  735202
  745026
  745100
  745129
  745136
  756505
  759370
  782281
  782792
  791003
  791012
  796650
  801615
  814024
  816776
  818733
  822298
  822488
  824340
]
17.87 ms
(9.75%)
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
  559360
  593105
  735202
  709555
  710877
  414271
  569656
  824340
  510818
  519313
  444537
  432680
  528318
  155198
  389339
  587273
  440995
  446797
  531524
  383742
  435539
  498697
  541325
  717535
  658789
  680164
  634071
  614328
  603691
  639804
  600087
  633887
  745026
  745136
  715790
  791012
  118086
  526608
  519760
  498037
  567323
  580139
  487200
  651674
  553734
  558010
  675545
  710194
  818733
  816776
  822298
  814024
  532856
  534082
  660380
  695559
  631448
  608076
  601071
  624399
  628113
  597167
  796650
  782792
  745129
  745100
  725619
  759370
  722388
  782281
  801615
  385390
  545305
  493477
  443087
  462337
  466739
  496340
  500290
  484065
  545384
  569995
  428282
  418594
  448090
  526042
  614978
  449586
  476847
  423927
  476158
  648673
  583033
  609892
  590255
  154707
  422713
  622297
  383924
  391994
  445470
  465125
  357499
  439572
  392311
  605711
  529347
  489338
  467557
  490380
  506105
  546042
  639809
  530011
  154206
  822488
  537232
  679972
  791003
  756505
]
2.64 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
  118086
  154206
  154707
  155198
  357499
  383742
  383924
  385390
  389339
  391994
  392311
  414271
  418594
  422713
  423927
  428282
  432680
  435539
  439572
  440995
  443087
  444537
  445470
  446797
  448090
  449586
  462337
  465125
  466739
  467557
  476158
  476847
  484065
  487200
  489338
  490380
  493477
  496340
  498037
  498697
  500290
  506105
  510818
  519313
  519760
  526042
  526608
  528318
  529347
  530011
  531524
  532856
  534082
  537232
  541325
  545305
  545384
  546042
  553734
  558010
  559360
  567323
  569656
  569995
  580139
  583033
  587273
  590255
  593105
  597167
  600087
  601071
  603691
  605711
  608076
  609892
  614328
  614978
  622297
  624399
  628113
  631448
  633887
  634071
  639804
  639809
  648673
  651674
  658789
  660380
  675545
  679972
  680164
  695559
  709555
  710194
  710877
  715790
  717535
  722388
  725619
  735202
  745026
  745100
  745129
  745136
  756505
  759370
  782281
  782792
  791003
  791012
  796650
  801615
  814024
  816776
  818733
  822298
  822488
  824340
]
1.86 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fisting stockings"
]
1.68 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фистинг чулк нижн бел"
]
1.57 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.84%)
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.