GET https://search.jues.net/search/embeds/7?q=husband%20girl

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
175.71 ms
(88.36%)
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
  80505
  384104
  397371
  534944
  535082
  535189
  539983
  543274
  545210
  552875
  555640
  559237
  583314
  585343
  585769
  586346
  586562
  589923
  590653
  591516
  594579
  600871
  603449
  603617
  604585
  605701
  606497
  606887
  608177
  610711
  611443
  613998
  619292
  622086
  626903
  627253
  631986
  634298
  637521
  638396
  641473
  641870
  642288
  646012
  650978
  651268
  656915
  659479
  660649
  663270
  664705
  665983
  666563
  666733
  674550
  677553
  682291
  684430
  687832
  689038
  689214
  693776
  696365
  697597
  699556
  700858
  702056
  705398
  706555
  707145
  709878
  710398
  712226
  720311
  724583
  727724
  730158
  735252
  736861
  737720
  740058
  740663
  745317
  749465
  749623
  749756
  751845
  759580
  761509
  766300
  766890
  767197
  768190
  770417
  776933
  780731
  786403
  787117
  788094
  790086
  790654
  793664
  793792
  793869
  794676
  795606
  795795
  795895
  796464
  796811
  800901
  801760
  805103
  809347
  811877
  813698
  817981
  825201
  825255
  825715
]
12.90 ms
(6.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
  646012
  660649
  666563
  693776
  666733
  684430
  699556
  702056
  706555
  707145
  656915
  555640
  594579
  610711
  638396
  586562
  589923
  604585
  631986
  641473
  793792
  796464
  793869
  749623
  767197
  766890
  735252
  749756
  766300
  613998
  637521
  700858
  384104
  397371
  80505
  825715
  825255
  813698
  817981
  825201
  535189
  539983
  534944
  535082
  543274
  559237
  545210
  651268
  659479
  663270
  665983
  677553
  696365
  697597
  650978
  682291
  687832
  689038
  705398
  709878
  710398
  712226
  720311
  664705
  674550
  689214
  552875
  583314
  585769
  622086
  626903
  641870
  591516
  603449
  634298
  586346
  600871
  603617
  619292
  642288
  585343
  590653
  605701
  606497
  606887
  608177
  611443
  627253
  776933
  780731
  786403
  788094
  790086
  790654
  794676
  795606
  795795
  809347
  811877
  787117
  800901
  805103
  730158
  737720
  740058
  749465
  759580
  793664
  795895
  796811
  801760
  724583
  727724
  740663
  745317
  761509
  770417
  736861
  751845
  768190
]
3.32 ms
(1.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
  80505
  384104
  397371
  534944
  535082
  535189
  539983
  543274
  545210
  552875
  555640
  559237
  583314
  585343
  585769
  586346
  586562
  589923
  590653
  591516
  594579
  600871
  603449
  603617
  604585
  605701
  606497
  606887
  608177
  610711
  611443
  613998
  619292
  622086
  626903
  627253
  631986
  634298
  637521
  638396
  641473
  641870
  642288
  646012
  650978
  651268
  656915
  659479
  660649
  663270
  664705
  665983
  666563
  666733
  674550
  677553
  682291
  684430
  687832
  689038
  689214
  693776
  696365
  697597
  699556
  700858
  702056
  705398
  706555
  707145
  709878
  710398
  712226
  720311
  724583
  727724
  730158
  735252
  736861
  737720
  740058
  740663
  745317
  749465
  749623
  749756
  751845
  759580
  761509
  766300
  766890
  767197
  768190
  770417
  776933
  780731
  786403
  787117
  788094
  790086
  790654
  793664
  793792
  793869
  794676
  795606
  795795
  795895
  796464
  796811
  800901
  801760
  805103
  809347
  811877
  813698
  817981
  825201
  825255
  825715
]
2.29 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "husband girl"
]
1.63 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "husband девушк"
]
1.60 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.41 ms
(0.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "husband девушк"
]

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.