Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.12 ms
(84.79%)
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
  95748
  95873
  96665
  188337
  236472
  312264
  373798
  386913
  391929
  400669
  401655
  413047
  413050
  414863
  418845
  423414
  423609
  426033
  426693
  433089
  433096
  433122
  433185
  433206
  433236
  433238
  433477
  433498
  446499
  467955
  475227
  476093
  476255
  477553
  478779
  486589
  503507
  516307
  522568
  522867
  522919
  530492
  535466
  537855
  543888
  548796
  550294
  550665
  556016
  556795
  562758
  563537
  564826
  565168
  566558
  569097
  590867
  604553
  616025
  619398
  619469
  626291
  628707
  629273
  631944
  633175
  636545
  641052
  643013
  644259
  644270
  644330
  644894
  649947
  659315
  665771
  670112
  670947
  672138
  672579
  675809
  686860
  690827
  695280
  703070
  705829
  708462
  712887
  713091
  715497
  716027
  718909
  719983
  720254
  724216
  724330
  732256
  736226
  741541
  758599
  766274
  766847
  769924
  770520
  775931
  784279
  784569
  789664
  790862
  794557
  794832
  799582
  803450
  804442
  807557
  809291
  809479
  811013
  815110
  817340
]
13.17 ms
(8.71%)
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
  550294
  516307
  736226
  433185
  312264
  815110
  713091
  631944
  794557
  769924
  644894
  758599
  386913
  423609
  672579
  803450
  732256
  770520
  626291
  644330
  708462
  784569
  590867
  566558
  766274
  413047
  799582
  649947
  712887
  703070
  401655
  476255
  537855
  741541
  604553
  789664
  550665
  565168
  433089
  535466
  719983
  616025
  718909
  477553
  672138
  476093
  548796
  670947
  629273
  807557
  811013
  794832
  809291
  809479
  766847
  724216
  804442
  475227
  188337
  391929
  433238
  467955
  784279
  418845
  641052
  414863
  665771
  817340
  400669
  426693
  522568
  433477
  522919
  564826
  569097
  633175
  522867
  562758
  413050
  433498
  95748
  486589
  503507
  433096
  433236
  426033
  433122
  775931
  644270
  563537
  543888
  644259
  628707
  636545
  433206
  423414
  715497
  556016
  720254
  478779
  619398
  530492
  556795
  96665
  95873
  705829
  373798
  724330
  446499
  659315
  619469
  790862
  236472
  643013
  670112
  716027
  690827
  695280
  675809
  686860
]
2.90 ms
(1.92%)
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
  95748
  95873
  96665
  188337
  236472
  312264
  373798
  386913
  391929
  400669
  401655
  413047
  413050
  414863
  418845
  423414
  423609
  426033
  426693
  433089
  433096
  433122
  433185
  433206
  433236
  433238
  433477
  433498
  446499
  467955
  475227
  476093
  476255
  477553
  478779
  486589
  503507
  516307
  522568
  522867
  522919
  530492
  535466
  537855
  543888
  548796
  550294
  550665
  556016
  556795
  562758
  563537
  564826
  565168
  566558
  569097
  590867
  604553
  616025
  619398
  619469
  626291
  628707
  629273
  631944
  633175
  636545
  641052
  643013
  644259
  644270
  644330
  644894
  649947
  659315
  665771
  670112
  670947
  672138
  672579
  675809
  686860
  690827
  695280
  703070
  705829
  708462
  712887
  713091
  715497
  716027
  718909
  719983
  720254
  724216
  724330
  732256
  736226
  741541
  758599
  766274
  766847
  769924
  770520
  775931
  784279
  784569
  789664
  790862
  794557
  794832
  799582
  803450
  804442
  807557
  809291
  809479
  811013
  815110
  817340
]
1.95 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кончают в жопу втроем%…"
]
1.89 ms
(1.25%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм анал секс втро"
]
1.45 ms
(0.96%)
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.