Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.61 ms
(86.66%)
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
  85250
  152765
  233204
  382781
  385892
  386309
  386727
  389696
  396376
  398003
  400573
  423922
  437178
  444246
  483280
  496878
  498124
  567484
  578825
  621786
  633641
  634903
  685130
  691717
  691807
  705117
  711267
  711290
  712160
  719408
  727047
  728888
  730941
  731230
  731604
  732545
  735987
  736732
  738695
  744358
  744364
  744377
  745198
  746037
  746567
  747490
  748372
  748813
  748983
  750239
  754013
  758659
  758769
  761279
  761606
  762404
  762408
  762945
  764099
  765405
  765936
  765938
  766273
  767363
  769964
  770076
  771912
  771935
  772037
  772423
  772438
  774996
  778144
  778188
  778500
  779735
  780394
  782525
  783156
  784171
  786087
  786877
  787433
  787969
  789282
  789601
  790588
  790732
  790762
  791249
  791826
  792229
  792248
  792696
  792728
  794283
  794382
  794640
  794735
  795175
  795662
  795854
  796743
  797041
  797309
  800083
  800717
  801005
  801664
  803894
  803961
  804020
  804057
  804911
  804948
  805649
  810321
  810877
  810950
]
11.74 ms
(7.04%)
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
  790732
  791249
  792229
  792248
  794640
  795175
  797041
  801005
  801664
  804948
  810950
  727047
  730941
  731230
  747490
  748372
  750239
  754013
  758659
  758769
  762945
  772037
  772423
  783156
  784171
  786877
  787969
  790588
  791826
  792696
  792728
  795854
  800083
  800717
  803961
  804911
  810321
  810877
  728888
  732545
  736732
  738695
  744364
  748813
  765938
  766273
  772438
  744377
  745198
  764099
  769964
  744358
  746567
  748983
  762404
  762408
  768728
  770076
  771935
  731604
  735987
  746037
  761279
  761606
  765405
  765936
  767363
  771912
  633641
  634903
  705117
  711267
  711290
  712160
  719408
  774996
  778144
  778188
  778500
  779735
  780394
  782525
  786087
  787433
  789282
  789601
  790762
  794382
  794735
  795662
  796743
  797309
  803894
  804020
  804057
  382781
  386309
  400573
  85250
  396376
  685130
  385892
  794283
  152765
  691807
  233204
  483280
  496878
  567484
  423922
  437178
  389696
  444246
  398003
  691717
  578825
  621786
  805649
  386727
  498124
]
2.90 ms
(1.74%)
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
  85250
  152765
  233204
  382781
  385892
  386309
  386727
  389696
  396376
  398003
  400573
  423922
  437178
  444246
  483280
  496878
  498124
  567484
  578825
  621786
  633641
  634903
  685130
  691717
  691807
  705117
  711267
  711290
  712160
  719408
  727047
  728888
  730941
  731230
  731604
  732545
  735987
  736732
  738695
  744358
  744364
  744377
  745198
  746037
  746567
  747490
  748372
  748813
  748983
  750239
  754013
  758659
  758769
  761279
  761606
  762404
  762408
  762945
  764099
  765405
  765936
  765938
  766273
  767363
  769964
  770076
  771912
  771935
  772037
  772423
  772438
  774996
  778144
  778188
  778500
  779735
  780394
  782525
  783156
  784171
  786087
  786877
  787433
  787969
  789282
  789601
  790588
  790732
  790762
  791249
  791826
  792229
  792248
  792696
  792728
  794283
  794382
  794640
  794735
  795175
  795662
  795854
  796743
  797041
  797309
  800083
  800717
  801005
  801664
  803894
  803961
  804020
  804057
  804911
  804948
  805649
  810321
  810877
  810950
]
2.32 ms
(1.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife webcam"
]
1.91 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен вебкамер"
]
1.53 ms
(0.91%)
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.