Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.59 ms
(86.45%)
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
  4375
  7170
  7286
  7441
  14477
  25069
  44968
  69589
  129791
  150507
  188390
  188447
  196166
  213692
  233488
  293121
  326290
  374819
  384905
  391545
  391561
  391696
  392100
  392277
  393135
  393326
  400004
  400026
  400672
  401209
  401940
  401975
  404122
  404188
  404633
  405421
  406070
  411119
  419550
  421562
  421871
  422958
  422960
  422989
  426718
  426725
  428116
  441765
  442057
  443893
  443939
  445833
  446740
  448810
  451499
  451983
  454163
  454840
  457884
  459842
  461569
  462434
  462450
  463936
  466241
  467113
  468344
  481760
  486209
  490143
  503292
  509223
  512973
  515996
  522906
  522949
  523985
  525695
  527867
  544142
  550228
  553472
  558131
  560990
  562105
  568936
  571847
  572763
  586573
  590542
  594231
  604364
  605680
  613836
  620290
  624226
  626543
  641006
  645962
  653033
  656522
  662913
  702633
  708457
  709703
  713181
  715098
  717892
  718755
  725934
  738274
  751500
  760454
  760925
  760971
  784600
  801281
  802715
  809808
  815950
]
14.22 ms
(8.22%)
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
  815950
  451499
  69589
  196166
  401975
  613836
  594231
  7441
  515996
  544142
  560990
  374819
  442057
  4375
  404188
  503292
  393326
  393135
  293121
  7286
  404633
  702633
  708457
  717892
  784600
  802715
  760925
  725934
  760971
  641006
  718755
  809808
  468344
  391561
  401940
  426718
  421871
  462450
  448810
  620290
  604364
  422960
  451983
  550228
  572763
  586573
  422989
  462434
  466241
  419550
  445833
  522949
  392100
  213692
  188390
  25069
  400672
  401209
  441765
  459842
  486209
  709703
  624226
  129791
  44968
  233488
  422958
  428116
  457884
  446740
  527867
  571847
  558131
  590542
  454840
  421562
  481760
  463936
  461569
  490143
  512973
  522906
  523985
  326290
  7170
  405421
  406070
  443893
  467113
  454163
  553472
  562105
  653033
  605680
  391545
  400026
  404122
  426725
  443939
  188447
  411119
  525695
  656522
  568936
  760454
  509223
  384905
  391696
  645962
  662913
  713181
  715098
  626543
  751500
  801281
  738274
  150507
  392277
  14477
  400004
]
3.00 ms
(1.73%)
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
  4375
  7170
  7286
  7441
  14477
  25069
  44968
  69589
  129791
  150507
  188390
  188447
  196166
  213692
  233488
  293121
  326290
  374819
  384905
  391545
  391561
  391696
  392100
  392277
  393135
  393326
  400004
  400026
  400672
  401209
  401940
  401975
  404122
  404188
  404633
  405421
  406070
  411119
  419550
  421562
  421871
  422958
  422960
  422989
  426718
  426725
  428116
  441765
  442057
  443893
  443939
  445833
  446740
  448810
  451499
  451983
  454163
  454840
  457884
  459842
  461569
  462434
  462450
  463936
  466241
  467113
  468344
  481760
  486209
  490143
  503292
  509223
  512973
  515996
  522906
  522949
  523985
  525695
  527867
  544142
  550228
  553472
  558131
  560990
  562105
  568936
  571847
  572763
  586573
  590542
  594231
  604364
  605680
  613836
  620290
  624226
  626543
  641006
  645962
  653033
  656522
  662913
  702633
  708457
  709703
  713181
  715098
  717892
  718755
  725934
  738274
  751500
  760454
  760925
  760971
  784600
  801281
  802715
  809808
  815950
]
1.81 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мужикам в жопу"
]
1.57 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мужчин анал"
]
1.54 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.30 ms
(0.75%)
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.