Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
190.81 ms
(87.10%)
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
  6670
  12710
  14599
  44968
  51972
  68383
  76836
  107362
  129791
  150507
  184909
  185208
  205910
  265933
  318318
  336987
  363488
  374819
  381854
  381875
  382172
  382857
  383145
  386613
  387625
  388149
  388264
  390758
  391393
  395463
  395833
  396069
  396191
  396421
  397793
  399187
  400906
  401966
  404000
  405082
  407298
  407434
  408987
  409867
  414432
  415836
  416335
  418552
  418835
  419845
  420348
  424280
  424541
  432504
  434656
  435289
  435462
  439900
  444243
  448403
  452369
  453352
  456090
  457283
  458031
  458570
  461892
  464284
  467216
  468176
  470563
  473314
  483328
  485371
  486316
  486640
  487283
  490164
  492601
  497515
  499891
  505846
  506766
  512103
  513207
  514577
  518270
  521401
  522351
  522547
  525749
  527416
  538803
  541332
  543479
  547947
  552969
  554425
  562219
  565185
  565351
  566356
  567024
  569684
  573065
  576138
  578138
  583678
  589769
  597866
  598151
  599475
  611375
  616787
  629017
  636268
  642121
  659347
  724753
  794126
]
18.66 ms
(8.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
  569684
  573065
  6670
  395833
  396191
  397793
  405082
  499891
  512103
  492601
  497515
  541332
  415836
  435462
  458031
  629017
  453352
  456090
  486316
  383145
  185208
  184909
  265933
  388264
  418552
  424541
  598151
  444243
  487283
  382857
  129791
  318318
  381854
  381875
  382172
  44968
  14599
  396069
  435289
  461892
  468176
  578138
  599475
  401966
  467216
  473314
  470563
  205910
  439900
  525749
  522547
  565351
  583678
  552969
  543479
  554425
  565185
  567024
  659347
  589769
  636268
  611375
  597866
  616787
  518270
  522351
  527416
  538803
  483328
  514577
  485371
  513207
  386613
  68383
  76836
  150507
  107362
  51972
  388149
  419845
  409867
  458570
  457283
  562219
  576138
  642121
  794126
  724753
  424280
  374819
  390758
  404000
  407434
  432504
  400906
  521401
  387625
  448403
  416335
  414432
  506766
  505846
  418835
  336987
  363488
  12710
  396421
  420348
  434656
  486640
  452369
  490164
  464284
  547947
  566356
  391393
  395463
  399187
  407298
  408987
]
2.37 ms
(1.08%)
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
  6670
  12710
  14599
  44968
  51972
  68383
  76836
  107362
  129791
  150507
  184909
  185208
  205910
  265933
  318318
  336987
  363488
  374819
  381854
  381875
  382172
  382857
  383145
  386613
  387625
  388149
  388264
  390758
  391393
  395463
  395833
  396069
  396191
  396421
  397793
  399187
  400906
  401966
  404000
  405082
  407298
  407434
  408987
  409867
  414432
  415836
  416335
  418552
  418835
  419845
  420348
  424280
  424541
  432504
  434656
  435289
  435462
  439900
  444243
  448403
  452369
  453352
  456090
  457283
  458031
  458570
  461892
  464284
  467216
  468176
  470563
  473314
  483328
  485371
  486316
  486640
  487283
  490164
  492601
  497515
  499891
  505846
  506766
  512103
  513207
  514577
  518270
  521401
  522351
  522547
  525749
  527416
  538803
  541332
  543479
  547947
  552969
  554425
  562219
  565185
  565351
  566356
  567024
  569684
  573065
  576138
  578138
  583678
  589769
  597866
  598151
  599475
  611375
  616787
  629017
  636268
  642121
  659347
  724753
  794126
]
2.14 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мужик баба"
]
1.74 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мужчин женскийрод"
]
1.56 ms
(0.71%)
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.