GET https://search.jues.net/search/embeds/4?q=anal%20hairy%20brunette

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.81 ms
(84.07%)
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
  142832
  382278
  385344
  385688
  385706
  385710
  388411
  389570
  390388
  391113
  391372
  391984
  393572
  395730
  395862
  396013
  396695
  396707
  397740
  403979
  404422
  404695
  404777
  404940
  405028
  405105
  411684
  411700
  417830
  419296
  421732
  422649
  429902
  430796
  432034
  434360
  436937
  439623
  443819
  445340
  446637
  446855
  447740
  448176
  448375
  451259
  453162
  468469
  469601
  470565
  473773
  474282
  474810
  475473
  476183
  476351
  480380
  481719
  485457
  490856
  500289
  501295
  502089
  505804
  512557
  517007
  519226
  520733
  524550
  524955
  526504
  533932
  537844
  538270
  540187
  541334
  545328
  566033
  566863
  567396
  571441
  576703
  586628
  588231
  590695
  590948
  600492
  603239
  605344
  606816
  614026
  619445
  619832
  622056
  629560
  643007
  644922
  670773
  693502
  694563
  695249
  698537
  700975
  714346
  722392
  727742
  727744
  731303
  756406
  789516
  789844
  802357
  807557
  809421
  812229
  813357
  814893
  818442
  819238
  823368
]
17.98 ms
(10.16%)
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
  475473
  405028
  480380
  586628
  396695
  411684
  445340
  644922
  446855
  447740
  533932
  501295
  485457
  545328
  566863
  619832
  629560
  605344
  802357
  809421
  727744
  731303
  391113
  429902
  474282
  395730
  476351
  512557
  404422
  395862
  590695
  385706
  385710
  389570
  819238
  814893
  823368
  818442
  468469
  476183
  524955
  540187
  517007
  567396
  670773
  694563
  695249
  698537
  619445
  643007
  600492
  614026
  812229
  813357
  727742
  789516
  789844
  388411
  490856
  434360
  432034
  519226
  443819
  451259
  538270
  390388
  396707
  396013
  405105
  446637
  566033
  606816
  722392
  385344
  448375
  417830
  520733
  500289
  385688
  393572
  404777
  421732
  430796
  436937
  470565
  474810
  502089
  505804
  526504
  537844
  524550
  571441
  700975
  693502
  576703
  590948
  588231
  603239
  391984
  404940
  419296
  411700
  403979
  404695
  142832
  453162
  541334
  714346
  382278
  397740
  469601
  439623
  391372
  422649
  448176
  473773
  622056
  807557
  756406
  481719
]
2.67 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
  142832
  382278
  385344
  385688
  385706
  385710
  388411
  389570
  390388
  391113
  391372
  391984
  393572
  395730
  395862
  396013
  396695
  396707
  397740
  403979
  404422
  404695
  404777
  404940
  405028
  405105
  411684
  411700
  417830
  419296
  421732
  422649
  429902
  430796
  432034
  434360
  436937
  439623
  443819
  445340
  446637
  446855
  447740
  448176
  448375
  451259
  453162
  468469
  469601
  470565
  473773
  474282
  474810
  475473
  476183
  476351
  480380
  481719
  485457
  490856
  500289
  501295
  502089
  505804
  512557
  517007
  519226
  520733
  524550
  524955
  526504
  533932
  537844
  538270
  540187
  541334
  545328
  566033
  566863
  567396
  571441
  576703
  586628
  588231
  590695
  590948
  600492
  603239
  605344
  606816
  614026
  619445
  619832
  622056
  629560
  643007
  644922
  670773
  693502
  694563
  695249
  698537
  700975
  714346
  722392
  727742
  727744
  731303
  756406
  789516
  789844
  802357
  807557
  809421
  812229
  813357
  814893
  818442
  819238
  823368
]
2.21 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal hairy brunette"
]
1.88 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал волосатая черноволосая"
]
1.84 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал волосатая черноволосая"
]
1.60 ms
(0.91%)
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.