Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.07 ms
(82.69%)
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
  14382
  358942
  383250
  384527
  390466
  391034
  392333
  395564
  396647
  398756
  398878
  399568
  400638
  401426
  405045
  405482
  408539
  410524
  412083
  414268
  414369
  414978
  416031
  416292
  417177
  417179
  420484
  421153
  421201
  423782
  424671
  425967
  426268
  426567
  428249
  429747
  433239
  435624
  437864
  442679
  442737
  444348
  446025
  447473
  448200
  456148
  457590
  457801
  460726
  461602
  462554
  464209
  467395
  470648
  470915
  474004
  474029
  475441
  476619
  477147
  477347
  477412
  477761
  481582
  482085
  484845
  484924
  486799
  488550
  490729
  491250
  491351
  494484
  494666
  494771
  497573
  502301
  503507
  506580
  508093
  508541
  512289
  512597
  514642
  517101
  517690
  521291
  522791
  522792
  523479
  523975
  525688
  527825
  540143
  543971
  546684
  548866
  552162
  552216
  554798
  559392
  570414
  575096
  584415
  586575
  590667
  592314
  595401
  597186
  598142
  602966
  603295
  603661
  609276
  609280
  620100
  621410
  622832
  659328
  731371
]
19.78 ms
(11.35%)
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
  546684
  552162
  575096
  543971
  552216
  570414
  731371
  482085
  423782
  428249
  448200
  462554
  470915
  477347
  398878
  442737
  444348
  383250
  426268
  481582
  503507
  512597
  523975
  490729
  523479
  527825
  497573
  506580
  512289
  521291
  508093
  559392
  609276
  595401
  603295
  621410
  437864
  508541
  586575
  554798
  597186
  620100
  602966
  484924
  525688
  659328
  590667
  598142
  609280
  622832
  461602
  491250
  392333
  390466
  396647
  398756
  400638
  401426
  405482
  429747
  410524
  424671
  442679
  408539
  414978
  421153
  474004
  486799
  484845
  494666
  502301
  540143
  488550
  548866
  592314
  603661
  14382
  475441
  358942
  405045
  414268
  464209
  384527
  457590
  460726
  467395
  476619
  477761
  399568
  457801
  474029
  477147
  417179
  446025
  447473
  456148
  517690
  522792
  494771
  522791
  491351
  514642
  517101
  494484
  584415
  470648
  477412
  417177
  395564
  391034
  416031
  421201
  433239
  416292
  426567
  412083
  414369
  420484
  425967
  435624
]
3.20 ms
(1.83%)
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
  14382
  358942
  383250
  384527
  390466
  391034
  392333
  395564
  396647
  398756
  398878
  399568
  400638
  401426
  405045
  405482
  408539
  410524
  412083
  414268
  414369
  414978
  416031
  416292
  417177
  417179
  420484
  421153
  421201
  423782
  424671
  425967
  426268
  426567
  428249
  429747
  433239
  435624
  437864
  442679
  442737
  444348
  446025
  447473
  448200
  456148
  457590
  457801
  460726
  461602
  462554
  464209
  467395
  470648
  470915
  474004
  474029
  475441
  476619
  477147
  477347
  477412
  477761
  481582
  482085
  484845
  484924
  486799
  488550
  490729
  491250
  491351
  494484
  494666
  494771
  497573
  502301
  503507
  506580
  508093
  508541
  512289
  512597
  514642
  517101
  517690
  521291
  522791
  522792
  523479
  523975
  525688
  527825
  540143
  543971
  546684
  548866
  552162
  552216
  554798
  559392
  570414
  575096
  584415
  586575
  590667
  592314
  595401
  597186
  598142
  602966
  603295
  603661
  609276
  609280
  620100
  621410
  622832
  659328
  731371
]
2.08 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "две бабы"
]
2.04 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "две женскийрод"
]
1.45 ms
(0.83%)
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.