Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.60 ms
(89.36%)
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
  400885
  484245
  539376
  545869
  567974
  618640
  619320
  625841
  629069
  634331
  640116
  643214
  644491
  658818
  665067
  667097
  700092
  704410
  709125
  711231
  717299
  717502
  722999
  724770
  724813
  725429
  729015
  729047
  729219
  730181
  733183
  734351
  735003
  737352
  737864
  737884
  739107
  740137
  740179
  740184
  740200
  740963
  741155
  741865
  743815
  744177
  746367
  747628
  748082
  748087
  748380
  749004
  749653
  751395
  751443
  753755
  756268
  757940
  762887
  763910
  764755
  765955
  767824
  768731
  774032
  775562
  778168
  778330
  780250
  780658
  782315
  782765
  787671
  787739
  790103
  790295
  793052
  794407
  795473
  811809
  817421
  817771
  819888
  820008
  820028
  820742
  823768
  824047
  824127
  824159
  824211
  824602
  824616
  824693
  824966
  825165
  825171
  825334
  825434
  825459
  825944
  826169
  826443
  826553
  826596
  826724
  826769
  827083
  827113
  827174
  827568
  828120
  828180
  828364
  828701
  828741
]
9.89 ms
(5.37%)
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
  737352
  737864
  743815
  757940
  767824
  774032
  787739
  790103
  793052
  795473
  811809
  724770
  729015
  730181
  737884
  740137
  740179
  740200
  748082
  756268
  724813
  733183
  735003
  739107
  763910
  764755
  741865
  744177
  747628
  748087
  753755
  762887
  765955
  768731
  729219
  740184
  746367
  748380
  751395
  751443
  618640
  619320
  625841
  634331
  640116
  644491
  700092
  704410
  709125
  711231
  717299
  775562
  778168
  400885
  824127
  824211
  824821
  826553
  826596
  826724
  817421
  820008
  820028
  820742
  824693
  825165
  825171
  825459
  826443
  826769
  827083
  827113
  827174
  827568
  817771
  823768
  824047
  824159
  824602
  824616
  824966
  825334
  825944
  826340
  826420
  819888
  826169
  828180
  828120
  828741
  828364
  825434
  828701
  484245
  539376
  567974
  545869
  658818
  665067
  667097
  717502
  722999
  629069
  643214
  778330
  780250
  780658
  782315
  782765
  787671
  794407
  790295
  725429
  729047
  734351
  740963
  741155
  749004
  749653
  761714
]
2.87 ms
(1.56%)
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
  400885
  484245
  539376
  545869
  567974
  618640
  619320
  625841
  629069
  634331
  640116
  643214
  644491
  658818
  665067
  667097
  700092
  704410
  709125
  711231
  717299
  717502
  722999
  724770
  724813
  725429
  729015
  729047
  729219
  730181
  733183
  734351
  735003
  737352
  737864
  737884
  739107
  740137
  740179
  740184
  740200
  740963
  741155
  741865
  743815
  744177
  746367
  747628
  748082
  748087
  748380
  749004
  749653
  751395
  751443
  753755
  756268
  757940
  762887
  763910
  764755
  765955
  767824
  768731
  774032
  775562
  778168
  778330
  780250
  780658
  782315
  782765
  787671
  787739
  790103
  790295
  793052
  794407
  795473
  811809
  817421
  817771
  819888
  820008
  820028
  820742
  823768
  824047
  824127
  824159
  824211
  824602
  824616
  824693
  824966
  825165
  825171
  825334
  825434
  825459
  825944
  826169
  826443
  826553
  826596
  826724
  826769
  827083
  827113
  827174
  827568
  828120
  828180
  828364
  828701
  828741
]
1.90 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur webcams"
]
1.84 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск webcams"
]
1.56 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск webcams"
]

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.