Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
177.62 ms
(85.28%)
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
  146112
  233269
  233397
  387377
  389829
  391380
  397410
  400463
  400719
  400817
  401116
  408429
  418803
  428867
  430275
  439572
  439715
  441001
  441017
  447492
  454179
  454232
  454244
  456341
  464520
  465791
  467296
  469905
  470029
  472764
  477906
  477994
  478337
  480957
  490208
  494536
  496356
  501442
  504669
  506042
  510689
  512041
  518842
  519492
  523138
  524664
  526025
  526594
  533763
  537985
  545530
  546002
  546951
  548655
  549768
  550233
  553608
  558417
  560579
  560594
  561731
  563063
  563214
  569983
  570069
  574815
  574838
  576127
  586449
  590224
  594223
  595873
  596161
  596616
  597494
  598069
  598441
  604147
  605841
  624487
  654846
  660300
  664433
  676951
  678954
  679378
  695316
  696324
  701508
  709588
  714448
  716543
  722781
  722823
  722827
  726892
  744328
  747008
  747583
  765891
  784569
  785337
  789182
  789874
  794906
  798992
  800316
  800535
  805243
  808192
  809909
  811611
  812364
  814562
  821839
  821846
  821854
  821856
  821867
  825867
]
19.41 ms
(9.32%)
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
  518842
  526594
  523138
  821839
  678954
  660300
  784569
  744328
  747008
  800316
  789874
  798992
  789182
  469905
  512041
  233269
  400719
  472764
  506042
  537985
  821854
  598069
  605841
  597494
  812364
  785337
  722823
  722827
  811611
  400463
  501442
  526025
  550233
  595873
  545530
  563063
  558417
  561731
  389829
  441001
  464520
  447492
  465791
  477994
  430275
  454232
  519492
  524664
  490208
  496356
  821856
  821846
  560579
  654846
  679378
  726892
  576127
  397410
  696324
  233397
  825867
  439715
  439572
  533763
  546951
  570069
  716543
  553608
  563214
  596161
  809909
  722781
  794906
  400817
  387377
  391380
  401116
  428867
  480957
  478337
  510689
  598441
  408429
  146112
  596616
  548655
  549768
  470029
  477906
  454244
  441017
  454179
  494536
  814562
  821867
  456341
  467296
  504669
  569983
  574838
  560594
  574815
  664433
  701508
  676951
  695316
  546002
  604147
  586449
  590224
  594223
  805243
  800535
  765891
  747583
  624487
  709588
  714448
  808192
  418803
]
3.04 ms
(1.46%)
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
  146112
  233269
  233397
  387377
  389829
  391380
  397410
  400463
  400719
  400817
  401116
  408429
  418803
  428867
  430275
  439572
  439715
  441001
  441017
  447492
  454179
  454232
  454244
  456341
  464520
  465791
  467296
  469905
  470029
  472764
  477906
  477994
  478337
  480957
  490208
  494536
  496356
  501442
  504669
  506042
  510689
  512041
  518842
  519492
  523138
  524664
  526025
  526594
  533763
  537985
  545530
  546002
  546951
  548655
  549768
  550233
  553608
  558417
  560579
  560594
  561731
  563063
  563214
  569983
  570069
  574815
  574838
  576127
  586449
  590224
  594223
  595873
  596161
  596616
  597494
  598069
  598441
  604147
  605841
  624487
  654846
  660300
  664433
  676951
  678954
  679378
  695316
  696324
  701508
  709588
  714448
  716543
  722781
  722823
  722827
  726892
  744328
  747008
  747583
  765891
  784569
  785337
  789182
  789874
  794906
  798992
  800316
  800535
  805243
  808192
  809909
  811611
  812364
  814562
  821839
  821846
  821854
  821856
  821867
  825867
]
2.43 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian fuck young"
]
2.02 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.93 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск секс young"
]
1.83 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск секс young"
]

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.