Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
177.72 ms
(86.41%)
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
  181009
  396321
  397366
  405531
  423836
  424198
  424493
  424658
  427487
  428068
  430072
  434361
  443119
  443689
  443773
  448365
  448619
  454529
  454658
  458841
  467923
  469071
  471007
  472235
  474496
  476992
  477376
  477959
  477966
  484603
  484609
  484716
  485363
  486788
  487450
  490106
  491986
  498865
  499865
  503962
  504176
  504354
  504640
  505623
  506050
  509206
  509232
  510524
  510750
  512347
  514913
  518563
  523415
  524766
  524886
  525119
  527624
  527753
  533384
  534250
  541781
  542190
  543088
  544475
  544477
  544484
  544829
  550374
  554889
  555716
  556906
  558009
  563063
  563444
  565659
  565808
  565983
  566155
  567396
  567433
  568560
  573216
  574464
  576626
  576636
  581130
  584073
  585968
  586256
  590192
  591134
  592515
  592970
  594557
  606618
  622826
  623608
  663409
  663448
  663455
  663507
  664287
  665107
  665123
  665274
  665490
  668412
  668743
  669738
  672138
  678967
  702621
  720603
  726120
  728194
  742286
  752679
  790998
  796071
  802493
]
17.36 ms
(8.44%)
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
  487450
  510524
  534250
  504176
  542190
  544477
  563063
  563444
  574464
  541781
  543088
  558009
  678967
  663448
  665107
  397366
  424658
  510750
  484716
  506050
  512347
  484609
  524886
  491986
  503962
  181009
  458841
  523415
  514913
  509232
  544484
  581130
  576626
  606618
  585968
  623608
  796071
  726120
  720603
  802493
  454529
  424493
  476992
  472235
  584073
  566155
  576636
  555716
  665490
  702621
  434361
  527624
  405531
  428068
  477959
  448619
  448365
  474496
  533384
  544475
  544829
  550374
  556906
  565808
  567396
  567433
  554889
  568560
  573216
  665274
  668412
  663409
  672138
  664287
  665123
  668743
  622826
  591134
  592970
  594557
  586256
  590192
  592515
  790998
  742286
  752679
  443119
  467923
  477376
  423836
  443689
  424198
  427487
  471007
  509206
  484603
  485363
  498865
  499865
  504640
  490106
  527753
  430072
  454658
  469071
  486788
  505623
  524766
  525119
  504354
  565983
  565659
  663507
  663455
  669738
  728194
  396321
  443773
  477966
  518563
]
3.37 ms
(1.64%)
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
  181009
  396321
  397366
  405531
  423836
  424198
  424493
  424658
  427487
  428068
  430072
  434361
  443119
  443689
  443773
  448365
  448619
  454529
  454658
  458841
  467923
  469071
  471007
  472235
  474496
  476992
  477376
  477959
  477966
  484603
  484609
  484716
  485363
  486788
  487450
  490106
  491986
  498865
  499865
  503962
  504176
  504354
  504640
  505623
  506050
  509206
  509232
  510524
  510750
  512347
  514913
  518563
  523415
  524766
  524886
  525119
  527624
  527753
  533384
  534250
  541781
  542190
  543088
  544475
  544477
  544484
  544829
  550374
  554889
  555716
  556906
  558009
  563063
  563444
  565659
  565808
  565983
  566155
  567396
  567433
  568560
  573216
  574464
  576626
  576636
  581130
  584073
  585968
  586256
  590192
  591134
  592515
  592970
  594557
  606618
  622826
  623608
  663409
  663448
  663455
  663507
  664287
  665107
  665123
  665274
  665490
  668412
  668743
  669738
  672138
  678967
  702621
  720603
  726120
  728194
  742286
  752679
  790998
  796071
  802493
]
2.31 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny mature pussy"
]
1.77 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые mature pussy"
]
1.45 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худые mature pussy"
]

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.