GET https://search.jues.net/search/embeds/9?q=stockings%20interracial

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
195.40 ms
(88.48%)
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
  73425
  79355
  154410
  191323
  382188
  388411
  391113
  395669
  396538
  396704
  401316
  404459
  405056
  405535
  406390
  413788
  414361
  415155
  416063
  421200
  422063
  422666
  424927
  428116
  429950
  429999
  430762
  433835
  437511
  438235
  443090
  445726
  448869
  449933
  452311
  454785
  464651
  467592
  467615
  472393
  472488
  475479
  477072
  477470
  481144
  488904
  494359
  503838
  509805
  510161
  513850
  518438
  521469
  522147
  528580
  530384
  530503
  532241
  537686
  538815
  540504
  560941
  574908
  583701
  585377
  585952
  591347
  591513
  595722
  595728
  600061
  600401
  600495
  601600
  601707
  602008
  603180
  604457
  604527
  606366
  606496
  606780
  606873
  612073
  612182
  613825
  614022
  614305
  616071
  617421
  620857
  624871
  632618
  638997
  642835
  644679
  675012
  678128
  680206
  715533
  725633
  732799
  742579
  744602
  744632
  772681
  772815
  773998
  774227
  775787
  775974
  790390
  792636
  795485
  805438
  807641
  807692
  807789
  809525
  813014
]
15.65 ms
(7.09%)
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
  595728
  604457
  616071
  624871
  644679
  591513
  595722
  606496
  612073
  614022
  614305
  620857
  638997
  585952
  591347
  603180
  604527
  606366
  606780
  606873
  612182
  642835
  775787
  809525
  805438
  725633
  732799
  772681
  772815
  773998
  790390
  807641
  807692
  807789
  744632
  774227
  742579
  744602
  613825
  715533
  775974
  792636
  795485
  813014
  79355
  382188
  191323
  388411
  395669
  430762
  396704
  413788
  415155
  454785
  472393
  414361
  494359
  73425
  401316
  406390
  416063
  429950
  445726
  391113
  422666
  396538
  448869
  510161
  405056
  600495
  422063
  438235
  154410
  433835
  449933
  477072
  503838
  509805
  467592
  477470
  680206
  560941
  602008
  600061
  600401
  585377
  601707
  481144
  472488
  475479
  521469
  528580
  429999
  583701
  518438
  675012
  530384
  678128
  601600
  632618
  404459
  421200
  464651
  574908
  467615
  405535
  424927
  617421
  522147
  537686
  538815
  488904
  428116
  443090
  437511
  452311
  530503
  513850
  532241
  540504
]
3.07 ms
(1.39%)
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
  73425
  79355
  154410
  191323
  382188
  388411
  391113
  395669
  396538
  396704
  401316
  404459
  405056
  405535
  406390
  413788
  414361
  415155
  416063
  421200
  422063
  422666
  424927
  428116
  429950
  429999
  430762
  433835
  437511
  438235
  443090
  445726
  448869
  449933
  452311
  454785
  464651
  467592
  467615
  472393
  472488
  475479
  477072
  477470
  481144
  488904
  494359
  503838
  509805
  510161
  513850
  518438
  521469
  522147
  528580
  530384
  530503
  532241
  537686
  538815
  540504
  560941
  574908
  583701
  585377
  585952
  591347
  591513
  595722
  595728
  600061
  600401
  600495
  601600
  601707
  602008
  603180
  604457
  604527
  606366
  606496
  606780
  606873
  612073
  612182
  613825
  614022
  614305
  616071
  617421
  620857
  624871
  632618
  638997
  642835
  644679
  675012
  678128
  680206
  715533
  725633
  732799
  742579
  744602
  744632
  772681
  772815
  773998
  774227
  775787
  775974
  790390
  792636
  795485
  805438
  807641
  807692
  807789
  809525
  813014
]
1.82 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "stockings interracial"
]
1.68 ms
(0.76%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "чулк нижн бел межрасов"
]
1.61 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "чулк нижн бел межрасов"
]
1.60 ms
(0.72%)
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.