GET https://search.jues.net/search/embeds/6?q=beautiful%20friend

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
189.43 ms
(85.88%)
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
  395394
  413050
  416773
  417064
  419880
  421155
  423893
  424498
  425523
  428895
  431422
  439673
  441398
  442673
  446735
  447717
  449724
  450817
  456553
  458789
  464528
  467721
  470324
  470391
  470449
  471443
  471515
  471945
  472496
  474167
  476360
  477362
  482824
  483239
  483401
  483551
  483594
  484127
  484223
  484230
  486020
  488405
  488822
  492108
  496757
  498043
  499028
  500463
  502305
  503129
  505818
  506816
  507767
  509312
  511581
  511897
  513732
  515334
  515749
  515850
  517059
  517063
  517190
  518174
  519016
  519092
  519560
  520448
  520485
  520596
  520688
  521236
  522284
  522688
  523522
  523535
  523537
  523539
  525275
  527038
  528938
  531146
  532419
  536684
  555510
  561135
  567677
  568062
  570067
  570068
  575324
  575832
  578563
  580116
  581852
  585332
  591612
  603663
  604555
  606794
  608206
  611477
  615826
  617234
  620298
  621277
  625215
  626576
  636209
  669409
  671403
  677060
  677097
  682107
  684694
  718747
  720257
  720885
  808865
]
20.93 ms
(9.49%)
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
  518174
  519092
  484230
  483551
  511581
  520596
  523539
  570068
  467721
  520448
  568062
  608206
  611477
  425523
  419880
  395394
  413050
  472496
  458789
  483401
  500463
  531146
  502305
  511897
  520485
  567677
  580116
  555510
  575832
  682107
  720257
  669409
  677097
  718747
  720885
  575324
  606794
  620298
  585332
  626576
  808865
  447717
  474167
  416773
  464528
  449724
  470324
  470391
  470449
  471945
  456553
  515850
  517059
  513476
  528938
  484127
  484223
  486020
  513732
  515334
  517063
  522284
  488822
  503129
  505818
  442673
  417064
  471443
  477362
  450817
  471515
  521236
  536684
  581852
  561135
  677060
  684694
  603663
  617234
  428895
  476360
  424498
  525275
  483594
  496757
  507767
  509312
  527038
  517190
  523535
  492108
  506816
  523522
  671403
  625215
  498043
  441398
  488405
  446735
  519016
  532419
  570067
  578563
  615826
  636209
  423893
  431422
  515749
  483239
  519560
  499028
  522688
  482824
  621277
  421155
  520688
  523537
  591612
  604555
  439673
]
3.17 ms
(1.43%)
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
  395394
  413050
  416773
  417064
  419880
  421155
  423893
  424498
  425523
  428895
  431422
  439673
  441398
  442673
  446735
  447717
  449724
  450817
  456553
  458789
  464528
  467721
  470324
  470391
  470449
  471443
  471515
  471945
  472496
  474167
  476360
  477362
  482824
  483239
  483401
  483551
  483594
  484127
  484223
  484230
  486020
  488405
  488822
  492108
  496757
  498043
  499028
  500463
  502305
  503129
  505818
  506816
  507767
  509312
  511581
  511897
  513732
  515334
  515749
  515850
  517059
  517063
  517190
  518174
  519016
  519092
  519560
  520448
  520485
  520596
  520688
  521236
  522284
  522688
  523522
  523535
  523537
  523539
  525275
  527038
  528938
  531146
  532419
  536684
  555510
  561135
  567677
  568062
  570067
  570068
  575324
  575832
  578563
  580116
  581852
  585332
  591612
  603663
  604555
  606794
  608206
  611477
  615826
  617234
  620298
  621277
  625215
  626576
  636209
  669409
  671403
  677060
  677097
  682107
  684694
  718747
  720257
  720885
  808865
]
2.01 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful friend"
]
1.90 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "красивая friend"
]
1.45 ms
(0.66%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая friend"
]

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.