Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.52 ms
(82.23%)
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
  32551
  38857
  59488
  95700
  185412
  187699
  326017
  359441
  382898
  385014
  389965
  394941
  396958
  401000
  405650
  406391
  406976
  407378
  409188
  409324
  409933
  411073
  411415
  411684
  412627
  413100
  418563
  422189
  424749
  425947
  437044
  437587
  439431
  439446
  439720
  442443
  449126
  449884
  454967
  455298
  459246
  460908
  464056
  464068
  464262
  464408
  465713
  465727
  466204
  466796
  468114
  468180
  468839
  470668
  470882
  470966
  472701
  473376
  475028
  475851
  478412
  479889
  482795
  483055
  489126
  491906
  491975
  499839
  502196
  508431
  511700
  514015
  514103
  516561
  516633
  516718
  517178
  519600
  520920
  530448
  532300
  535315
  541078
  541204
  542925
  549829
  558711
  563144
  563785
  564121
  570957
  576628
  580425
  581578
  583062
  583164
  583581
  586644
  586862
  589140
  590783
  600786
  605480
  605514
  605902
  606355
  609999
  615431
  657768
  663378
  709533
  712307
  724157
  755510
  759900
  767458
  770128
  785299
  803734
  812093
]
16.56 ms
(10.93%)
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
  32551
  439720
  663378
  437587
  389965
  439431
  605480
  59488
  468114
  464056
  466796
  442443
  475851
  412627
  483055
  382898
  558711
  394941
  439446
  455298
  449126
  502196
  516561
  563785
  519600
  424749
  409933
  583581
  413100
  185412
  724157
  755510
  770128
  516633
  449884
  385014
  470668
  491975
  418563
  411073
  489126
  767458
  38857
  464068
  396958
  508431
  479889
  465713
  542925
  514015
  541078
  564121
  615431
  581578
  785299
  359441
  499839
  759900
  472701
  459246
  709533
  532300
  514103
  563144
  464408
  405650
  409188
  454967
  473376
  517178
  511700
  491906
  605902
  576628
  516718
  470966
  466204
  583062
  549829
  407378
  411684
  401000
  422189
  586644
  437044
  583164
  606355
  409324
  465727
  470882
  530448
  570957
  580425
  590783
  586862
  475028
  609999
  464262
  482795
  520920
  406976
  468180
  411415
  803734
  468839
  326017
  478412
  600786
  541204
  605514
  812093
  589140
  535315
  712307
  425947
  95700
  406391
  460908
  657768
  187699
]
2.50 ms
(1.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "скачать женщин в трус%…"
]
2.47 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
  32551
  38857
  59488
  95700
  185412
  187699
  326017
  359441
  382898
  385014
  389965
  394941
  396958
  401000
  405650
  406391
  406976
  407378
  409188
  409324
  409933
  411073
  411415
  411684
  412627
  413100
  418563
  422189
  424749
  425947
  437044
  437587
  439431
  439446
  439720
  442443
  449126
  449884
  454967
  455298
  459246
  460908
  464056
  464068
  464262
  464408
  465713
  465727
  466204
  466796
  468114
  468180
  468839
  470668
  470882
  470966
  472701
  473376
  475028
  475851
  478412
  479889
  482795
  483055
  489126
  491906
  491975
  499839
  502196
  508431
  511700
  514015
  514103
  516561
  516633
  516718
  517178
  519600
  520920
  530448
  532300
  535315
  541078
  541204
  542925
  549829
  558711
  563144
  563785
  564121
  570957
  576628
  580425
  581578
  583062
  583164
  583581
  586644
  586862
  589140
  590783
  600786
  605480
  605514
  605902
  606355
  609999
  615431
  657768
  663378
  709533
  712307
  724157
  755510
  759900
  767458
  770128
  785299
  803734
  812093
]
1.86 ms
(1.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "скача женщин в трусик нижн бел"
]
1.68 ms
(1.11%)
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.