Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.62 ms
(79.59%)
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
  391437
  397655
  401734
  408685
  411132
  420018
  422662
  424270
  428264
  436685
  439600
  440637
  444241
  446579
  452939
  453169
  455475
  461022
  461739
  461956
  466644
  468907
  470520
  475637
  483252
  486617
  487620
  490660
  491083
  493789
  494248
  495077
  495636
  496341
  496456
  505034
  505851
  509305
  509760
  510029
  511108
  511323
  514229
  516436
  518033
  521341
  521745
  521851
  527271
  528191
  529056
  531838
  535458
  539741
  542509
  544066
  544497
  547450
  547701
  547881
  549574
  552577
  554083
  554185
  554204
  555014
  555463
  556805
  558098
  558300
  559782
  560789
  568562
  570178
  580566
  581092
  583975
  584456
  584623
  584974
  586285
  587731
  589081
  590702
  591045
  591406
  592875
  593195
  593858
  593927
  595103
  595524
  596244
  598493
  599679
  601014
  601164
  601798
  602727
  602874
  603359
  604206
  605358
  605707
  607214
  607597
  615065
  618997
  622632
  623003
  623157
  624910
  629208
  639102
  650518
  659361
  672392
  782659
  784896
  796816
]
19.21 ms
(12.37%)
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
  615065
  623003
  587731
  590702
  592875
  595103
  622632
  593858
  593927
  595524
  602874
  639102
  784896
  607214
  782659
  391437
  401734
  428264
  436685
  466644
  424270
  453169
  446579
  461022
  483252
  397655
  420018
  440637
  461739
  470520
  452939
  539741
  509760
  527271
  528191
  495636
  521851
  496456
  516436
  531838
  535458
  475637
  493789
  544497
  547450
  547701
  547881
  555014
  584456
  584623
  542509
  544066
  549574
  558098
  559782
  560789
  568562
  580566
  583975
  552577
  554083
  554204
  581092
  659361
  672392
  650518
  556805
  584974
  586285
  591045
  591406
  598493
  601014
  601164
  604206
  607597
  629208
  601798
  603359
  618997
  596244
  599679
  605707
  589081
  593195
  602727
  605358
  623157
  624910
  796816
  444241
  455475
  408685
  411132
  439600
  422662
  461956
  505034
  505851
  511323
  521341
  487620
  491083
  494248
  495077
  511108
  486617
  496341
  514229
  468907
  490660
  509305
  521745
  510029
  529056
  518033
  555463
  558300
  570178
  554185
]
4.14 ms
(2.66%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "палец девушк"
]
3.01 ms
(1.94%)
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
  391437
  397655
  401734
  408685
  411132
  420018
  422662
  424270
  428264
  436685
  439600
  440637
  444241
  446579
  452939
  453169
  455475
  461022
  461739
  461956
  466644
  468907
  470520
  475637
  483252
  486617
  487620
  490660
  491083
  493789
  494248
  495077
  495636
  496341
  496456
  505034
  505851
  509305
  509760
  510029
  511108
  511323
  514229
  516436
  518033
  521341
  521745
  521851
  527271
  528191
  529056
  531838
  535458
  539741
  542509
  544066
  544497
  547450
  547701
  547881
  549574
  552577
  554083
  554185
  554204
  555014
  555463
  556805
  558098
  558300
  559782
  560789
  568562
  570178
  580566
  581092
  583975
  584456
  584623
  584974
  586285
  587731
  589081
  590702
  591045
  591406
  592875
  593195
  593858
  593927
  595103
  595524
  596244
  598493
  599679
  601014
  601164
  601798
  602727
  602874
  603359
  604206
  605358
  605707
  607214
  607597
  615065
  618997
  622632
  623003
  623157
  624910
  629208
  639102
  650518
  659361
  672392
  782659
  784896
  796816
]
2.05 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "finger girl"
]
1.68 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "палец девушк"
]
1.59 ms
(1.03%)
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.