Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.90 ms
(82.79%)
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
  373859
  378035
  399705
  399930
  400469
  400723
  402789
  403293
  411842
  413109
  413426
  413707
  414760
  414799
  414974
  415090
  417722
  418978
  421633
  422623
  422925
  423271
  423540
  423767
  426138
  427378
  429345
  429873
  444198
  444938
  445082
  446252
  459234
  459801
  461306
  463665
  466916
  468274
  470181
  470299
  471821
  475750
  479473
  479946
  482075
  483531
  484846
  485161
  489042
  490771
  494111
  494426
  496448
  496940
  498852
  499502
  501036
  502110
  505230
  506807
  511233
  513505
  515821
  516777
  521779
  523268
  523653
  524052
  528004
  529262
  529445
  545717
  547877
  551167
  552326
  552903
  555742
  555812
  557984
  560587
  560938
  561818
  563880
  565331
  568098
  570004
  570010
  573327
  573834
  573910
  574609
  574783
  574825
  574880
  575524
  576085
  576097
  578461
  581901
  581959
  583240
  585599
  586835
  587863
  589108
  590431
  594790
  594893
  602495
  605984
  607154
  613426
  624762
  651561
  659594
  659803
  740187
  789399
  810706
]
16.88 ms
(10.84%)
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
  475750
  573910
  574880
  574825
  576097
  573834
  399930
  468274
  479946
  400469
  413426
  494111
  502110
  516777
  529262
  413707
  511233
  490771
  521779
  573327
  651561
  555812
  605984
  587863
  607154
  373859
  659803
  659594
  602495
  740187
  764819
  506807
  585599
  789399
  560938
  560587
  547877
  594893
  471821
  513505
  403293
  586835
  590431
  613426
  414760
  426138
  444198
  545717
  463665
  524052
  624762
  378035
  399705
  422623
  444938
  423540
  415090
  446252
  552326
  555742
  565331
  576085
  578461
  551167
  557984
  568098
  575524
  594790
  414799
  421633
  422925
  423767
  470181
  470299
  445082
  417722
  496940
  499502
  523268
  484846
  489042
  505230
  515821
  583240
  570004
  418978
  429873
  429345
  485161
  459234
  581959
  563880
  561818
  581901
  589108
  414974
  466916
  479473
  423271
  483531
  494426
  496448
  498852
  501036
  523653
  528004
  529445
  552903
  411842
  413109
  402789
  461306
  570010
  574783
  574609
  810706
  427378
  400723
  482075
  459801
]
2.75 ms
(1.76%)
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
  373859
  378035
  399705
  399930
  400469
  400723
  402789
  403293
  411842
  413109
  413426
  413707
  414760
  414799
  414974
  415090
  417722
  418978
  421633
  422623
  422925
  423271
  423540
  423767
  426138
  427378
  429345
  429873
  444198
  444938
  445082
  446252
  459234
  459801
  461306
  463665
  466916
  468274
  470181
  470299
  471821
  475750
  479473
  479946
  482075
  483531
  484846
  485161
  489042
  490771
  494111
  494426
  496448
  496940
  498852
  499502
  501036
  502110
  505230
  506807
  511233
  513505
  515821
  516777
  521779
  523268
  523653
  524052
  528004
  529262
  529445
  545717
  547877
  551167
  552326
  552903
  555742
  555812
  557984
  560587
  560938
  561818
  563880
  565331
  568098
  570004
  570010
  573327
  573834
  573910
  574609
  574783
  574825
  574880
  575524
  576085
  576097
  578461
  581901
  581959
  583240
  585599
  586835
  587863
  589108
  590431
  594790
  594893
  602495
  605984
  607154
  613426
  624762
  651561
  659594
  659803
  740187
  789399
  810706
]
1.90 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в рот худую"
]
1.86 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в рот худая"
]
1.77 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "в рот худая"
]
1.65 ms
(1.06%)
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.