Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
394.11 ms
(93.21%)
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
  411333
  411703
  422235
  424410
  424416
  424428
  424443
  424467
  424662
  425570
  427182
  429916
  443683
  443731
  443767
  443780
  443786
  443794
  443804
  443818
  444000
  444528
  444952
  454226
  454256
  460736
  460741
  460750
  460757
  465335
  465395
  465952
  466111
  466207
  466269
  466275
  466334
  467547
  467929
  468072
  470071
  470560
  470772
  472004
  473237
  473247
  474674
  475914
  476494
  477968
  478525
  482836
  484421
  484441
  484467
  484580
  484601
  484639
  486341
  486345
  486817
  488128
  489299
  490262
  490339
  490648
  491436
  494786
  497665
  497828
  498882
  500191
  507439
  511379
  512521
  513382
  518853
  518863
  519363
  520916
  526010
  526563
  537237
  543623
  544874
  549648
  552938
  556490
  559058
  571707
  578323
  589665
  589683
  592988
  596792
  599239
  605475
  651006
  667021
  705710
  707470
  724467
  735871
  735958
  742336
  745335
  747981
  752950
  756252
  760167
  800707
  800767
  802241
  803479
  804235
  806986
  807340
  810315
  826706
  827952
]
18.74 ms
(4.43%)
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
  486817
  806986
  476494
  444528
  552938
  559058
  424410
  443731
  429916
  443683
  465395
  484441
  484639
  526010
  491436
  498882
  592988
  518863
  519363
  500191
  467929
  470772
  454226
  424467
  489299
  424443
  424428
  472004
  470071
  494786
  484601
  605475
  804235
  482836
  526563
  571707
  707470
  599239
  596792
  724467
  756252
  735871
  427182
  497665
  484580
  513382
  589665
  466111
  454256
  578323
  422235
  474674
  484421
  486345
  520916
  490648
  543623
  424416
  473247
  444952
  443818
  477968
  443767
  460736
  465335
  460750
  475914
  490262
  511379
  468072
  486341
  518853
  556490
  411333
  443786
  460741
  466334
  467547
  473237
  424662
  443780
  484467
  807340
  444000
  466207
  466269
  466275
  478525
  411703
  465952
  512521
  488128
  470560
  460757
  443794
  705710
  589683
  425570
  497828
  490339
  507439
  549648
  667021
  651006
  800767
  752950
  760167
  800707
  443804
  745335
  826706
  827952
  537237
  544874
  802241
  803479
  742336
  747981
  735958
  810315
]
3.11 ms
(0.74%)
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
  411333
  411703
  422235
  424410
  424416
  424428
  424443
  424467
  424662
  425570
  427182
  429916
  443683
  443731
  443767
  443780
  443786
  443794
  443804
  443818
  444000
  444528
  444952
  454226
  454256
  460736
  460741
  460750
  460757
  465335
  465395
  465952
  466111
  466207
  466269
  466275
  466334
  467547
  467929
  468072
  470071
  470560
  470772
  472004
  473237
  473247
  474674
  475914
  476494
  477968
  478525
  482836
  484421
  484441
  484467
  484580
  484601
  484639
  486341
  486345
  486817
  488128
  489299
  490262
  490339
  490648
  491436
  494786
  497665
  497828
  498882
  500191
  507439
  511379
  512521
  513382
  518853
  518863
  519363
  520916
  526010
  526563
  537237
  543623
  544874
  549648
  552938
  556490
  559058
  571707
  578323
  589665
  589683
  592988
  596792
  599239
  605475
  651006
  667021
  705710
  707470
  724467
  735871
  735958
  742336
  745335
  747981
  752950
  756252
  760167
  800707
  800767
  802241
  803479
  804235
  806986
  807340
  810315
  826706
  827952
]
2.17 ms
(0.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "волосатые мамаши русское"
]
1.68 ms
(0.40%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.38%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая мам женщин русск"
]
1.40 ms
(0.33%)
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.