Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.52 ms
(81.07%)
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
  355579
  384239
  386823
  394204
  400233
  403761
  414008
  415584
  418971
  419014
  420238
  444135
  451545
  451715
  453129
  453155
  453453
  455320
  455351
  457224
  457302
  458233
  458692
  460059
  460174
  460424
  464008
  464459
  465996
  470716
  471003
  471821
  471973
  472160
  473981
  474122
  474142
  480639
  481797
  481851
  482923
  483567
  485286
  485754
  486441
  492553
  494959
  494967
  497441
  499010
  499065
  500643
  501028
  501915
  503949
  504195
  504384
  508723
  509360
  512249
  512739
  513051
  513832
  514694
  516834
  518145
  518980
  519433
  519659
  522265
  523729
  525980
  526463
  526687
  532999
  534278
  542602
  545895
  546631
  548024
  548788
  550502
  561886
  562291
  565773
  567405
  570199
  573371
  573716
  577364
  578495
  581901
  584128
  584152
  591004
  591061
  591514
  591549
  599010
  599720
  609271
  610112
  619582
  620054
  620430
  621687
  622410
  631253
  642404
  663875
  680904
  682187
  682234
  687190
  725722
  731048
  796552
  801426
  802074
  810421
]
21.55 ms
(12.89%)
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
  599720
  512739
  561886
  546631
  621687
  591514
  591549
  465996
  481851
  610112
  599010
  642404
  500643
  522265
  534278
  578495
  494959
  573716
  508723
  474122
  663875
  457224
  471973
  499065
  403761
  458233
  482923
  584128
  485286
  472160
  542602
  386823
  503949
  570199
  573371
  394204
  509360
  584152
  415584
  526687
  591061
  497441
  513832
  514694
  567405
  518980
  581901
  501028
  471003
  577364
  464459
  474142
  455320
  550502
  562291
  622410
  526463
  486441
  519659
  516834
  464008
  451545
  504195
  525980
  682187
  619582
  420238
  418971
  501915
  513051
  451715
  483567
  519433
  481797
  485754
  458692
  492553
  453453
  453155
  457302
  523729
  480639
  545895
  682234
  680904
  731048
  473981
  460424
  548788
  532999
  499010
  620054
  609271
  444135
  414008
  565773
  470716
  453129
  504384
  687190
  518145
  512249
  460174
  460059
  494967
  455351
  471821
  419014
  548024
  620430
  355579
  802074
  801426
  796552
  631253
  725722
  810421
  591004
  384239
  400233
]
3.33 ms
(1.99%)
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
  355579
  384239
  386823
  394204
  400233
  403761
  414008
  415584
  418971
  419014
  420238
  444135
  451545
  451715
  453129
  453155
  453453
  455320
  455351
  457224
  457302
  458233
  458692
  460059
  460174
  460424
  464008
  464459
  465996
  470716
  471003
  471821
  471973
  472160
  473981
  474122
  474142
  480639
  481797
  481851
  482923
  483567
  485286
  485754
  486441
  492553
  494959
  494967
  497441
  499010
  499065
  500643
  501028
  501915
  503949
  504195
  504384
  508723
  509360
  512249
  512739
  513051
  513832
  514694
  516834
  518145
  518980
  519433
  519659
  522265
  523729
  525980
  526463
  526687
  532999
  534278
  542602
  545895
  546631
  548024
  548788
  550502
  561886
  562291
  565773
  567405
  570199
  573371
  573716
  577364
  578495
  581901
  584128
  584152
  591004
  591061
  591514
  591549
  599010
  599720
  609271
  610112
  619582
  620054
  620430
  621687
  622410
  631253
  642404
  663875
  680904
  682187
  682234
  687190
  725722
  731048
  796552
  801426
  802074
  810421
]
1.98 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "кухн секс"
]
1.72 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "kitchen sex"
]
1.56 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "кухн секс"
]
1.50 ms
(0.90%)
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.