Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.13 ms
(82.56%)
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
  69704
  70132
  81510
  418088
  423564
  426011
  434569
  446661
  474060
  475503
  477393
  477872
  486668
  489260
  489316
  494272
  496059
  496510
  502211
  506156
  510593
  510888
  511420
  513920
  515875
  517377
  519375
  520241
  521701
  528756
  529458
  532567
  532580
  542569
  547533
  557071
  559158
  559817
  563386
  567037
  570857
  573217
  576771
  579390
  581992
  582007
  585939
  587087
  590254
  590739
  592499
  600712
  600726
  600966
  603031
  603708
  603795
  604635
  610053
  612959
  617589
  628669
  629558
  629647
  629656
  629893
  630306
  636558
  647143
  655767
  656268
  662002
  662062
  673664
  675821
  682321
  684447
  686759
  693013
  694127
  695782
  699494
  700689
  703511
  704840
  709707
  710754
  710817
  710864
  717185
  718899
  719207
  721042
  721845
  725025
  726293
  733325
  734213
  735511
  738114
  738898
  738911
  739719
  743385
  745981
  746432
  746612
  751860
  755534
  755959
  757543
  757803
  758307
  758869
  760624
  761160
  773639
  789823
  799721
  800091
]
19.73 ms
(11.97%)
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
  547533
  567037
  710817
  718899
  647143
  694127
  709707
  662002
  695782
  704840
  710754
  710864
  587087
  629656
  734213
  743385
  773639
  725025
  738898
  746612
  755959
  757803
  738911
  746432
  726293
  738114
  760624
  761160
  629558
  700689
  721845
  81510
  69704
  532567
  520241
  600966
  423564
  519375
  521701
  557071
  563386
  682321
  686759
  610053
  474060
  477393
  559158
  542569
  590739
  510888
  489260
  592499
  506156
  70132
  612959
  717185
  489316
  529458
  570857
  576771
  655767
  656268
  662062
  719207
  675821
  693013
  721042
  600726
  636558
  600712
  617589
  628669
  758869
  789823
  800091
  733325
  735511
  755534
  745981
  751860
  739719
  757543
  758307
  604635
  630306
  703511
  477872
  418088
  511420
  517377
  629893
  799721
  532580
  579390
  673664
  559817
  590254
  486668
  510593
  496510
  502211
  496059
  513920
  573217
  582007
  581992
  684447
  585939
  603795
  629647
  603708
  603031
  434569
  446661
  426011
  475503
  515875
  528756
  494272
  699494
]
2.50 ms
(1.52%)
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
  69704
  70132
  81510
  418088
  423564
  426011
  434569
  446661
  474060
  475503
  477393
  477872
  486668
  489260
  489316
  494272
  496059
  496510
  502211
  506156
  510593
  510888
  511420
  513920
  515875
  517377
  519375
  520241
  521701
  528756
  529458
  532567
  532580
  542569
  547533
  557071
  559158
  559817
  563386
  567037
  570857
  573217
  576771
  579390
  581992
  582007
  585939
  587087
  590254
  590739
  592499
  600712
  600726
  600966
  603031
  603708
  603795
  604635
  610053
  612959
  617589
  628669
  629558
  629647
  629656
  629893
  630306
  636558
  647143
  655767
  656268
  662002
  662062
  673664
  675821
  682321
  684447
  686759
  693013
  694127
  695782
  699494
  700689
  703511
  704840
  709707
  710754
  710817
  710864
  717185
  718899
  719207
  721042
  721845
  725025
  726293
  733325
  734213
  735511
  738114
  738898
  738911
  739719
  743385
  745981
  746432
  746612
  751860
  755534
  755959
  757543
  757803
  758307
  758869
  760624
  761160
  773639
  789823
  799721
  800091
]
2.29 ms
(1.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "большой член нарезка"
]
1.60 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.37 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большой большие член подборк"
]
1.25 ms
(0.76%)
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.