Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.37 ms
(82.68%)
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
  95855
  96761
  191575
  193662
  385324
  386935
  388957
  391920
  391922
  425181
  443150
  445416
  451758
  454084
  454275
  468042
  469084
  470971
  474289
  477073
  480398
  494433
  500467
  512079
  527871
  530373
  531121
  531227
  531250
  534542
  534545
  536210
  536359
  541832
  546953
  547936
  583501
  599958
  600218
  603151
  604403
  614220
  621323
  622241
  629886
  631944
  633172
  634477
  639274
  641859
  644309
  645233
  645904
  651082
  656904
  667922
  669073
  670108
  670773
  671740
  671751
  672144
  673719
  677723
  684126
  692796
  696355
  703091
  703436
  705516
  708439
  708465
  712010
  714618
  715497
  720236
  720243
  720873
  721025
  725376
  728271
  731759
  731844
  746339
  748326
  748529
  756023
  765236
  770124
  770322
  770787
  770916
  775473
  775818
  775858
  775956
  784345
  789529
  789841
  790382
  792831
  800606
  801899
  801963
  803645
  805596
  805600
  805602
  806022
  814893
  815192
  815298
  816015
  816211
  816317
  816423
  816520
  816937
  820768
  821877
]
17.24 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
  677723
  720236
  645904
  667922
  673719
  692796
  614220
  644309
  604403
  801899
  803645
  789841
  748529
  765236
  720873
  96761
  546953
  731844
  474289
  531250
  531121
  656904
  629886
  775473
  775858
  784345
  770124
  748326
  815298
  816423
  816520
  821877
  814893
  816015
  816317
  816937
  815192
  816211
  820768
  534545
  536210
  512079
  534542
  651082
  670773
  672144
  712010
  715497
  645233
  670108
  696355
  721025
  671740
  671751
  684126
  708439
  720243
  631944
  634477
  639274
  603151
  633172
  805596
  806022
  775956
  746339
  770916
  789529
  790382
  792831
  800606
  801963
  805602
  770787
  728271
  725376
  756023
  770322
  621323
  641859
  703091
  703436
  705516
  775818
  805600
  536359
  530373
  468042
  480398
  547936
  470971
  443150
  391920
  494433
  391922
  388957
  386935
  454084
  527871
  95855
  385324
  425181
  469084
  451758
  454275
  191575
  531227
  193662
  477073
  583501
  669073
  731759
  714618
  541832
  600218
  622241
  445416
  708465
  599958
  500467
]
2.60 ms
(1.63%)
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
  95855
  96761
  191575
  193662
  385324
  386935
  388957
  391920
  391922
  425181
  443150
  445416
  451758
  454084
  454275
  468042
  469084
  470971
  474289
  477073
  480398
  494433
  500467
  512079
  527871
  530373
  531121
  531227
  531250
  534542
  534545
  536210
  536359
  541832
  546953
  547936
  583501
  599958
  600218
  603151
  604403
  614220
  621323
  622241
  629886
  631944
  633172
  634477
  639274
  641859
  644309
  645233
  645904
  651082
  656904
  667922
  669073
  670108
  670773
  671740
  671751
  672144
  673719
  677723
  684126
  692796
  696355
  703091
  703436
  705516
  708439
  708465
  712010
  714618
  715497
  720236
  720243
  720873
  721025
  725376
  728271
  731759
  731844
  746339
  748326
  748529
  756023
  765236
  770124
  770322
  770787
  770916
  775473
  775818
  775858
  775956
  784345
  789529
  789841
  790382
  792831
  800606
  801899
  801963
  803645
  805596
  805600
  805602
  806022
  814893
  815192
  815298
  816015
  816211
  816317
  816423
  816520
  816937
  820768
  821877
]
2.04 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.02 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "double anal mother"
]
2.00 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "double анал мам женщин"
]
1.64 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "double анал мам женщин"
]

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.