Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.17 ms
(81.53%)
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
  282006
  282858
  395306
  395841
  395929
  396003
  397535
  410264
  413594
  415235
  416397
  417888
  418035
  427970
  428045
  429009
  429629
  444338
  445711
  446108
  446158
  447327
  447405
  447434
  447494
  447517
  447642
  447650
  447662
  447690
  448366
  451605
  451755
  454066
  457492
  459237
  460769
  461556
  462804
  463819
  463863
  463903
  463927
  463939
  464696
  465908
  466098
  473931
  476090
  477734
  479759
  484274
  484434
  484980
  490794
  491202
  491718
  492171
  496071
  496869
  497870
  499503
  502763
  505021
  510071
  510680
  512762
  518997
  521291
  522010
  523197
  524514
  526463
  527378
  528606
  530478
  530697
  531908
  533010
  533016
  536252
  536636
  544782
  549871
  552430
  555801
  556181
  558031
  561880
  565250
  573777
  575204
  575618
  575771
  604180
  627740
  630018
  632118
  637851
  646662
  660321
  671616
  677367
  681198
  698434
  706629
  714667
  714994
  716633
  719292
  721322
  721445
  737298
  740392
  742188
  742242
  744270
  754210
  760772
  791663
]
17.91 ms
(11.48%)
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
  558031
  573777
  575204
  721445
  627740
  630018
  415235
  445711
  447690
  448366
  460769
  462804
  282858
  397535
  410264
  418035
  446158
  447650
  457492
  477734
  479759
  395841
  444338
  451605
  454066
  473931
  395929
  447327
  447494
  461556
  463939
  465908
  476090
  447405
  447517
  466098
  528606
  484434
  518997
  522010
  484274
  490794
  491202
  492171
  496869
  499503
  505021
  521291
  524514
  526463
  510071
  512762
  416397
  459237
  484980
  536252
  533010
  523197
  536636
  531908
  556181
  428045
  463863
  463927
  447434
  502763
  527378
  491718
  530478
  395306
  451755
  464696
  530697
  533016
  561880
  706629
  549871
  740392
  760772
  429009
  447642
  463819
  282006
  427970
  396003
  463903
  417888
  429629
  446108
  510680
  496071
  413594
  565250
  497870
  575771
  754210
  447662
  677367
  744270
  737298
  742188
  552430
  544782
  575618
  646662
  671616
  698434
  716633
  721322
  660321
  681198
  714667
  714994
  719292
  555801
  632118
  637851
  604180
  791663
  742242
]
3.36 ms
(2.15%)
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
  282006
  282858
  395306
  395841
  395929
  396003
  397535
  410264
  413594
  415235
  416397
  417888
  418035
  427970
  428045
  429009
  429629
  444338
  445711
  446108
  446158
  447327
  447405
  447434
  447494
  447517
  447642
  447650
  447662
  447690
  448366
  451605
  451755
  454066
  457492
  459237
  460769
  461556
  462804
  463819
  463863
  463903
  463927
  463939
  464696
  465908
  466098
  473931
  476090
  477734
  479759
  484274
  484434
  484980
  490794
  491202
  491718
  492171
  496071
  496869
  497870
  499503
  502763
  505021
  510071
  510680
  512762
  518997
  521291
  522010
  523197
  524514
  526463
  527378
  528606
  530478
  530697
  531908
  533010
  533016
  536252
  536636
  544782
  549871
  552430
  555801
  556181
  558031
  561880
  565250
  573777
  575204
  575618
  575771
  604180
  627740
  630018
  632118
  637851
  646662
  660321
  671616
  677367
  681198
  698434
  706629
  714667
  714994
  716633
  719292
  721322
  721445
  737298
  740392
  742188
  742242
  744270
  754210
  760772
  791663
]
2.12 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen big dick"
]
1.86 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen большой большие член"
]
1.80 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen большой большие член"
]
1.76 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.