Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.85 ms
(85.93%)
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
  209335
  220912
  382702
  382793
  383159
  387391
  390865
  398022
  398236
  399415
  402172
  407374
  411416
  415862
  416298
  430700
  454293
  457764
  457765
  461568
  461918
  462364
  462736
  474012
  474024
  474551
  482172
  484469
  487005
  488883
  497917
  501238
  506053
  511023
  515220
  522409
  533867
  534215
  539051
  540187
  540195
  543413
  543416
  549302
  550727
  552935
  554889
  557392
  559372
  567396
  575752
  603242
  607155
  613333
  620557
  622111
  622228
  623517
  626733
  631913
  633508
  641928
  641999
  645233
  645891
  650603
  670376
  670689
  670773
  671734
  677552
  679396
  679447
  679462
  680195
  693137
  701501
  709784
  711891
  712649
  712712
  714193
  715096
  715559
  716236
  716373
  716746
  717731
  718955
  721835
  723982
  726719
  728038
  743380
  743771
  748243
  748695
  770256
  773554
  775140
  775803
  776022
  776307
  776971
  778364
  786255
  789521
  799362
  800947
  804459
  808511
  810770
  815331
  815479
  818377
  820768
  820980
  821316
  822642
  827206
]
13.99 ms
(8.41%)
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
  728038
  623517
  712649
  804459
  390865
  411416
  534215
  398022
  482172
  383159
  430700
  718955
  775803
  716746
  680195
  743380
  474551
  671734
  800947
  622228
  506053
  550727
  670689
  715559
  677552
  620557
  810770
  726719
  770256
  773554
  776022
  776307
  549302
  474024
  511023
  641999
  220912
  533867
  540187
  679462
  670376
  622111
  631913
  633508
  641928
  789521
  474012
  701501
  399415
  539051
  540195
  567396
  679447
  716236
  716373
  679396
  603242
  778364
  776971
  398236
  501238
  462736
  402172
  454293
  484469
  415862
  645891
  613333
  382793
  382702
  407374
  818377
  820768
  488883
  457765
  457764
  461918
  559372
  575752
  557392
  670773
  715096
  721835
  645233
  711891
  714193
  717731
  693137
  626733
  607155
  786255
  808511
  775140
  723982
  748243
  743771
  748695
  799362
  209335
  461568
  462364
  387391
  416298
  487005
  522409
  497917
  815331
  820980
  827206
  821316
  815479
  822642
  515220
  543413
  543416
  552935
  554889
  650603
  709784
  712712
]
2.68 ms
(1.61%)
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
  209335
  220912
  382702
  382793
  383159
  387391
  390865
  398022
  398236
  399415
  402172
  407374
  411416
  415862
  416298
  430700
  454293
  457764
  457765
  461568
  461918
  462364
  462736
  474012
  474024
  474551
  482172
  484469
  487005
  488883
  497917
  501238
  506053
  511023
  515220
  522409
  533867
  534215
  539051
  540187
  540195
  543413
  543416
  549302
  550727
  552935
  554889
  557392
  559372
  567396
  575752
  603242
  607155
  613333
  620557
  622111
  622228
  623517
  626733
  631913
  633508
  641928
  641999
  645233
  645891
  650603
  670376
  670689
  670773
  671734
  677552
  679396
  679447
  679462
  680195
  693137
  701501
  709784
  711891
  712649
  712712
  714193
  715096
  715559
  716236
  716373
  716746
  717731
  718955
  721835
  723982
  726719
  728038
  743380
  743771
  748243
  748695
  770256
  773554
  775140
  775803
  776022
  776307
  776971
  778364
  786255
  789521
  799362
  800947
  804459
  808511
  810770
  815331
  815479
  818377
  820768
  820980
  821316
  822642
  827206
]
2.02 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "порно куни групповуха…"
]
1.59 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "порн куннилингус оральн секс группов секс"
]
1.57 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "порн куннилингус оральн секс группов секс"
]
1.53 ms
(0.92%)
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.