Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.34 ms
(85.70%)
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
  386565
  418389
  447977
  463137
  472749
  485235
  493823
  493827
  493828
  500958
  507955
  531588
  531595
  538472
  539189
  547225
  550425
  558726
  570746
  571092
  574979
  576613
  583403
  584178
  587268
  601794
  602645
  607688
  607906
  611493
  615937
  616053
  617835
  621548
  623382
  628519
  628602
  629544
  632288
  636587
  640148
  644167
  650649
  650659
  650681
  650990
  666114
  666120
  669245
  671839
  683042
  696106
  700303
  702300
  705102
  710398
  712393
  713838
  715136
  715409
  716973
  717261
  717285
  720089
  720168
  720182
  720946
  724583
  731984
  732494
  734183
  734640
  734778
  734797
  734800
  734978
  735781
  737770
  738160
  738181
  738191
  738942
  739008
  740675
  740757
  740758
  742113
  743005
  748378
  749498
  749508
  750494
  753733
  756189
  757474
  757575
  761226
  762761
  771290
  788441
  788550
  794343
  795881
  797087
  799409
  800635
  801724
  808097
  810515
  810873
  810924
  810941
  811117
  811151
  811927
  813695
  813698
  816624
  816675
  825789
]
12.78 ms
(7.75%)
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
  810941
  737770
  742113
  743005
  757474
  757575
  738942
  738160
  531595
  671839
  738181
  816624
  485235
  705102
  717261
  615937
  607906
  734183
  788550
  808097
  734778
  753733
  734800
  799409
  816675
  813695
  558726
  683042
  702300
  720089
  720182
  587268
  611493
  617835
  800635
  810515
  810873
  810924
  811117
  795881
  749498
  761226
  739008
  418389
  493828
  493827
  539189
  715409
  716973
  570746
  629544
  644167
  801724
  738191
  740757
  713838
  538472
  628602
  636587
  734640
  740675
  748378
  825789
  576613
  574979
  650649
  650990
  696106
  720168
  756189
  700303
  813698
  583403
  550425
  650681
  717285
  710398
  650659
  547225
  616053
  601794
  607688
  621548
  811151
  811927
  724583
  732494
  735781
  715136
  740758
  749508
  386565
  447977
  493823
  666114
  571092
  602645
  794343
  762761
  788441
  734797
  734978
  750494
  771290
  632288
  712393
  797087
  472749
  531588
  720946
  623382
  731984
  463137
  500958
  507955
  669245
  666120
  584178
  628519
  640148
]
3.32 ms
(2.01%)
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
  386565
  418389
  447977
  463137
  472749
  485235
  493823
  493827
  493828
  500958
  507955
  531588
  531595
  538472
  539189
  547225
  550425
  558726
  570746
  571092
  574979
  576613
  583403
  584178
  587268
  601794
  602645
  607688
  607906
  611493
  615937
  616053
  617835
  621548
  623382
  628519
  628602
  629544
  632288
  636587
  640148
  644167
  650649
  650659
  650681
  650990
  666114
  666120
  669245
  671839
  683042
  696106
  700303
  702300
  705102
  710398
  712393
  713838
  715136
  715409
  716973
  717261
  717285
  720089
  720168
  720182
  720946
  724583
  731984
  732494
  734183
  734640
  734778
  734797
  734800
  734978
  735781
  737770
  738160
  738181
  738191
  738942
  739008
  740675
  740757
  740758
  742113
  743005
  748378
  749498
  749508
  750494
  753733
  756189
  757474
  757575
  761226
  762761
  771290
  788441
  788550
  794343
  795881
  797087
  799409
  800635
  801724
  808097
  810515
  810873
  810924
  810941
  811117
  811151
  811927
  813695
  813698
  816624
  816675
  825789
]
2.01 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк indian"
]
1.89 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl indian"
]
1.71 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк indian"
]

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.