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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.44 ms
(84.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
  396303
  398499
  413687
  418117
  418146
  418622
  434328
  434345
  434376
  439244
  441396
  442527
  450162
  459213
  466510
  467885
  468658
  469794
  473607
  494546
  496345
  498795
  500875
  500945
  505805
  506510
  507713
  513562
  515874
  528407
  537651
  542181
  544401
  547580
  547795
  555821
  559368
  564757
  565547
  574319
  577608
  579863
  582571
  583807
  587442
  587899
  595339
  618750
  622065
  624839
  639326
  655517
  659343
  665641
  669877
  669936
  677839
  678834
  678842
  680614
  681486
  705005
  708232
  720576
  721083
  732795
  738518
  739810
  740894
  744457
  744782
  750626
  755554
  756491
  757730
  767753
  768946
  769338
  772602
  773254
  773868
  779610
  783921
  784048
  784097
  784138
  784965
  785075
  785197
  785320
  786906
  791492
  791857
  791926
  793201
  794462
  795818
  795832
  797036
  797075
  800054
  801534
  801795
  801811
  801842
  803040
  803568
  804064
  807578
  808321
  808629
  808659
  808962
  809428
  811057
  814419
  820308
  825685
  826143
  826973
]
14.47 ms
(9.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
  768946
  595339
  659343
  418622
  418146
  441396
  559368
  469794
  496345
  505805
  515874
  507713
  655517
  681486
  564757
  565547
  624839
  785197
  797036
  801811
  803040
  784965
  808962
  773254
  783921
  791857
  795832
  807578
  808321
  808659
  618750
  791492
  801795
  804064
  808629
  418117
  434328
  459213
  467885
  547580
  665641
  678842
  677839
  720576
  784138
  772602
  803568
  500945
  450162
  826143
  820308
  826973
  825685
  721083
  680614
  574319
  794462
  795818
  797075
  784097
  744457
  785075
  785320
  767753
  769338
  773868
  740894
  744782
  732795
  739810
  757730
  793201
  801842
  398499
  814419
  542181
  678834
  582571
  622065
  800054
  801534
  750626
  784048
  494546
  528407
  500875
  579863
  547795
  583807
  587899
  439244
  498795
  555821
  434376
  537651
  396303
  442527
  413687
  434345
  468658
  473607
  466510
  513562
  506510
  544401
  577608
  669877
  669936
  705005
  708232
  587442
  639326
  786906
  779610
  791926
  755554
  809428
  811057
  738518
  756491
]
2.87 ms
(1.81%)
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
  396303
  398499
  413687
  418117
  418146
  418622
  434328
  434345
  434376
  439244
  441396
  442527
  450162
  459213
  466510
  467885
  468658
  469794
  473607
  494546
  496345
  498795
  500875
  500945
  505805
  506510
  507713
  513562
  515874
  528407
  537651
  542181
  544401
  547580
  547795
  555821
  559368
  564757
  565547
  574319
  577608
  579863
  582571
  583807
  587442
  587899
  595339
  618750
  622065
  624839
  639326
  655517
  659343
  665641
  669877
  669936
  677839
  678834
  678842
  680614
  681486
  705005
  708232
  720576
  721083
  732795
  738518
  739810
  740894
  744457
  744782
  750626
  755554
  756491
  757730
  767753
  768946
  769338
  772602
  773254
  773868
  779610
  783921
  784048
  784097
  784138
  784965
  785075
  785197
  785320
  786906
  791492
  791857
  791926
  793201
  794462
  795818
  795832
  797036
  797075
  800054
  801534
  801795
  801811
  801842
  803040
  803568
  804064
  807578
  808321
  808629
  808659
  808962
  809428
  811057
  814419
  820308
  825685
  826143
  826973
]
2.04 ms
(1.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сквирт оргазм жен"
]
1.74 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сквирт оргазм жен"
]
1.67 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "squirt wife"
]

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.