GET https://search.jues.net/search/embeds/6?q=vagina%20creampie

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
205.17 ms
(53.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "vagina creampie"
]
152.38 ms
(39.92%)
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
  338338
  395947
  400620
  403421
  414730
  415092
  417113
  417130
  417788
  420405
  422415
  423602
  447733
  449800
  450190
  450597
  452275
  453958
  458604
  493885
  496460
  509971
  536145
  541559
  542256
  555763
  559311
  559423
  561860
  562819
  563684
  572360
  572770
  578756
  587582
  591186
  591766
  591818
  603611
  610123
  613688
  616429
  616475
  616595
  617682
  619684
  620378
  622562
  626443
  626599
  635004
  645667
  653070
  664224
  666684
  687147
  689040
  693425
  700689
  707236
  707753
  714392
  719924
  720067
  720579
  722109
  722329
  725065
  726725
  734661
  738743
  738911
  739879
  740905
  746039
  747967
  750680
  751524
  755119
  757914
  759697
  761354
  761904
  769008
  769201
  770506
  770774
  773639
  773691
  774540
  775484
  776363
  777557
  778604
  778938
  781077
  781132
  781154
  781522
  782573
  785079
  787263
  787433
  790041
  791046
  791530
  791684
  791835
  793521
  794511
  794931
  795011
  795107
  795826
  795916
  797718
  801343
  804463
  807721
]
15.05 ms
(3.94%)
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
  739879
  747967
  751524
  759697
  769008
  770506
  620378
  714392
  719924
  722329
  776363
  777557
  778938
  781077
  781154
  782573
  787433
  790041
  791046
  791835
  807721
  417130
  559311
  555763
  610123
  616475
  591766
  591818
  757914
  422415
  572360
  617682
  338338
  496460
  563684
  572770
  562819
  622562
  591186
  616429
  587582
  626599
  613688
  400620
  414730
  415092
  420405
  423602
  447733
  449800
  450190
  452275
  458604
  536145
  541559
  542256
  559423
  664224
  693425
  689040
  707236
  722109
  645667
  653070
  666684
  687147
  707753
  720067
  720579
  561860
  578756
  619684
  626443
  603611
  635004
  774540
  775484
  778604
  781132
  791530
  794511
  794931
  795107
  795826
  804463
  725065
  726725
  734661
  750680
  755119
  770774
  773639
  785079
  787263
  791684
  738911
  760972
  761904
  773691
  738743
  769201
  740905
  746039
  761354
  616595
  700689
  781522
  793521
  795011
  795916
  797718
  801343
  395947
  493885
  403421
  417113
  417788
  453958
  450597
  509971
]
2.82 ms
(0.74%)
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
  338338
  395947
  400620
  403421
  414730
  415092
  417113
  417130
  417788
  420405
  422415
  423602
  447733
  449800
  450190
  450597
  452275
  453958
  458604
  493885
  496460
  509971
  536145
  541559
  542256
  555763
  559311
  559423
  561860
  562819
  563684
  572360
  572770
  578756
  587582
  591186
  591766
  591818
  603611
  610123
  613688
  616429
  616475
  616595
  617682
  619684
  620378
  622562
  626443
  626599
  635004
  645667
  653070
  664224
  666684
  687147
  689040
  693425
  700689
  707236
  707753
  714392
  719924
  720067
  720579
  722109
  722329
  725065
  726725
  734661
  738743
  738911
  739879
  740905
  746039
  747967
  750680
  751524
  755119
  757914
  759697
  761354
  761904
  769008
  769201
  770506
  770774
  773639
  773691
  774540
  775484
  776363
  777557
  778604
  778938
  781077
  781132
  781154
  781522
  782573
  785079
  787263
  787433
  790041
  791046
  791530
  791684
  791835
  793521
  794511
  794931
  795011
  795107
  795826
  795916
  797718
  801343
  804463
  807721
]
2.40 ms
(0.63%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вагин creampie"
]
2.18 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вагин creampie"
]
1.73 ms
(0.45%)
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.