Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.45 ms
(83.63%)
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
  157194
  389440
  395228
  395714
  395818
  400181
  400475
  401620
  402670
  404275
  404302
  404619
  404629
  405541
  407019
  407292
  407379
  407524
  410058
  411905
  412362
  418967
  419880
  420925
  421000
  421079
  421353
  421849
  424695
  425036
  425052
  425784
  425834
  426065
  430004
  430203
  430556
  431442
  434608
  437314
  439611
  440620
  442697
  443811
  444664
  444740
  445932
  447677
  448055
  449871
  451826
  454263
  458715
  462457
  463712
  464466
  466942
  470166
  470416
  470461
  471945
  474147
  476271
  482495
  482668
  483502
  487072
  487344
  490182
  491021
  491473
  492267
  492272
  492534
  496098
  496103
  497356
  498030
  501497
  502806
  505818
  505836
  506908
  513776
  514746
  514757
  514811
  515137
  516473
  516612
  517010
  517011
  517033
  517386
  517874
  519936
  520005
  520647
  520950
  525866
  525997
  526270
  527014
  527669
  528403
  531231
  535736
  538485
  541594
  562000
  562894
  565050
  571680
  578397
  599610
  725607
  806280
  815697
  815735
  816986
]
19.52 ms
(10.78%)
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
  725607
  806280
  157194
  389440
  407019
  407292
  407379
  407524
  431442
  437314
  449871
  463712
  395714
  401620
  402670
  410058
  411905
  412362
  421849
  425784
  439611
  444740
  462457
  476271
  400181
  424695
  426065
  430203
  470166
  400475
  404275
  404302
  404619
  448055
  464466
  470416
  471945
  405541
  425052
  430004
  443811
  444664
  454263
  466942
  470461
  514757
  520647
  502806
  505836
  513776
  514746
  516473
  517874
  525997
  535736
  483502
  492272
  515137
  517011
  526270
  528403
  496098
  496103
  505818
  514811
  517010
  519936
  527014
  492534
  531231
  599610
  420925
  421353
  421000
  404629
  419880
  430556
  442697
  506908
  527669
  487344
  490182
  491021
  498030
  517033
  538485
  491473
  492267
  562894
  501497
  562000
  578397
  565050
  571680
  447677
  474147
  395818
  541594
  487072
  517386
  520005
  520950
  497356
  516612
  525866
  395228
  425834
  434608
  421079
  418967
  425036
  440620
  816986
  815697
  815735
  482495
  482668
  445932
  451826
  458715
]
3.44 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
  157194
  389440
  395228
  395714
  395818
  400181
  400475
  401620
  402670
  404275
  404302
  404619
  404629
  405541
  407019
  407292
  407379
  407524
  410058
  411905
  412362
  418967
  419880
  420925
  421000
  421079
  421353
  421849
  424695
  425036
  425052
  425784
  425834
  426065
  430004
  430203
  430556
  431442
  434608
  437314
  439611
  440620
  442697
  443811
  444664
  444740
  445932
  447677
  448055
  449871
  451826
  454263
  458715
  462457
  463712
  464466
  466942
  470166
  470416
  470461
  471945
  474147
  476271
  482495
  482668
  483502
  487072
  487344
  490182
  491021
  491473
  492267
  492272
  492534
  496098
  496103
  497356
  498030
  501497
  502806
  505818
  505836
  506908
  513776
  514746
  514757
  514811
  515137
  516473
  516612
  517010
  517011
  517033
  517386
  517874
  519936
  520005
  520647
  520950
  525866
  525997
  526270
  527014
  527669
  528403
  531231
  535736
  538485
  541594
  562000
  562894
  565050
  571680
  578397
  599610
  725607
  806280
  815697
  815735
  816986
]
1.83 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful mom old"
]
1.69 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая mom old"
]
1.58 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "красивая mom old"
]

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.