Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.04 ms
(55.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
147.71 ms
(38.95%)
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
  3607
  213757
  293121
  382520
  388583
  396418
  403116
  424287
  431718
  441098
  450364
  459627
  477638
  498156
  519601
  588001
  619805
  632793
  633714
  634593
  637986
  641327
  704999
  705495
  721729
  727503
  729295
  730835
  730924
  731212
  731304
  733759
  734355
  734358
  738587
  738839
  739379
  740687
  740835
  741268
  742767
  742841
  742842
  743860
  744154
  744171
  744224
  744388
  746639
  747510
  750356
  750844
  750864
  750952
  751918
  751957
  755209
  757795
  760857
  761620
  762596
  762951
  765511
  765621
  768863
  769099
  772867
  773334
  773458
  775085
  775603
  775658
  777907
  778244
  781140
  782030
  783033
  785256
  785672
  786547
  786851
  787787
  790306
  790763
  790929
  791308
  791661
  791716
  791825
  792210
  792235
  792249
  792709
  792857
  794028
  794888
  795028
  795241
  795274
  796216
  796231
  796732
  796745
  796772
  800137
  800818
  801113
  801455
  801677
  801678
  803166
  803637
  804360
  810311
  810912
  810943
  811530
  812208
  812424
]
11.99 ms
(3.16%)
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
  632793
  637986
  641327
  588001
  619805
  634593
  775085
  775603
  775658
  778213
  778244
  782030
  786547
  790306
  791308
  792235
  792249
  795274
  796772
  801113
  801455
  801677
  812424
  781140
  785256
  785672
  786851
  790929
  792210
  794888
  795028
  796745
  800137
  801678
  803166
  811530
  812208
  727503
  729295
  734355
  739379
  740687
  741268
  742841
  744171
  744224
  751957
  760857
  762596
  768863
  769099
  772867
  783033
  787787
  790763
  791716
  792709
  794028
  795241
  796732
  810912
  731304
  733759
  734358
  738587
  747510
  750844
  750952
  773334
  738839
  744388
  751918
  755209
  765621
  730835
  742842
  744154
  746639
  750864
  757795
  761620
  762951
  765511
  773458
  731212
  740835
  742767
  743860
  750356
  633714
  704999
  705495
  777907
  791661
  791825
  792857
  796216
  796231
  800818
  804360
  810311
  810943
  477638
  403116
  293121
  382520
  3607
  441098
  431718
  450364
  424287
  721729
  730924
  459627
  388583
  396418
  519601
  803637
  213757
  498156
]
2.68 ms
(0.71%)
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
  3607
  213757
  293121
  382520
  388583
  396418
  403116
  424287
  431718
  441098
  450364
  459627
  477638
  498156
  519601
  588001
  619805
  632793
  633714
  634593
  637986
  641327
  704999
  705495
  721729
  727503
  729295
  730835
  730924
  731212
  731304
  733759
  734355
  734358
  738587
  738839
  739379
  740687
  740835
  741268
  742767
  742841
  742842
  743860
  744154
  744171
  744224
  744388
  746639
  747510
  750356
  750844
  750864
  750952
  751918
  751957
  755209
  757795
  760857
  761620
  762596
  762951
  765511
  765621
  768863
  769099
  772867
  773334
  773458
  775085
  775603
  775658
  777907
  778244
  781140
  782030
  783033
  785256
  785672
  786547
  786851
  787787
  790306
  790763
  790929
  791308
  791661
  791716
  791825
  792210
  792235
  792249
  792709
  792857
  794028
  794888
  795028
  795241
  795274
  796216
  796231
  796732
  796745
  796772
  800137
  800818
  801113
  801455
  801677
  801678
  803166
  803637
  804360
  810311
  810912
  810943
  811530
  812208
  812424
]
2.18 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife webcam"
]
1.39 ms
(0.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен вебкамер"
]
1.20 ms
(0.32%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.