Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.88 ms
(86.61%)
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
  387749
  389541
  413381
  421196
  421810
  423786
  426144
  426691
  427786
  428570
  436132
  439151
  442248
  445329
  446064
  446797
  447144
  448464
  452843
  453021
  456131
  459759
  460115
  461436
  466494
  467113
  472119
  477981
  478525
  483739
  483745
  484530
  484565
  490380
  495744
  496674
  497290
  498260
  498413
  500489
  503154
  504372
  508412
  510338
  511058
  516636
  518840
  519597
  520845
  522797
  541033
  542768
  544887
  550567
  553958
  558563
  558581
  563348
  567165
  567368
  568973
  571759
  571843
  591168
  595876
  616013
  640544
  644849
  651751
  690936
  695524
  697560
  707944
  719804
  724859
  740895
  741936
  742830
  751797
  754685
  768116
  768940
  769932
  779372
  779394
  779400
  782566
  786818
  787318
  790146
  795520
  795804
  797722
  798061
  800098
  800916
  800941
  802919
  803393
  803505
  803546
  803749
  811091
  814067
  816109
  816635
  816678
  819205
  819709
  819775
  820114
  821791
  824246
  825048
  825288
  825972
  826757
  827410
  828227
]
15.88 ms
(8.29%)
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
  816635
  819205
  819775
  825048
  828227
  824246
  542768
  550567
  563348
  651751
  695524
  707944
  719804
  640544
  595876
  779372
  786818
  795520
  795804
  800941
  803393
  803505
  779394
  790146
  798061
  740895
  797722
  800098
  800916
  811091
  754685
  741936
  768116
  742830
  751797
  769932
  724859
  768940
  697560
  779400
  782566
  787318
  802919
  803546
  803749
  571759
  387749
  442248
  413381
  427786
  445329
  644849
  446797
  447144
  452843
  453021
  456131
  448464
  459759
  460115
  497689
  516636
  500489
  558581
  567368
  571843
  553958
  558563
  567165
  690936
  568973
  591168
  616013
  423786
  436132
  421196
  421810
  426144
  478525
  439151
  446064
  466494
  472119
  426691
  461436
  477981
  428570
  483745
  490380
  498260
  498413
  503154
  504372
  520845
  541033
  483739
  484530
  495744
  496674
  497290
  508412
  510338
  511058
  484565
  518840
  519597
  522797
  389541
  467113
  544887
  816109
  819709
  821791
  825288
  820114
  826757
  827410
  816678
  814067
  825972
]
2.46 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.44 ms
(1.27%)
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
  387749
  389541
  413381
  421196
  421810
  423786
  426144
  426691
  427786
  428570
  436132
  439151
  442248
  445329
  446064
  446797
  447144
  448464
  452843
  453021
  456131
  459759
  460115
  461436
  466494
  467113
  472119
  477981
  478525
  483739
  483745
  484530
  484565
  490380
  495744
  496674
  497290
  498260
  498413
  500489
  503154
  504372
  508412
  510338
  511058
  516636
  518840
  519597
  520845
  522797
  541033
  542768
  544887
  550567
  553958
  558563
  558581
  563348
  567165
  567368
  568973
  571759
  571843
  591168
  595876
  616013
  640544
  644849
  651751
  690936
  695524
  697560
  707944
  719804
  724859
  740895
  741936
  742830
  751797
  754685
  768116
  768940
  769932
  779372
  779394
  779400
  782566
  786818
  787318
  790146
  795520
  795804
  797722
  798061
  800098
  800916
  800941
  802919
  803393
  803505
  803546
  803749
  811091
  814067
  816109
  816635
  816678
  819205
  819709
  819775
  820114
  821791
  824246
  825048
  825288
  825972
  826757
  827410
  828227
]
1.72 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam redhead"
]
1.69 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер рыжая"
]
1.46 ms
(0.76%)
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.