GET https://search.jues.net/search/embeds/4?q=wife%20stockings

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
200.42 ms
(89.43%)
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
  45868
  75626
  85303
  148408
  338809
  382731
  385285
  387080
  395949
  399965
  407421
  423772
  423956
  426647
  432458
  432477
  432486
  432507
  432509
  433596
  437587
  458662
  466560
  473059
  475374
  476799
  478570
  479379
  480332
  482068
  485065
  485869
  485878
  492905
  495129
  505135
  506379
  508407
  514001
  515053
  515614
  515621
  515736
  519796
  528529
  534974
  541823
  553685
  555640
  560234
  563330
  575552
  576131
  576833
  588600
  588887
  589601
  590148
  595358
  600824
  601487
  602811
  606663
  607583
  608253
  608787
  610697
  614857
  622892
  631481
  641043
  657788
  660054
  663780
  675871
  677861
  679204
  686323
  686391
  695801
  696376
  696774
  711749
  712094
  715065
  716201
  724483
  726166
  734343
  740175
  740875
  743891
  754537
  759362
  761517
  765411
  773924
  780788
  781251
  781857
  781875
  785916
  786776
  789100
  790462
  791314
  792701
  797275
  800474
  800799
  806476
  813104
  814154
  823171
  823706
  828446
  828660
  828769
  828789
  828804
]
13.75 ms
(6.13%)
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
  715065
  781251
  806476
  560234
  576833
  590148
  423772
  602811
  614857
  631481
  433596
  466560
  608253
  519796
  712094
  686391
  75626
  423956
  657788
  563330
  479379
  338809
  407421
  555640
  740875
  148408
  475374
  515614
  399965
  695801
  485065
  492905
  528529
  553685
  716201
  677861
  679204
  696376
  696774
  601487
  595358
  785916
  813104
  780788
  786776
  800474
  743891
  781875
  724483
  726166
  761517
  773924
  781857
  800799
  432486
  432507
  485878
  506379
  828446
  610697
  828789
  828804
  828660
  607583
  606663
  395949
  85303
  663780
  675871
  686323
  576131
  600824
  641043
  790462
  791314
  734343
  792701
  797275
  759362
  740175
  754537
  765411
  711749
  382731
  482068
  814154
  828769
  823171
  823706
  622892
  789100
  660054
  514001
  515053
  588887
  437587
  505135
  485869
  541823
  588600
  432458
  432477
  458662
  426647
  476799
  515621
  515736
  387080
  385285
  534974
  480332
  432509
  473059
  608787
  575552
  45868
  495129
  478570
  589601
  508407
]
2.91 ms
(1.30%)
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
  45868
  75626
  85303
  148408
  338809
  382731
  385285
  387080
  395949
  399965
  407421
  423772
  423956
  426647
  432458
  432477
  432486
  432507
  432509
  433596
  437587
  458662
  466560
  473059
  475374
  476799
  478570
  479379
  480332
  482068
  485065
  485869
  485878
  492905
  495129
  505135
  506379
  508407
  514001
  515053
  515614
  515621
  515736
  519796
  528529
  534974
  541823
  553685
  555640
  560234
  563330
  575552
  576131
  576833
  588600
  588887
  589601
  590148
  595358
  600824
  601487
  602811
  606663
  607583
  608253
  608787
  610697
  614857
  622892
  631481
  641043
  657788
  660054
  663780
  675871
  677861
  679204
  686323
  686391
  695801
  696376
  696774
  711749
  712094
  715065
  716201
  724483
  726166
  734343
  740175
  740875
  743891
  754537
  759362
  761517
  765411
  773924
  780788
  781251
  781857
  781875
  785916
  786776
  789100
  790462
  791314
  792701
  797275
  800474
  800799
  806476
  813104
  814154
  823171
  823706
  828446
  828660
  828769
  828789
  828804
]
2.15 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife stockings"
]
1.75 ms
(0.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен чулк нижн бел"
]
1.64 ms
(0.73%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.67%)
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.