Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.66 ms
(78.53%)
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
  389098
  390303
  390807
  392030
  400835
  411368
  411385
  424198
  424431
  439766
  443139
  443754
  444115
  447236
  452950
  454220
  454236
  454274
  454280
  454951
  455026
  456603
  466101
  466109
  466112
  466182
  467435
  467523
  469128
  469906
  470720
  470931
  471046
  474645
  474790
  476841
  478364
  479092
  479106
  479128
  481467
  484386
  484469
  484565
  484605
  484619
  487358
  488527
  489171
  489384
  490414
  490427
  490731
  491320
  495040
  495228
  495518
  496975
  502730
  504493
  507541
  509241
  511086
  511830
  513523
  513527
  513697
  517076
  518999
  519363
  523161
  523824
  523827
  524781
  526040
  529223
  530707
  534670
  535390
  538006
  540799
  544859
  547987
  549734
  549823
  550220
  554989
  563010
  563156
  563159
  563203
  563217
  564655
  573728
  581614
  584114
  584705
  602782
  617115
  619223
  696324
  718746
  721427
  721487
  727760
  752170
  765227
  781665
  781733
  781741
  785941
  786527
  788473
  788545
  794301
  796487
  801450
  805666
  806952
  807336
]
24.25 ms
(14.03%)
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
  479128
  511086
  696324
  411368
  518999
  507541
  389098
  547987
  549734
  424431
  454280
  495040
  511830
  471046
  718746
  786527
  765227
  801450
  470931
  456603
  496975
  534670
  484565
  523161
  785941
  788473
  805666
  392030
  467523
  513697
  444115
  563217
  573728
  495518
  411385
  476841
  455026
  454274
  502730
  509241
  488527
  563156
  554989
  602782
  806952
  727760
  474790
  390303
  390807
  400835
  513527
  535390
  519363
  530707
  563203
  454236
  467435
  491320
  470720
  454220
  544859
  584114
  721427
  721487
  619223
  781733
  807336
  781665
  781741
  424198
  454951
  469128
  487358
  526040
  484619
  549823
  550220
  563010
  581614
  788545
  796487
  794301
  466109
  538006
  495228
  513523
  524781
  489384
  490731
  489171
  490427
  523827
  484386
  563159
  540799
  443754
  564655
  484605
  504493
  469906
  584705
  752170
  479092
  479106
  481467
  529223
  439766
  466112
  447236
  478364
  452950
  466101
  484469
  517076
  443139
  490414
  523824
  466182
  617115
  474645
]
4.46 ms
(2.58%)
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
  389098
  390303
  390807
  392030
  400835
  411368
  411385
  424198
  424431
  439766
  443139
  443754
  444115
  447236
  452950
  454220
  454236
  454274
  454280
  454951
  455026
  456603
  466101
  466109
  466112
  466182
  467435
  467523
  469128
  469906
  470720
  470931
  471046
  474645
  474790
  476841
  478364
  479092
  479106
  479128
  481467
  484386
  484469
  484565
  484605
  484619
  487358
  488527
  489171
  489384
  490414
  490427
  490731
  491320
  495040
  495228
  495518
  496975
  502730
  504493
  507541
  509241
  511086
  511830
  513523
  513527
  513697
  517076
  518999
  519363
  523161
  523824
  523827
  524781
  526040
  529223
  530707
  534670
  535390
  538006
  540799
  544859
  547987
  549734
  549823
  550220
  554989
  563010
  563156
  563159
  563203
  563217
  564655
  573728
  581614
  584114
  584705
  602782
  617115
  619223
  696324
  718746
  721427
  721487
  727760
  752170
  765227
  781665
  781733
  781741
  785941
  786527
  788473
  788545
  794301
  796487
  801450
  805666
  806952
  807336
]
2.38 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русские дойки зрелые"
]
2.29 ms
(1.33%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск сиськ зрелая женщин"
]
1.82 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.