GET https://search.jues.net/search/embeds/4?q=beauty%20ass

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
223.68 ms
(87.86%)
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
  4199
  8164
  380962
  382097
  383307
  383434
  390839
  390914
  392787
  395653
  395662
  396534
  400663
  401909
  402047
  403136
  403678
  405125
  406847
  417206
  424191
  425411
  426657
  428685
  432189
  432190
  435518
  435520
  437582
  442271
  442296
  444471
  448707
  454057
  454083
  454734
  459251
  460976
  465700
  466457
  467924
  468999
  470538
  471377
  471607
  472180
  472214
  472804
  476814
  479359
  481659
  482623
  482692
  483259
  484701
  484969
  487984
  488887
  489842
  490166
  490389
  490813
  494738
  495376
  500794
  509821
  512960
  513063
  514607
  514978
  515418
  515662
  518371
  518443
  520412
  520925
  521024
  521473
  522127
  524488
  524653
  524654
  529137
  529643
  529674
  529770
  529830
  529899
  530892
  532094
  532723
  532980
  534011
  535462
  539825
  540370
  541413
  542926
  543209
  551070
  556818
  565337
  578253
  587536
  621350
  636080
  673987
  674756
  675208
  682993
  683066
  683565
  689293
  693643
  695179
  696140
  738051
  759074
  784790
  811001
]
18.50 ms
(7.27%)
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
  467924
  435518
  471377
  401909
  417206
  454083
  465700
  472180
  476814
  521024
  693643
  403136
  534011
  466457
  470538
  542926
  442271
  380962
  4199
  390839
  403678
  390914
  444471
  460976
  529770
  683565
  811001
  448707
  471607
  490813
  406847
  432189
  482623
  529643
  543209
  565337
  541413
  674756
  689293
  673987
  675208
  683066
  696140
  551070
  587536
  759074
  621350
  481659
  402047
  395653
  392787
  442296
  520925
  518443
  522127
  490166
  494738
  515662
  520412
  454734
  515418
  532723
  695179
  556818
  432190
  395662
  425411
  426657
  428685
  468999
  396534
  454057
  437582
  472214
  424191
  472804
  509821
  521473
  487984
  495376
  483259
  500794
  512960
  514978
  529137
  535462
  482692
  682993
  636080
  784790
  382097
  400663
  8164
  405125
  435520
  578253
  738051
  383307
  383434
  524653
  489842
  459251
  484701
  488887
  479359
  484969
  490389
  514607
  524654
  529674
  529899
  539825
  540370
  513063
  532980
  518371
  524488
  532094
  529830
  530892
]
3.85 ms
(1.51%)
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
  4199
  8164
  380962
  382097
  383307
  383434
  390839
  390914
  392787
  395653
  395662
  396534
  400663
  401909
  402047
  403136
  403678
  405125
  406847
  417206
  424191
  425411
  426657
  428685
  432189
  432190
  435518
  435520
  437582
  442271
  442296
  444471
  448707
  454057
  454083
  454734
  459251
  460976
  465700
  466457
  467924
  468999
  470538
  471377
  471607
  472180
  472214
  472804
  476814
  479359
  481659
  482623
  482692
  483259
  484701
  484969
  487984
  488887
  489842
  490166
  490389
  490813
  494738
  495376
  500794
  509821
  512960
  513063
  514607
  514978
  515418
  515662
  518371
  518443
  520412
  520925
  521024
  521473
  522127
  524488
  524653
  524654
  529137
  529643
  529674
  529770
  529830
  529899
  530892
  532094
  532723
  532980
  534011
  535462
  539825
  540370
  541413
  542926
  543209
  551070
  556818
  565337
  578253
  587536
  621350
  636080
  673987
  674756
  675208
  682993
  683066
  683565
  689293
  693643
  695179
  696140
  738051
  759074
  784790
  811001
]
2.52 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.31 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "beauty жоп"
]
1.90 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "beauty жоп"
]
1.82 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beauty ass"
]

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.