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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.74 ms
(83.55%)
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
  7615
  54378
  74588
  88246
  103649
  197941
  233364
  308886
  381432
  382043
  382472
  382807
  386558
  386761
  387221
  388274
  389596
  390355
  391683
  392452
  395263
  395456
  396099
  396864
  397648
  398568
  400424
  401103
  401139
  401562
  401590
  402859
  403151
  405125
  405551
  408998
  409076
  409134
  415896
  417616
  417770
  421006
  421030
  431139
  446351
  447816
  460824
  464872
  466339
  468225
  469733
  470852
  471338
  474657
  489478
  492027
  492147
  494305
  499979
  504444
  524480
  526361
  526510
  535609
  547205
  566031
  570436
  571264
  576111
  589508
  593111
  596184
  596438
  599979
  603972
  605930
  618887
  630567
  635932
  640816
  645829
  662794
  669295
  670399
  690480
  693523
  693541
  698910
  699514
  701131
  702636
  704232
  706541
  708974
  719274
  734681
  742234
  744139
  746148
  750565
  752587
  753024
  753595
  754405
  758924
  758982
  765285
  770712
  778264
  780408
  782127
  783093
  786024
  786795
  794001
  800663
  801179
  803482
  805939
  813776
]
13.21 ms
(9.14%)
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
  7615
  387221
  469733
  103649
  395263
  381432
  405551
  504444
  690480
  605930
  794001
  389596
  401562
  88246
  74588
  401103
  233364
  388274
  400424
  599979
  470852
  526361
  813776
  499979
  571264
  698910
  704232
  752587
  783093
  750565
  765285
  702636
  778264
  308886
  390355
  447816
  417770
  396864
  405125
  398568
  401139
  464872
  431139
  468225
  526510
  489478
  382043
  693523
  596184
  734681
  786795
  753595
  753024
  742234
  782127
  391683
  382472
  402859
  409076
  417616
  446351
  570436
  669295
  576111
  635932
  630567
  701131
  392452
  401590
  471338
  395456
  386761
  397648
  403151
  54378
  566031
  618887
  408998
  460824
  466339
  421006
  415896
  421030
  492027
  409134
  535609
  693541
  708974
  719274
  662794
  670399
  645829
  547205
  589508
  603972
  640816
  780408
  786024
  801179
  805939
  754405
  758924
  758982
  744139
  746148
  770712
  699514
  800663
  803482
  197941
  386558
  382807
  396099
  492147
  494305
  524480
  474657
  706541
  593111
  596438
]
3.49 ms
(2.42%)
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
  7615
  54378
  74588
  88246
  103649
  197941
  233364
  308886
  381432
  382043
  382472
  382807
  386558
  386761
  387221
  388274
  389596
  390355
  391683
  392452
  395263
  395456
  396099
  396864
  397648
  398568
  400424
  401103
  401139
  401562
  401590
  402859
  403151
  405125
  405551
  408998
  409076
  409134
  415896
  417616
  417770
  421006
  421030
  431139
  446351
  447816
  460824
  464872
  466339
  468225
  469733
  470852
  471338
  474657
  489478
  492027
  492147
  494305
  499979
  504444
  524480
  526361
  526510
  535609
  547205
  566031
  570436
  571264
  576111
  589508
  593111
  596184
  596438
  599979
  603972
  605930
  618887
  630567
  635932
  640816
  645829
  662794
  669295
  670399
  690480
  693523
  693541
  698910
  699514
  701131
  702636
  704232
  706541
  708974
  719274
  734681
  742234
  744139
  746148
  750565
  752587
  753024
  753595
  754405
  758924
  758982
  765285
  770712
  778264
  780408
  782127
  783093
  786024
  786795
  794001
  800663
  801179
  803482
  805939
  813776
]
2.15 ms
(1.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blonde beautiful"
]
1.75 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "беловолосая красивая"
]
1.67 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беловолосая красивая"
]
1.50 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.