Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.40 ms
(84.85%)
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
  146547
  161351
  382662
  395456
  395479
  403538
  444215
  455870
  470397
  473745
  478498
  482206
  490250
  505611
  506487
  508610
  512320
  514863
  524714
  529136
  529266
  530745
  534239
  535963
  536877
  536930
  542614
  543127
  550881
  558865
  559281
  560567
  567126
  567137
  568007
  570612
  571892
  577371
  582435
  584738
  585529
  588466
  589650
  593809
  595991
  597068
  597688
  598026
  598486
  598919
  599701
  600060
  604263
  610215
  616593
  617370
  623964
  625480
  625903
  626091
  626128
  627265
  634315
  637313
  638756
  641267
  642162
  644275
  650976
  653213
  653302
  665936
  666403
  666672
  677910
  678713
  687347
  692703
  696132
  699166
  700839
  706022
  709201
  709741
  713196
  718678
  723998
  724637
  724885
  731233
  734293
  737196
  739033
  739883
  745607
  748623
  750644
  759122
  760332
  762577
  762663
  763762
  763869
  763944
  764647
  768197
  768613
  769533
  777754
  783108
  788854
  789390
  789402
  792384
  807170
  809699
  813206
  813289
  813749
  813884
]
15.58 ms
(9.03%)
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
  777754
  723998
  739883
  762577
  598919
  653302
  550881
  597688
  763762
  524714
  529266
  530745
  482206
  478498
  696132
  699166
  593809
  623964
  505611
  512320
  692703
  585529
  789390
  792384
  768613
  567126
  638756
  627265
  625480
  653213
  597068
  473745
  559281
  666672
  382662
  536877
  567137
  650976
  724885
  764647
  634315
  146547
  455870
  490250
  506487
  666403
  589650
  734293
  768197
  558865
  610215
  783108
  807170
  760332
  809699
  706022
  535963
  584738
  625903
  604263
  759122
  598486
  560567
  642162
  529136
  665936
  616593
  748623
  750644
  570612
  617370
  577371
  568007
  724637
  534239
  700839
  813289
  731233
  762663
  644275
  788854
  514863
  678713
  718678
  600060
  813749
  813884
  687347
  709741
  713196
  599701
  813206
  745607
  769533
  763869
  739033
  395479
  403538
  598026
  542614
  709201
  571892
  637313
  641267
  588466
  595991
  626128
  789402
  737196
  763944
  395456
  582435
  444215
  161351
  470397
  536930
  543127
  677910
  508610
  626091
]
3.55 ms
(2.06%)
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
  146547
  161351
  382662
  395456
  395479
  403538
  444215
  455870
  470397
  473745
  478498
  482206
  490250
  505611
  506487
  508610
  512320
  514863
  524714
  529136
  529266
  530745
  534239
  535963
  536877
  536930
  542614
  543127
  550881
  558865
  559281
  560567
  567126
  567137
  568007
  570612
  571892
  577371
  582435
  584738
  585529
  588466
  589650
  593809
  595991
  597068
  597688
  598026
  598486
  598919
  599701
  600060
  604263
  610215
  616593
  617370
  623964
  625480
  625903
  626091
  626128
  627265
  634315
  637313
  638756
  641267
  642162
  644275
  650976
  653213
  653302
  665936
  666403
  666672
  677910
  678713
  687347
  692703
  696132
  699166
  700839
  706022
  709201
  709741
  713196
  718678
  723998
  724637
  724885
  731233
  734293
  737196
  739033
  739883
  745607
  748623
  750644
  759122
  760332
  762577
  762663
  763762
  763869
  763944
  764647
  768197
  768613
  769533
  777754
  783108
  788854
  789390
  789402
  792384
  807170
  809699
  813206
  813289
  813749
  813884
]
1.98 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "наездница огромный ху…"
]
1.90 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "наездниц поз огромный член"
]
1.41 ms
(0.82%)
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.