GET https://search.jues.net/search/embeds/2?q=girls%20fisting

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
168.85 ms
(87.84%)
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
  346014
  365056
  382578
  383947
  385234
  389611
  391940
  397656
  409560
  410685
  440094
  447154
  467197
  480457
  490649
  495736
  495750
  495765
  496150
  497519
  505382
  505649
  506371
  507243
  508177
  510731
  510822
  514848
  514852
  514863
  514867
  520767
  523250
  525351
  529128
  530295
  531849
  531876
  534554
  535261
  536124
  536177
  537256
  540593
  540685
  540915
  541064
  542705
  545224
  547852
  550806
  550816
  555797
  565575
  569592
  574090
  579394
  579517
  580109
  580190
  583689
  584164
  588854
  590222
  599477
  600304
  600508
  609198
  618257
  627162
  627466
  628708
  629725
  630457
  638998
  639371
  645673
  648679
  653520
  656919
  656936
  658788
  661973
  662194
  663216
  666888
  669030
  669034
  670364
  672937
  696595
  705028
  717543
  734839
  735345
  735743
  740624
  749204
  750123
  752595
  752611
  770219
  770274
  778395
  782791
  786872
  788735
  789426
  792691
  792708
  792727
  792739
  796768
  796840
  796857
  796878
  799699
  809351
  810820
  812559
]
13.10 ms
(6.81%)
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
  799699
  735743
  749204
  505382
  514863
  490649
  510731
  505649
  508177
  514848
  628708
  599477
  440094
  735345
  529128
  496150
  670364
  590222
  630457
  523250
  346014
  536177
  580109
  705028
  645673
  618257
  629725
  792691
  796857
  810820
  752611
  792727
  661973
  812559
  531849
  541064
  696595
  796878
  740624
  385234
  536124
  550806
  480457
  542705
  497519
  565575
  656936
  648679
  627162
  786872
  750123
  495765
  525351
  540915
  382578
  514852
  495750
  569592
  609198
  627466
  391940
  389611
  537256
  531876
  534554
  574090
  666888
  658788
  796768
  792739
  662194
  383947
  365056
  410685
  495736
  510822
  663216
  540593
  669034
  672937
  600508
  638998
  639371
  792708
  734839
  809351
  409560
  530295
  506371
  540685
  656919
  547852
  600304
  796840
  447154
  579517
  550816
  507243
  535261
  583689
  669030
  653520
  579394
  555797
  467197
  545224
  584164
  717543
  588854
  778395
  752595
  770274
  789426
  770219
  782791
  788735
  520767
  580190
  514867
  397656
]
3.36 ms
(1.75%)
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
  346014
  365056
  382578
  383947
  385234
  389611
  391940
  397656
  409560
  410685
  440094
  447154
  467197
  480457
  490649
  495736
  495750
  495765
  496150
  497519
  505382
  505649
  506371
  507243
  508177
  510731
  510822
  514848
  514852
  514863
  514867
  520767
  523250
  525351
  529128
  530295
  531849
  531876
  534554
  535261
  536124
  536177
  537256
  540593
  540685
  540915
  541064
  542705
  545224
  547852
  550806
  550816
  555797
  565575
  569592
  574090
  579394
  579517
  580109
  580190
  583689
  584164
  588854
  590222
  599477
  600304
  600508
  609198
  618257
  627162
  627466
  628708
  629725
  630457
  638998
  639371
  645673
  648679
  653520
  656919
  656936
  658788
  661973
  662194
  663216
  666888
  669030
  669034
  670364
  672937
  696595
  705028
  717543
  734839
  735345
  735743
  740624
  749204
  750123
  752595
  752611
  770219
  770274
  778395
  782791
  786872
  788735
  789426
  792691
  792708
  792727
  792739
  796768
  796840
  796857
  796878
  799699
  809351
  810820
  812559
]
1.96 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girls fisting"
]
1.74 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк фистинг"
]
1.60 ms
(0.83%)
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.