Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
214.36 ms
(34.67%)
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
  79788
  233298
  392082
  395430
  418034
  423141
  429652
  431760
  433487
  450069
  450664
  451279
  453854
  455222
  455834
  456188
  456189
  462210
  462245
  463212
  469130
  472303
  472389
  476781
  483647
  485089
  485096
  486233
  487860
  493408
  495261
  497246
  497853
  498846
  500387
  503471
  503472
  503682
  504246
  505755
  505944
  506002
  507154
  507746
  508272
  508592
  511473
  513067
  513582
  513623
  515596
  515618
  515711
  516497
  517200
  520931
  520933
  521171
  522961
  523002
  523137
  525619
  527326
  528465
  528524
  528673
  528679
  530545
  533721
  535745
  541907
  544794
  548154
  549164
  552806
  553658
  562460
  568699
  570755
  582033
  585257
  585473
  588347
  591823
  599697
  600790
  600794
  600858
  602429
  604307
  604783
  605221
  626945
  642934
  643188
  643386
  662386
  664531
  669712
  670386
  670622
  677838
  679632
  704068
  724171
  724312
  725513
  726977
  735875
  736908
  740061
  746179
  776886
  782729
  789281
  791455
  797247
  803534
  811105
  819662
]
210.55 ms
(34.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "office amateur"
]
171.81 ms
(27.79%)
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
  79788
  233298
  392082
  395430
  418034
  423141
  429652
  431760
  433487
  450069
  450664
  451279
  453854
  455222
  455834
  456188
  456189
  462210
  462245
  463212
  469130
  472303
  472389
  476781
  483647
  485089
  485096
  486233
  487860
  493408
  495261
  497246
  497853
  498846
  500387
  503471
  503472
  503682
  504246
  505755
  505944
  506002
  507154
  507746
  508272
  508592
  511473
  513067
  513582
  513623
  515596
  515618
  515711
  516497
  517200
  520931
  520933
  521171
  522961
  523002
  523137
  525619
  527326
  528465
  528524
  528673
  528679
  530545
  533721
  535745
  541907
  544794
  548154
  549164
  552806
  553658
  562460
  568699
  570755
  582033
  585257
  585473
  588347
  591823
  599697
  600790
  600794
  600858
  602429
  604307
  604783
  605221
  626945
  642934
  643188
  643386
  662386
  664531
  669712
  670386
  670622
  677838
  679632
  704068
  724171
  724312
  725513
  726977
  735875
  736908
  740061
  746179
  776886
  782729
  789281
  791455
  797247
  803534
  811105
  819662
]
16.05 ms
(2.60%)
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
  483647
  392082
  79788
  541907
  811105
  724171
  789281
  513623
  498846
  735875
  233298
  626945
  497853
  549164
  553658
  599697
  500387
  504246
  528673
  433487
  495261
  552806
  520933
  585257
  472303
  497246
  418034
  456189
  513067
  530545
  776886
  803534
  791455
  797247
  724312
  527326
  453854
  503472
  643386
  600858
  528679
  544794
  679632
  528465
  582033
  533721
  513582
  643188
  604307
  746179
  726977
  395430
  450664
  505755
  485096
  485089
  570755
  669712
  516497
  517200
  487860
  431760
  515618
  588347
  423141
  451279
  462245
  463212
  515596
  604783
  515711
  664531
  476781
  456188
  486233
  562460
  670386
  455222
  605221
  523002
  511473
  506002
  523137
  548154
  704068
  782729
  725513
  736908
  469130
  662386
  568699
  591823
  585473
  455834
  429652
  508272
  507154
  670622
  642934
  505944
  525619
  677838
  450069
  522961
  503682
  503471
  493408
  528524
  472389
  507746
  535745
  602429
  600794
  520931
  521171
  600790
  740061
  508592
  819662
  462210
]
1.92 ms
(0.31%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(0.31%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секретарш любительск"
]
1.63 ms
(0.26%)
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.