Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.05 ms
(85.00%)
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
  362958
  420083
  443752
  443780
  451562
  451572
  454115
  454251
  454277
  460726
  462310
  466077
  470568
  470657
  470935
  473241
  473986
  474013
  474016
  474494
  474627
  474634
  474678
  474686
  474942
  476015
  476619
  479126
  484051
  484656
  484668
  484721
  484853
  486434
  486435
  488734
  491373
  491395
  495744
  497547
  497554
  497584
  500901
  504137
  504139
  504191
  506048
  506050
  506782
  506794
  509851
  510748
  511736
  511762
  511766
  512274
  512313
  512830
  520903
  521966
  522791
  522792
  523301
  526597
  529434
  535593
  535620
  535631
  540908
  540914
  540932
  545377
  546682
  546761
  548698
  548732
  548733
  549763
  551937
  556051
  557976
  557983
  558126
  559060
  560432
  560598
  560602
  560603
  560624
  562253
  562266
  562360
  562372
  568193
  573776
  574504
  574833
  574884
  575800
  576116
  576346
  576358
  576364
  576403
  578373
  580263
  584813
  598939
  599197
  631962
  660882
  675799
  714449
  738440
  742205
  755176
  775960
  775967
  803843
  827965
]
16.16 ms
(8.63%)
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
  548732
  562253
  576116
  562372
  598939
  454115
  454277
  535593
  549763
  576403
  576358
  575800
  574504
  584813
  473986
  491395
  512830
  497554
  497584
  479126
  470568
  560598
  548698
  560624
  470935
  473241
  520903
  484853
  511736
  522791
  512274
  497547
  511762
  560432
  578373
  560602
  631962
  775960
  775967
  451562
  443752
  509851
  510748
  522792
  491373
  529434
  573776
  474942
  460726
  476619
  521966
  486435
  504191
  506782
  559060
  484721
  474627
  486434
  504137
  576364
  580263
  548733
  738440
  546682
  574884
  599197
  420083
  523301
  827965
  551937
  560603
  568193
  714449
  474634
  454251
  540914
  557976
  562266
  474013
  511766
  500901
  540932
  546761
  443780
  545377
  557983
  755176
  495744
  504139
  506794
  512313
  474494
  484668
  506050
  474678
  506048
  362958
  742205
  556051
  660882
  675799
  540908
  451572
  574833
  470657
  526597
  484051
  558126
  535631
  474686
  488734
  462310
  576346
  466077
  484656
  562360
  535620
  474016
  476015
  803843
]
4.42 ms
(2.36%)
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
  362958
  420083
  443752
  443780
  451562
  451572
  454115
  454251
  454277
  460726
  462310
  466077
  470568
  470657
  470935
  473241
  473986
  474013
  474016
  474494
  474627
  474634
  474678
  474686
  474942
  476015
  476619
  479126
  484051
  484656
  484668
  484721
  484853
  486434
  486435
  488734
  491373
  491395
  495744
  497547
  497554
  497584
  500901
  504137
  504139
  504191
  506048
  506050
  506782
  506794
  509851
  510748
  511736
  511762
  511766
  512274
  512313
  512830
  520903
  521966
  522791
  522792
  523301
  526597
  529434
  535593
  535620
  535631
  540908
  540914
  540932
  545377
  546682
  546761
  548698
  548732
  548733
  549763
  551937
  556051
  557976
  557983
  558126
  559060
  560432
  560598
  560602
  560603
  560624
  562253
  562266
  562360
  562372
  568193
  573776
  574504
  574833
  574884
  575800
  576116
  576346
  576358
  576364
  576403
  578373
  580263
  584813
  598939
  599197
  631962
  660882
  675799
  714449
  738440
  742205
  755176
  775960
  775967
  803843
  827965
]
2.19 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ÐÇÐâÐüÐüð║ð░ÐÅ ð│ÐÇÐâð┐ð┐ð¥ð▓ÐâÐàð░ Ðü ðÔǪ"
]
1.89 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск группов секс"
]
1.58 ms
(0.85%)
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.