Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.67 ms
(85.28%)
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
  188117
  285018
  381921
  386638
  389218
  389653
  392903
  393754
  401202
  401921
  409958
  412474
  412838
  420306
  428117
  443628
  443642
  444903
  447251
  451108
  451966
  452216
  452259
  452316
  453404
  453415
  454051
  455321
  455683
  462396
  462707
  465193
  465727
  466382
  472275
  472448
  473434
  473522
  474910
  476300
  476353
  477589
  478098
  479766
  480494
  482483
  482755
  484188
  487351
  491332
  492595
  502214
  502578
  502590
  502793
  504574
  504717
  507181
  509262
  509978
  513581
  513856
  517276
  518126
  520141
  525389
  529275
  529493
  530050
  533000
  535883
  544011
  554466
  555177
  559308
  561036
  563267
  567731
  574153
  578827
  580856
  590252
  593133
  594195
  600651
  608785
  610202
  613502
  625753
  633804
  644271
  650034
  655496
  663524
  663852
  664280
  670367
  670841
  672950
  678916
  695146
  722916
  723542
  724139
  725461
  725537
  728317
  740103
  740300
  744988
  752151
  755082
  759687
  766623
  777284
  798608
  800332
  800533
  808669
  810118
]
17.96 ms
(9.24%)
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
  455321
  465193
  447251
  466382
  472275
  476300
  504574
  513856
  533000
  502590
  507181
  529275
  473522
  580856
  670367
  664280
  610202
  593133
  594195
  800533
  740300
  759687
  740103
  744988
  800332
  453404
  474910
  401921
  476353
  386638
  409958
  443642
  502578
  420306
  465727
  462396
  478098
  452216
  482755
  502793
  520141
  513581
  530050
  518126
  561036
  695146
  650034
  663852
  563267
  574153
  590252
  777284
  798608
  725461
  752151
  724139
  725537
  625753
  810118
  444903
  285018
  480494
  443628
  525389
  529493
  504717
  509978
  517276
  392903
  670841
  633804
  755082
  401202
  389653
  381921
  473434
  567731
  544011
  663524
  555177
  412474
  723542
  453415
  502214
  559308
  655496
  672950
  554466
  600651
  608785
  766623
  462707
  452316
  491332
  535883
  484188
  188117
  389218
  477589
  454051
  509262
  678916
  578827
  644271
  613502
  808669
  728317
  722916
  412838
  428117
  455683
  492595
  393754
  482483
  487351
  452259
  472448
  451108
  451966
  479766
]
3.70 ms
(1.90%)
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
  188117
  285018
  381921
  386638
  389218
  389653
  392903
  393754
  401202
  401921
  409958
  412474
  412838
  420306
  428117
  443628
  443642
  444903
  447251
  451108
  451966
  452216
  452259
  452316
  453404
  453415
  454051
  455321
  455683
  462396
  462707
  465193
  465727
  466382
  472275
  472448
  473434
  473522
  474910
  476300
  476353
  477589
  478098
  479766
  480494
  482483
  482755
  484188
  487351
  491332
  492595
  502214
  502578
  502590
  502793
  504574
  504717
  507181
  509262
  509978
  513581
  513856
  517276
  518126
  520141
  525389
  529275
  529493
  530050
  533000
  535883
  544011
  554466
  555177
  559308
  561036
  563267
  567731
  574153
  578827
  580856
  590252
  593133
  594195
  600651
  608785
  610202
  613502
  625753
  633804
  644271
  650034
  655496
  663524
  663852
  664280
  670367
  670841
  672950
  678916
  695146
  722916
  723542
  724139
  725461
  725537
  728317
  740103
  740300
  744988
  752151
  755082
  759687
  766623
  777284
  798608
  800332
  800533
  808669
  810118
]
2.09 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fat sex"
]
1.88 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "fat секс"
]
1.52 ms
(0.78%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "fat секс"
]

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.