GET https://search.jues.net/search/embeds/7?q=blonde%20wife

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.52 ms
(83.99%)
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
  192814
  253445
  345303
  366036
  382692
  384480
  386611
  389858
  390624
  393016
  396396
  397026
  398421
  398564
  398747
  400684
  404404
  409077
  415736
  424192
  450950
  453921
  454506
  455197
  459105
  460586
  466104
  478350
  512030
  513816
  514875
  519899
  525182
  526136
  527347
  531632
  533190
  534355
  535082
  536753
  538044
  553263
  553831
  558309
  561181
  567500
  575897
  581482
  584342
  591277
  591496
  591971
  595540
  605923
  613593
  625462
  627738
  634275
  637481
  639912
  648422
  652300
  656514
  659210
  660061
  660336
  662839
  663237
  665451
  666832
  667179
  667757
  668100
  671497
  673209
  675203
  676759
  677136
  677557
  695547
  697458
  701047
  701581
  710224
  717660
  717955
  718071
  720356
  726038
  726338
  726899
  728253
  728832
  730645
  730780
  733061
  734097
  734212
  735448
  739207
  753565
  753613
  753620
  754660
  754852
  756461
  763042
  763879
  764395
  766179
  768570
  778667
  780882
  792679
  793764
  794475
  797476
  804779
  814717
  827878
]
15.08 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
  804779
  726338
  730645
  734097
  734212
  753565
  756461
  726899
  730780
  735448
  739207
  763042
  753620
  754660
  754852
  766179
  768570
  728832
  753613
  763879
  764395
  717660
  778667
  780882
  792679
  793764
  797476
  366036
  398421
  396396
  398747
  345303
  384480
  386611
  253445
  794475
  733061
  398564
  409077
  814717
  535082
  558309
  634275
  726038
  728253
  192814
  666832
  665451
  455197
  400684
  450950
  459105
  453921
  460586
  531632
  513816
  667757
  591277
  389858
  390624
  466104
  512030
  527347
  393016
  382692
  397026
  404404
  424192
  415736
  827878
  454506
  525182
  526136
  519899
  536753
  533190
  534355
  538044
  514875
  478350
  553263
  561181
  575897
  581482
  553831
  567500
  659210
  660061
  660336
  662839
  663237
  675203
  676759
  677136
  677557
  717955
  673209
  695547
  701581
  720356
  648422
  652300
  656514
  667179
  668100
  671497
  697458
  701047
  710224
  718071
  584342
  605923
  625462
  637481
  591496
  591971
  639912
  613593
  627738
  595540
]
2.88 ms
(1.81%)
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
  192814
  253445
  345303
  366036
  382692
  384480
  386611
  389858
  390624
  393016
  396396
  397026
  398421
  398564
  398747
  400684
  404404
  409077
  415736
  424192
  450950
  453921
  454506
  455197
  459105
  460586
  466104
  478350
  512030
  513816
  514875
  519899
  525182
  526136
  527347
  531632
  533190
  534355
  535082
  536753
  538044
  553263
  553831
  558309
  561181
  567500
  575897
  581482
  584342
  591277
  591496
  591971
  595540
  605923
  613593
  625462
  627738
  634275
  637481
  639912
  648422
  652300
  656514
  659210
  660061
  660336
  662839
  663237
  665451
  666832
  667179
  667757
  668100
  671497
  673209
  675203
  676759
  677136
  677557
  695547
  697458
  701047
  701581
  710224
  717660
  717955
  718071
  720356
  726038
  726338
  726899
  728253
  728832
  730645
  730780
  733061
  734097
  734212
  735448
  739207
  753565
  753613
  753620
  754660
  754852
  756461
  763042
  763879
  764395
  766179
  768570
  778667
  780882
  792679
  793764
  794475
  797476
  804779
  814717
  827878
]
2.14 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blonde wife"
]
2.02 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беловолосая жен"
]
1.58 ms
(1.00%)
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.