Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.41 ms
(82.83%)
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
  85949
  233692
  239599
  382542
  384033
  387455
  389693
  391113
  397135
  405324
  406973
  407391
  409390
  411004
  411262
  412122
  416233
  417106
  419371
  421010
  422034
  423264
  424321
  425523
  427475
  427985
  429757
  430361
  433497
  443704
  444212
  444526
  445515
  446608
  449435
  451541
  451748
  452028
  452377
  452513
  454046
  455788
  457101
  459766
  460567
  460917
  461244
  461547
  466138
  467559
  467979
  470112
  470604
  477230
  477346
  477724
  479401
  483212
  487718
  487843
  489409
  489423
  491535
  493394
  494394
  496355
  498236
  498306
  499998
  500482
  501767
  501923
  504183
  510251
  510398
  511023
  511154
  512337
  513390
  513927
  514019
  515143
  518284
  520329
  521251
  521993
  522529
  528522
  537402
  538196
  538226
  547886
  551649
  552133
  552588
  554311
  558843
  559002
  562361
  563007
  567810
  567890
  574781
  575456
  582811
  595818
  597559
  602506
  606695
  621980
  636111
  655097
  655358
  657667
  657680
  658269
  659703
  710301
  716586
  781747
]
20.64 ms
(11.52%)
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
  387455
  411004
  459766
  499998
  528522
  412122
  547886
  444212
  512337
  538196
  477346
  554311
  461244
  567810
  460917
  522529
  606695
  454046
  567890
  411262
  419371
  477230
  537402
  657667
  655097
  491535
  433497
  421010
  449435
  455788
  483212
  498306
  423264
  710301
  457101
  510251
  538226
  500482
  504183
  513927
  382542
  406973
  444526
  425523
  597559
  384033
  515143
  405324
  427475
  466138
  430361
  595818
  451541
  407391
  496355
  552588
  657680
  563007
  427985
  452377
  489423
  574781
  575456
  552133
  559002
  659703
  494394
  409390
  479401
  446608
  513390
  514019
  518284
  493394
  487718
  520329
  558843
  636111
  429757
  460567
  470112
  511154
  498236
  501767
  397135
  487843
  510398
  389693
  424321
  452028
  602506
  511023
  551649
  391113
  501923
  489409
  443704
  467559
  470604
  452513
  582811
  416233
  233692
  658269
  621980
  562361
  461547
  467979
  521251
  417106
  781747
  716586
  451748
  239599
  422034
  85949
  521993
  477724
  655358
  445515
]
2.80 ms
(1.56%)
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
  85949
  233692
  239599
  382542
  384033
  387455
  389693
  391113
  397135
  405324
  406973
  407391
  409390
  411004
  411262
  412122
  416233
  417106
  419371
  421010
  422034
  423264
  424321
  425523
  427475
  427985
  429757
  430361
  433497
  443704
  444212
  444526
  445515
  446608
  449435
  451541
  451748
  452028
  452377
  452513
  454046
  455788
  457101
  459766
  460567
  460917
  461244
  461547
  466138
  467559
  467979
  470112
  470604
  477230
  477346
  477724
  479401
  483212
  487718
  487843
  489409
  489423
  491535
  493394
  494394
  496355
  498236
  498306
  499998
  500482
  501767
  501923
  504183
  510251
  510398
  511023
  511154
  512337
  513390
  513927
  514019
  515143
  518284
  520329
  521251
  521993
  522529
  528522
  537402
  538196
  538226
  547886
  551649
  552133
  552588
  554311
  558843
  559002
  562361
  563007
  567810
  567890
  574781
  575456
  582811
  595818
  597559
  602506
  606695
  621980
  636111
  655097
  655358
  657667
  657680
  658269
  659703
  710301
  716586
  781747
]
2.18 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "секс с другим партнёром"
]
1.88 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс друг парен"
]
1.69 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс друг парен"
]
1.57 ms
(0.88%)
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.