Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.89 ms
(82.43%)
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
  10934
  34353
  382647
  383362
  384945
  386555
  386918
  387052
  387115
  388962
  391762
  396776
  397220
  398865
  415760
  415849
  418160
  420328
  420900
  423460
  434796
  441970
  446519
  448079
  454607
  458627
  464239
  473514
  485296
  489437
  490778
  492010
  507161
  509682
  515253
  515417
  518510
  519630
  523485
  525167
  526427
  531767
  536146
  538794
  539589
  545896
  546046
  549238
  549331
  549803
  552279
  555355
  555937
  556855
  556864
  560443
  563114
  569824
  572566
  577512
  578478
  581116
  581158
  583858
  590103
  590110
  591923
  592142
  596812
  602682
  606176
  612905
  615233
  617144
  619242
  622033
  623307
  623965
  625819
  630444
  630449
  633300
  638466
  644160
  644885
  645564
  648670
  649024
  650146
  653506
  654333
  655074
  669294
  682642
  684492
  686750
  711773
  725355
  729634
  732220
  732385
  735338
  739551
  739938
  748272
  749737
  751656
  752754
  757514
  760550
  767008
  773158
  782710
  789317
  792899
  800784
  810016
  816184
  820177
  826804
]
16.04 ms
(10.85%)
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
  739551
  386555
  391762
  525167
  655074
  622033
  630449
  630444
  384945
  816184
  820177
  826804
  531767
  669294
  645564
  633300
  619242
  638466
  729634
  732385
  739938
  420328
  396776
  490778
  519630
  485296
  650146
  552279
  556855
  556864
  592142
  749737
  810016
  751656
  725355
  489437
  507161
  572566
  583858
  441970
  549803
  623307
  591923
  382647
  464239
  649024
  606176
  612905
  792899
  782710
  752754
  773158
  735338
  625819
  386918
  458627
  518510
  415760
  448079
  515253
  536146
  523485
  539589
  545896
  555355
  560443
  653506
  602682
  800784
  748272
  767008
  387052
  654333
  549238
  34353
  526427
  492010
  581158
  590103
  10934
  387115
  383362
  415849
  644885
  446519
  454607
  509682
  515417
  563114
  578478
  569824
  581116
  684492
  648670
  644160
  596812
  623965
  789317
  732220
  757514
  434796
  388962
  397220
  423460
  418160
  473514
  538794
  549331
  555937
  577512
  711773
  686750
  682642
  546046
  590110
  615233
  617144
  760550
  398865
  420900
]
2.73 ms
(1.85%)
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
  10934
  34353
  382647
  383362
  384945
  386555
  386918
  387052
  387115
  388962
  391762
  396776
  397220
  398865
  415760
  415849
  418160
  420328
  420900
  423460
  434796
  441970
  446519
  448079
  454607
  458627
  464239
  473514
  485296
  489437
  490778
  492010
  507161
  509682
  515253
  515417
  518510
  519630
  523485
  525167
  526427
  531767
  536146
  538794
  539589
  545896
  546046
  549238
  549331
  549803
  552279
  555355
  555937
  556855
  556864
  560443
  563114
  569824
  572566
  577512
  578478
  581116
  581158
  583858
  590103
  590110
  591923
  592142
  596812
  602682
  606176
  612905
  615233
  617144
  619242
  622033
  623307
  623965
  625819
  630444
  630449
  633300
  638466
  644160
  644885
  645564
  648670
  649024
  650146
  653506
  654333
  655074
  669294
  682642
  684492
  686750
  711773
  725355
  729634
  732220
  732385
  735338
  739551
  739938
  748272
  749737
  751656
  752754
  757514
  760550
  767008
  773158
  782710
  789317
  792899
  800784
  810016
  816184
  820177
  826804
]
2.08 ms
(1.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "палец секс"
]
1.75 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "finger fuck"
]
1.66 ms
(1.13%)
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.