Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.30 ms
(85.37%)
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
  382266
  403373
  408164
  408411
  416926
  418256
  418259
  421137
  421578
  421594
  421613
  424392
  425472
  425495
  426424
  430562
  432318
  432696
  434432
  434936
  440852
  442143
  445266
  445585
  445814
  448064
  449260
  449302
  449320
  449331
  453021
  456367
  456387
  456400
  457805
  460904
  463072
  463496
  464190
  464243
  469195
  472113
  476149
  476853
  479285
  481173
  482618
  482755
  484218
  495992
  499527
  500184
  504962
  505538
  510827
  511633
  515002
  516975
  519762
  526627
  529438
  547575
  547586
  555980
  556115
  557706
  559459
  559989
  560833
  564711
  564929
  581501
  582220
  589942
  590750
  595514
  596347
  596411
  607342
  617087
  617636
  626872
  661462
  662374
  707427
  708232
  710349
  715138
  724335
  724520
  746201
  750732
  756165
  761294
  761866
  770615
  770662
  770784
  772254
  781586
  784493
  785624
  786715
  787118
  793642
  798775
  799350
  799957
  801157
  801519
  802711
  806183
  806895
  809466
  809617
  811745
  811845
  813187
  814399
  820147
]
15.85 ms
(9.06%)
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
  801157
  806183
  813187
  786715
  793642
  799957
  806895
  809617
  750732
  770615
  772254
  799350
  801519
  802711
  811745
  724520
  761866
  746201
  756165
  761294
  770662
  724335
  770784
  707427
  715138
  781586
  785624
  787118
  798775
  382266
  418256
  424392
  432318
  449260
  460904
  464190
  476149
  421613
  442143
  479285
  418259
  421578
  426424
  430562
  434432
  445585
  449302
  456400
  421137
  434936
  457805
  515002
  499527
  495992
  526627
  500184
  505538
  511633
  519762
  425495
  453021
  445814
  516975
  590750
  784493
  809466
  472113
  463072
  425472
  449320
  481173
  504962
  582220
  559989
  811845
  529438
  403373
  408164
  416926
  440852
  432696
  408411
  421594
  445266
  820147
  814399
  456367
  456387
  464243
  469195
  463496
  476853
  448064
  449331
  482755
  510827
  482618
  484218
  555980
  557706
  559459
  581501
  547575
  547586
  556115
  560833
  564711
  661462
  662374
  708232
  710349
  564929
  595514
  596347
  607342
  617087
  626872
  589942
  617636
  596411
]
2.98 ms
(1.71%)
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
  382266
  403373
  408164
  408411
  416926
  418256
  418259
  421137
  421578
  421594
  421613
  424392
  425472
  425495
  426424
  430562
  432318
  432696
  434432
  434936
  440852
  442143
  445266
  445585
  445814
  448064
  449260
  449302
  449320
  449331
  453021
  456367
  456387
  456400
  457805
  460904
  463072
  463496
  464190
  464243
  469195
  472113
  476149
  476853
  479285
  481173
  482618
  482755
  484218
  495992
  499527
  500184
  504962
  505538
  510827
  511633
  515002
  516975
  519762
  526627
  529438
  547575
  547586
  555980
  556115
  557706
  559459
  559989
  560833
  564711
  564929
  581501
  582220
  589942
  590750
  595514
  596347
  596411
  607342
  617087
  617636
  626872
  661462
  662374
  707427
  708232
  710349
  715138
  724335
  724520
  746201
  750732
  756165
  761294
  761866
  770615
  770662
  770784
  772254
  781586
  784493
  785624
  786715
  787118
  793642
  798775
  799350
  799957
  801157
  801519
  802711
  806183
  806895
  809466
  809617
  811745
  811845
  813187
  814399
  820147
]
1.87 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy face"
]
1.85 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy face"
]
1.43 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy face"
]

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.