Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.81 ms
(78.35%)
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
  418368
  418867
  420685
  421238
  422395
  427555
  427657
  430805
  433742
  435320
  438978
  446082
  446456
  446569
  446584
  448375
  451549
  452622
  453668
  454264
  456233
  457899
  457961
  458119
  459745
  463644
  463677
  463847
  466913
  469094
  469577
  470041
  470719
  471743
  474840
  475015
  475811
  476917
  479481
  479754
  480611
  480919
  485223
  489793
  491531
  491659
  491772
  492370
  492380
  492836
  497075
  497375
  504885
  506932
  507483
  509449
  509978
  510118
  510221
  510472
  510603
  511814
  512129
  512158
  512476
  515796
  516946
  518093
  518208
  518267
  518375
  519496
  522819
  533145
  535531
  536494
  544444
  545783
  548633
  549517
  549774
  550011
  551277
  558599
  560432
  564864
  565051
  565179
  566022
  567120
  568121
  569402
  569593
  569988
  570019
  571361
  571884
  574599
  576097
  576341
  576343
  581058
  581531
  586385
  589677
  592569
  595013
  595860
  596017
  596989
  598971
  599169
  602136
  608715
  629042
  649520
  677364
  689660
  751424
  780191
]
13.03 ms
(8.52%)
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
  457961
  689660
  479481
  466913
  446584
  536494
  545783
  560432
  574599
  581531
  576341
  548633
  550011
  448375
  475811
  476917
  492380
  506932
  491659
  512158
  497075
  511814
  489793
  629042
  454264
  492836
  485223
  515796
  571884
  480919
  420685
  558599
  430805
  418368
  446456
  456233
  535531
  549774
  567120
  602136
  598971
  596989
  599169
  418867
  509978
  589677
  469094
  479754
  421238
  576343
  586385
  446569
  549517
  470719
  470041
  492370
  569593
  427555
  512129
  480611
  569402
  451549
  433742
  512476
  518267
  564864
  581058
  452622
  474840
  510603
  566022
  571361
  565179
  649520
  608715
  463677
  422395
  504885
  519496
  510118
  510472
  518093
  518375
  427657
  453668
  458119
  459745
  469577
  570019
  576097
  565051
  592569
  596017
  595013
  475015
  435320
  463644
  446082
  507483
  518208
  491772
  516946
  457899
  463847
  509449
  497375
  544444
  568121
  569988
  677364
  751424
  491531
  510221
  780191
  522819
  595860
  438978
  533145
  551277
  471743
]
12.99 ms
(8.49%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк сиськ"
]
2.40 ms
(1.57%)
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
  418368
  418867
  420685
  421238
  422395
  427555
  427657
  430805
  433742
  435320
  438978
  446082
  446456
  446569
  446584
  448375
  451549
  452622
  453668
  454264
  456233
  457899
  457961
  458119
  459745
  463644
  463677
  463847
  466913
  469094
  469577
  470041
  470719
  471743
  474840
  475015
  475811
  476917
  479481
  479754
  480611
  480919
  485223
  489793
  491531
  491659
  491772
  492370
  492380
  492836
  497075
  497375
  504885
  506932
  507483
  509449
  509978
  510118
  510221
  510472
  510603
  511814
  512129
  512158
  512476
  515796
  516946
  518093
  518208
  518267
  518375
  519496
  522819
  533145
  535531
  536494
  544444
  545783
  548633
  549517
  549774
  550011
  551277
  558599
  560432
  564864
  565051
  565179
  566022
  567120
  568121
  569402
  569593
  569988
  570019
  571361
  571884
  574599
  576097
  576341
  576343
  581058
  581531
  586385
  589677
  592569
  595013
  595860
  596017
  596989
  598971
  599169
  602136
  608715
  629042
  649520
  677364
  689660
  751424
  780191
]
1.81 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl tits"
]
1.54 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк сиськ"
]
1.33 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.