Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
114.81 ms
(82.45%)
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
  8295
  185820
  357782
  389026
  395625
  402599
  405203
  405534
  405903
  406237
  407494
  407507
  412068
  413104
  415637
  415748
  417870
  419794
  421119
  422252
  426486
  430650
  448837
  450656
  451040
  453513
  453555
  459840
  461644
  461696
  462484
  471609
  472214
  473079
  476309
  476336
  476366
  478887
  479029
  481284
  482079
  489618
  490184
  492197
  496549
  496559
  501568
  503887
  506844
  507165
  507306
  508568
  509720
  513072
  518328
  519848
  521888
  522014
  523567
  526824
  527660
  540189
  543418
  551293
  551299
  551313
  551404
  566848
  568129
  569828
  575801
  576384
  576401
  583283
  584610
  591968
  597503
  598059
  604011
  607007
  609896
  610196
  613850
  614468
  618319
  619604
  624729
  624731
  636440
  641097
  643424
  644675
  648876
  654149
  654315
  654390
  658706
  660522
  660959
  661397
  665578
  689743
  713474
  717438
  727728
  728635
  728661
  734707
  743565
  746758
  756227
  773161
  773188
  777854
  787822
  795548
  795696
  796855
  803601
]
15.79 ms
(11.34%)
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
  641097
  598059
  727728
  609896
  357782
  415637
  461696
  422252
  472214
  506844
  451040
  507306
  568129
  624731
  513072
  523567
  714962
  618319
  803601
  795548
  448837
  478887
  575801
  613850
  453513
  476309
  415748
  521888
  519848
  551404
  551299
  526824
  576401
  604011
  619604
  406237
  405534
  508568
  522014
  489618
  413104
  419794
  453555
  450656
  689743
  481284
  476366
  636440
  796855
  654390
  607007
  479029
  461644
  482079
  490184
  509720
  658706
  660522
  665578
  795696
  743565
  734707
  773161
  644675
  787822
  654315
  648876
  654149
  614468
  597503
  402599
  405903
  417870
  426486
  476336
  569828
  624729
  746758
  583283
  591968
  430650
  405203
  503887
  395625
  462484
  496549
  496559
  501568
  543418
  551293
  584610
  643424
  756227
  473079
  421119
  471609
  389026
  492197
  507165
  407494
  407507
  412068
  518328
  576384
  566848
  527660
  8295
  185820
  459840
  540189
  660959
  661397
  728635
  728661
  773188
  610196
  713474
  717438
  777854
  551313
]
2.12 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
  8295
  185820
  357782
  389026
  395625
  402599
  405203
  405534
  405903
  406237
  407494
  407507
  412068
  413104
  415637
  415748
  417870
  419794
  421119
  422252
  426486
  430650
  448837
  450656
  451040
  453513
  453555
  459840
  461644
  461696
  462484
  471609
  472214
  473079
  476309
  476336
  476366
  478887
  479029
  481284
  482079
  489618
  490184
  492197
  496549
  496559
  501568
  503887
  506844
  507165
  507306
  508568
  509720
  513072
  518328
  519848
  521888
  522014
  523567
  526824
  527660
  540189
  543418
  551293
  551299
  551313
  551404
  566848
  568129
  569828
  575801
  576384
  576401
  583283
  584610
  591968
  597503
  598059
  604011
  607007
  609896
  610196
  613850
  614468
  618319
  619604
  624729
  624731
  636440
  641097
  643424
  644675
  648876
  654149
  654315
  654390
  658706
  660522
  660959
  661397
  665578
  689743
  713474
  717438
  727728
  728635
  728661
  734707
  743565
  746758
  756227
  773161
  773188
  777854
  787822
  795548
  795696
  796855
  803601
]
1.69 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "массаж вагин"
]
1.65 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "massage vagina"
]
1.60 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(1.14%)
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.