Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.02 ms
(87.39%)
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
  97276
  129857
  382017
  384253
  393771
  395612
  396540
  399668
  409174
  419850
  422817
  434747
  445781
  446963
  446992
  448042
  448089
  448565
  450370
  451515
  456288
  456366
  457257
  460408
  461274
  462273
  467360
  469326
  469720
  474072
  474807
  477521
  479710
  480546
  483962
  487680
  491521
  493043
  495644
  496561
  499720
  500013
  501404
  501567
  504024
  504853
  512932
  524618
  526404
  529292
  533867
  542535
  548239
  550472
  551570
  554889
  555206
  561753
  563399
  565167
  565432
  586452
  587058
  588774
  595792
  596692
  605654
  606089
  609793
  612534
  613465
  621424
  622681
  625945
  627639
  649860
  660649
  660725
  662169
  664562
  672355
  681222
  684574
  700834
  704966
  706601
  712123
  717856
  718520
  720390
  723982
  725864
  731994
  738909
  743811
  748154
  756504
  757661
  764037
  767983
  772425
  772693
  775591
  789067
  789424
  790158
  793623
  797508
  801322
  801608
  802864
  805383
  810547
  812120
  813549
  816036
  816894
  823591
  826628
]
13.59 ms
(7.42%)
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
  621424
  596692
  586452
  627639
  797508
  789424
  790158
  764037
  725864
  757661
  609793
  706601
  793623
  810547
  384253
  595792
  382017
  456366
  565432
  555206
  565167
  467360
  767983
  704966
  524618
  456288
  512932
  660725
  588774
  812120
  775591
  563399
  462273
  504853
  625945
  409174
  826628
  823591
  816036
  816894
  700834
  772693
  97276
  434747
  446992
  660649
  772425
  801608
  802864
  684574
  756504
  448042
  504024
  526404
  548239
  469720
  446963
  422817
  450370
  419850
  457257
  483962
  479710
  551570
  649860
  681222
  718520
  672355
  717856
  588719
  606089
  738909
  731994
  605654
  622681
  480546
  451515
  460408
  474072
  396540
  477521
  491521
  813549
  448565
  662169
  664562
  129857
  393771
  395612
  496561
  533867
  550472
  554889
  720390
  613465
  723982
  789067
  748154
  743811
  712123
  801322
  493043
  487680
  501567
  399668
  500013
  499720
  529292
  461274
  542535
  469326
  474807
  495644
  561753
  445781
  448089
  612534
  587058
  501404
  805383
]
2.76 ms
(1.51%)
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
  97276
  129857
  382017
  384253
  393771
  395612
  396540
  399668
  409174
  419850
  422817
  434747
  445781
  446963
  446992
  448042
  448089
  448565
  450370
  451515
  456288
  456366
  457257
  460408
  461274
  462273
  467360
  469326
  469720
  474072
  474807
  477521
  479710
  480546
  483962
  487680
  491521
  493043
  495644
  496561
  499720
  500013
  501404
  501567
  504024
  504853
  512932
  524618
  526404
  529292
  533867
  542535
  548239
  550472
  551570
  554889
  555206
  561753
  563399
  565167
  565432
  586452
  587058
  588774
  595792
  596692
  605654
  606089
  609793
  612534
  613465
  621424
  622681
  625945
  627639
  649860
  660649
  660725
  662169
  664562
  672355
  681222
  684574
  700834
  704966
  706601
  712123
  717856
  718520
  720390
  723982
  725864
  731994
  738909
  743811
  748154
  756504
  757661
  764037
  767983
  772425
  772693
  775591
  789067
  789424
  790158
  793623
  797508
  801322
  801608
  802864
  805383
  810547
  812120
  813549
  816036
  816894
  823591
  826628
]
2.04 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public pussy lick"
]
1.70 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на pussy улиц лиза"
]
1.55 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на pussy улиц лиза"
]
1.45 ms
(0.79%)
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.