Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.61 ms
(81.78%)
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
  419093
  427614
  428798
  434168
  437336
  440645
  442288
  442783
  445884
  446295
  448362
  449361
  453273
  453307
  455976
  459407
  460370
  460728
  465270
  467932
  469952
  477335
  479629
  480833
  483162
  484398
  490409
  490929
  491021
  491208
  491988
  501338
  502197
  502695
  502995
  504772
  508474
  509033
  509328
  512551
  513141
  515018
  515022
  515839
  517000
  518040
  518735
  519023
  519034
  520694
  520697
  523256
  523832
  524848
  525012
  525116
  527444
  528084
  531920
  531996
  532129
  534168
  534377
  535344
  537122
  537123
  538008
  539512
  546878
  546944
  548870
  549822
  549840
  549845
  550644
  551923
  552043
  557128
  557177
  557551
  557558
  558003
  558176
  559008
  559067
  559687
  559696
  560410
  561601
  562598
  563141
  563218
  563450
  563456
  563898
  563931
  565982
  568346
  574384
  579284
  582249
  586682
  586962
  588992
  591198
  595956
  597874
  599368
  602672
  608437
  609803
  610588
  610660
  621734
  621966
  626266
  630475
  650806
  663380
  680838
]
20.30 ms
(12.15%)
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
  531996
  562598
  557177
  561601
  549822
  549840
  626266
  608437
  483162
  491988
  520694
  504772
  538008
  460728
  563450
  630475
  460370
  586682
  558176
  515018
  502197
  513141
  477335
  453273
  509328
  582249
  559687
  467932
  528084
  565982
  602672
  534168
  491021
  446295
  508474
  559696
  597874
  465270
  484398
  539512
  546878
  490929
  455976
  515022
  560410
  563931
  563898
  491208
  535344
  523256
  453307
  557558
  549845
  509033
  501338
  448362
  537123
  546944
  427614
  519023
  579284
  442783
  419093
  469952
  550644
  440645
  557128
  548870
  519034
  428798
  568346
  459407
  445884
  480833
  518735
  515839
  502995
  534377
  586962
  588992
  559008
  563218
  490409
  574384
  502695
  532129
  610588
  525116
  551923
  680838
  563141
  595956
  621734
  437336
  531920
  512551
  591198
  442288
  434168
  449361
  537122
  557551
  621966
  523832
  527444
  599368
  525012
  552043
  517000
  559067
  663380
  610660
  520697
  609803
  563456
  558003
  650806
  518040
  479629
  524848
]
2.65 ms
(1.59%)
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
  419093
  427614
  428798
  434168
  437336
  440645
  442288
  442783
  445884
  446295
  448362
  449361
  453273
  453307
  455976
  459407
  460370
  460728
  465270
  467932
  469952
  477335
  479629
  480833
  483162
  484398
  490409
  490929
  491021
  491208
  491988
  501338
  502197
  502695
  502995
  504772
  508474
  509033
  509328
  512551
  513141
  515018
  515022
  515839
  517000
  518040
  518735
  519023
  519034
  520694
  520697
  523256
  523832
  524848
  525012
  525116
  527444
  528084
  531920
  531996
  532129
  534168
  534377
  535344
  537122
  537123
  538008
  539512
  546878
  546944
  548870
  549822
  549840
  549845
  550644
  551923
  552043
  557128
  557177
  557551
  557558
  558003
  558176
  559008
  559067
  559687
  559696
  560410
  561601
  562598
  563141
  563218
  563450
  563456
  563898
  563931
  565982
  568346
  574384
  579284
  582249
  586682
  586962
  588992
  591198
  595956
  597874
  599368
  602672
  608437
  609803
  610588
  610660
  621734
  621966
  626266
  630475
  650806
  663380
  680838
]
2.20 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "panties step mom"
]
1.83 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "трусик нижн бел step mom"
]
1.66 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "трусик нижн бел step mom"
]

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.