Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.07 ms
(84.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
  7161
  89199
  117755
  187775
  290366
  311897
  382410
  387848
  391563
  396784
  398073
  398089
  399083
  400571
  401625
  410346
  414042
  415978
  416508
  416581
  416634
  416701
  431381
  434523
  443242
  447160
  452274
  453221
  453788
  461610
  461725
  462337
  469615
  469619
  470278
  481904
  483742
  486768
  486776
  493691
  493838
  494999
  499931
  499936
  502043
  506149
  515441
  517928
  519481
  520713
  521831
  525731
  530026
  531194
  531255
  532755
  533369
  533519
  534229
  534529
  536380
  537863
  543871
  545305
  556476
  559294
  565256
  571194
  580623
  592369
  599966
  600128
  609888
  614978
  621682
  623154
  628087
  632283
  632588
  632657
  632927
  633748
  633755
  634799
  635171
  637003
  639027
  639716
  639760
  639774
  647905
  647914
  647993
  656626
  666528
  666865
  666894
  666902
  674943
  674967
  674968
  679032
  685701
  689614
  698102
  738820
  741252
  742224
  751670
  752672
  756192
  758599
  761572
  800577
  805543
  806541
  806543
  806919
  809122
  817782
]
20.33 ms
(10.92%)
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
  447160
  519481
  502043
  806543
  738820
  674943
  531255
  647993
  632283
  493691
  752672
  416701
  637003
  387848
  290366
  453221
  556476
  469619
  401625
  580623
  533519
  647914
  639027
  506149
  494999
  483742
  517928
  499936
  571194
  592369
  537863
  530026
  674968
  800577
  117755
  382410
  817782
  414042
  534229
  545305
  666528
  647905
  666902
  486776
  525731
  521831
  689614
  639774
  7161
  758599
  391563
  187775
  434523
  499931
  416508
  416581
  461610
  469615
  89199
  515441
  534529
  809122
  520713
  679032
  415978
  481904
  632657
  632588
  633748
  311897
  533369
  565256
  674967
  599966
  628087
  635171
  639716
  639760
  443242
  462337
  461725
  536380
  756192
  399083
  398089
  400571
  452274
  600128
  805543
  685701
  666865
  666894
  632927
  543871
  431381
  453788
  634799
  621682
  398073
  486768
  559294
  623154
  633755
  609888
  806919
  761572
  806541
  741252
  742224
  751670
  493838
  396784
  531194
  470278
  532755
  416634
  698102
  410346
  656626
  614978
]
2.26 ms
(1.21%)
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
  7161
  89199
  117755
  187775
  290366
  311897
  382410
  387848
  391563
  396784
  398073
  398089
  399083
  400571
  401625
  410346
  414042
  415978
  416508
  416581
  416634
  416701
  431381
  434523
  443242
  447160
  452274
  453221
  453788
  461610
  461725
  462337
  469615
  469619
  470278
  481904
  483742
  486768
  486776
  493691
  493838
  494999
  499931
  499936
  502043
  506149
  515441
  517928
  519481
  520713
  521831
  525731
  530026
  531194
  531255
  532755
  533369
  533519
  534229
  534529
  536380
  537863
  543871
  545305
  556476
  559294
  565256
  571194
  580623
  592369
  599966
  600128
  609888
  614978
  621682
  623154
  628087
  632283
  632588
  632657
  632927
  633748
  633755
  634799
  635171
  637003
  639027
  639716
  639760
  639774
  647905
  647914
  647993
  656626
  666528
  666865
  666894
  666902
  674943
  674967
  674968
  679032
  685701
  689614
  698102
  738820
  741252
  742224
  751670
  752672
  756192
  758599
  761572
  800577
  805543
  806541
  806543
  806919
  809122
  817782
]
2.02 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "фистинг анал красотки…"
]
1.69 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фистинг анал красивая"
]
1.25 ms
(0.67%)
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.