Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.97 ms
(86.32%)
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
  382081
  383415
  383744
  385538
  385578
  386738
  387270
  390082
  390707
  391015
  392527
  398395
  400833
  401581
  401881
  403593
  415090
  425420
  426250
  427264
  429125
  429592
  429704
  448403
  456875
  460931
  463342
  463752
  474691
  476155
  477374
  483792
  487414
  490599
  496458
  498874
  500690
  500692
  500698
  502022
  509762
  509767
  510894
  512227
  512621
  512902
  516125
  517545
  523058
  524901
  527503
  528816
  529060
  530313
  532885
  533390
  534657
  539774
  542918
  544360
  547089
  552898
  552899
  554307
  557635
  558318
  559630
  566679
  569661
  577553
  581291
  583651
  584065
  587567
  588674
  589942
  591536
  591549
  592187
  593431
  596371
  596562
  601777
  603930
  604581
  606345
  611280
  612298
  628524
  628594
  639981
  643201
  661591
  666021
  666709
  667222
  675341
  685758
  691607
  701056
  707470
  713045
  719144
  720050
  725613
  729974
  742269
  742310
  743231
  749588
  753235
  783417
  794390
  803788
  817183
  819396
  824757
  824765
  825857
  827584
]
16.59 ms
(8.73%)
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
  476155
  516125
  527503
  500690
  510894
  509762
  509767
  534657
  490599
  500698
  533390
  530313
  544360
  566679
  667222
  701056
  383415
  392527
  382081
  819396
  825857
  824757
  824765
  460931
  483792
  463342
  502022
  512621
  691607
  612298
  628524
  639981
  743231
  783417
  742310
  628594
  385578
  425420
  427264
  398395
  401581
  403593
  390707
  429125
  827584
  817183
  742269
  803788
  749588
  753235
  386738
  385538
  383744
  387270
  391015
  390082
  400833
  401881
  426250
  429592
  415090
  429704
  552898
  448403
  456875
  463752
  474691
  487414
  477374
  512902
  512227
  528816
  496458
  524901
  529060
  539774
  498874
  500692
  517545
  523058
  532885
  542918
  554307
  547089
  558318
  569661
  577553
  581291
  557635
  559630
  661591
  707470
  719144
  666021
  666709
  685758
  713045
  675341
  720050
  552899
  583651
  584065
  588674
  606345
  611280
  591549
  592187
  603930
  604581
  587567
  589942
  591536
  593431
  596371
  596562
  601777
  643201
  794390
  729974
  725613
]
2.45 ms
(1.29%)
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
  382081
  383415
  383744
  385538
  385578
  386738
  387270
  390082
  390707
  391015
  392527
  398395
  400833
  401581
  401881
  403593
  415090
  425420
  426250
  427264
  429125
  429592
  429704
  448403
  456875
  460931
  463342
  463752
  474691
  476155
  477374
  483792
  487414
  490599
  496458
  498874
  500690
  500692
  500698
  502022
  509762
  509767
  510894
  512227
  512621
  512902
  516125
  517545
  523058
  524901
  527503
  528816
  529060
  530313
  532885
  533390
  534657
  539774
  542918
  544360
  547089
  552898
  552899
  554307
  557635
  558318
  559630
  566679
  569661
  577553
  581291
  583651
  584065
  587567
  588674
  589942
  591536
  591549
  592187
  593431
  596371
  596562
  601777
  603930
  604581
  606345
  611280
  612298
  628524
  628594
  639981
  643201
  661591
  666021
  666709
  667222
  675341
  685758
  691607
  701056
  707470
  713045
  719144
  720050
  725613
  729974
  742269
  742310
  743231
  749588
  753235
  783417
  794390
  803788
  817183
  819396
  824757
  824765
  825857
  827584
]
2.11 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy teens"
]
1.89 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая teens"
]
1.31 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "волосатая teens"
]

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.