Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
215.60 ms
(50.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен вебкамер"
]
191.52 ms
(44.84%)
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
  8757
  393798
  397100
  400589
  536480
  614930
  615687
  617127
  650491
  653752
  691373
  705064
  709870
  713021
  715913
  716375
  718138
  719554
  725766
  727552
  727558
  728199
  728492
  728880
  728891
  729278
  730135
  733513
  734629
  736755
  738343
  738763
  740674
  740734
  741336
  744223
  744370
  744812
  744814
  745357
  746637
  747065
  748030
  748826
  748966
  750607
  752040
  753980
  758833
  759178
  760838
  761253
  762387
  762974
  763866
  763902
  764293
  765042
  765504
  766243
  766406
  766416
  766468
  766476
  767119
  767803
  768418
  768702
  768921
  769387
  771865
  772859
  773211
  773349
  773357
  773717
  773738
  773753
  775119
  776679
  777964
  778193
  778433
  780369
  782162
  785562
  786320
  787266
  787932
  788437
  789554
  792218
  792719
  793556
  794102
  795109
  795846
  795850
  796224
  797277
  797281
  799921
  800505
  801566
  801659
  802901
  803934
  804545
  805648
  805658
  810934
  811144
  811834
  812250
  812323
  813120
  813540
  824958
]
11.84 ms
(2.77%)
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
  812250
  812323
  813120
  740734
  744814
  750607
  761253
  765042
  765504
  766476
  767803
  768702
  769387
  773349
  773357
  782162
  787266
  788437
  789554
  792218
  792719
  793556
  795109
  795846
  795850
  800505
  801566
  801659
  805658
  810934
  811144
  811834
  728199
  738763
  744812
  745357
  748030
  759178
  760838
  768418
  773753
  729278
  736755
  738343
  744370
  748826
  752040
  758833
  764293
  766468
  767119
  773211
  725766
  728492
  728880
  728891
  730135
  744223
  746637
  748966
  762387
  762974
  773738
  727552
  727558
  734629
  740674
  741336
  747065
  753980
  763866
  763902
  766243
  768921
  771865
  772859
  773717
  614930
  615687
  617127
  713021
  715913
  719554
  775119
  776679
  777964
  778193
  778433
  778435
  780369
  785562
  787932
  794102
  799921
  802901
  803934
  813540
  397100
  400589
  796224
  650491
  805648
  393798
  716375
  718138
  705064
  691373
  786320
  797277
  804545
  766406
  766416
  733513
  797281
  8757
  826522
  824958
  536480
  653752
  709870
]
2.96 ms
(0.69%)
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
  8757
  393798
  397100
  400589
  536480
  614930
  615687
  617127
  650491
  653752
  691373
  705064
  709870
  713021
  715913
  716375
  718138
  719554
  725766
  727552
  727558
  728199
  728492
  728880
  728891
  729278
  730135
  733513
  734629
  736755
  738343
  738763
  740674
  740734
  741336
  744223
  744370
  744812
  744814
  745357
  746637
  747065
  748030
  748826
  748966
  750607
  752040
  753980
  758833
  759178
  760838
  761253
  762387
  762974
  763866
  763902
  764293
  765042
  765504
  766243
  766406
  766416
  766468
  766476
  767119
  767803
  768418
  768702
  768921
  769387
  771865
  772859
  773211
  773349
  773357
  773717
  773738
  773753
  775119
  776679
  777964
  778193
  778433
  780369
  782162
  785562
  786320
  787266
  787932
  788437
  789554
  792218
  792719
  793556
  794102
  795109
  795846
  795850
  796224
  797277
  797281
  799921
  800505
  801566
  801659
  802901
  803934
  804545
  805648
  805658
  810934
  811144
  811834
  812250
  812323
  813120
  813540
  824958
]
1.85 ms
(0.43%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(0.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен вебкамер"
]
1.67 ms
(0.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife webcam"
]

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.