GET https://search.jues.net/search/embeds/4?q=hotwife%20amateur

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.50 ms
(78.73%)
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
  401773
  418264
  423329
  423350
  425486
  427182
  427306
  455507
  455974
  458089
  458240
  458827
  471978
  473293
  478543
  478558
  480702
  482895
  484022
  490253
  492040
  493299
  496527
  496528
  497850
  501203
  501209
  502541
  502549
  504909
  507182
  507310
  507312
  509707
  509713
  511152
  514842
  515396
  516874
  517425
  520208
  520229
  520485
  524417
  525378
  525923
  526621
  526720
  531966
  535049
  536032
  538064
  540513
  543392
  553000
  562953
  563634
  566112
  578812
  582821
  585281
  586574
  587300
  589196
  590188
  591415
  591416
  593835
  593872
  595099
  604191
  604702
  605601
  605646
  605703
  612804
  613599
  620725
  624975
  626811
  628426
  630915
  632724
  632924
  633899
  633972
  635422
  635490
  635582
  636367
  636579
  636598
  639044
  645201
  653876
  654273
  654295
  656815
  679567
  691713
  697006
  715581
  715583
  725527
  761293
  768581
  785657
  813018
]
24.34 ms
(15.39%)
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
  691713
  715583
  605601
  633899
  587300
  589196
  761293
  813018
  493299
  401773
  497850
  525923
  531966
  478543
  654295
  654273
  645201
  605646
  590188
  725527
  785657
  478558
  418264
  517425
  482895
  502549
  612804
  538064
  586574
  458827
  458240
  496528
  632924
  620725
  633972
  768581
  458089
  484022
  514842
  536032
  501203
  507182
  656815
  715581
  585281
  613599
  635582
  604702
  624975
  635422
  425486
  595099
  520485
  697006
  578812
  632724
  635490
  526720
  490253
  553000
  630915
  427306
  471978
  520208
  496527
  543392
  653876
  636367
  455507
  526621
  511152
  520229
  605703
  639044
  473293
  455974
  492040
  626811
  636598
  502541
  509707
  535049
  593835
  636579
  423350
  516874
  507310
  604191
  480702
  504909
  562953
  507312
  525378
  427182
  582821
  593872
  540513
  515396
  566112
  563634
  591416
  501209
  524417
  509713
  679567
  423329
  591415
  628426
]
2.76 ms
(1.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
  401773
  418264
  423329
  423350
  425486
  427182
  427306
  455507
  455974
  458089
  458240
  458827
  471978
  473293
  478543
  478558
  480702
  482895
  484022
  490253
  492040
  493299
  496527
  496528
  497850
  501203
  501209
  502541
  502549
  504909
  507182
  507310
  507312
  509707
  509713
  511152
  514842
  515396
  516874
  517425
  520208
  520229
  520485
  524417
  525378
  525923
  526621
  526720
  531966
  535049
  536032
  538064
  540513
  543392
  553000
  562953
  563634
  566112
  578812
  582821
  585281
  586574
  587300
  589196
  590188
  591415
  591416
  593835
  593872
  595099
  604191
  604702
  605601
  605646
  605703
  612804
  613599
  620725
  624975
  626811
  628426
  630915
  632724
  632924
  633899
  633972
  635422
  635490
  635582
  636367
  636579
  636598
  639044
  645201
  653876
  654273
  654295
  656815
  679567
  691713
  697006
  715581
  715583
  725527
  761293
  768581
  785657
  813018
]
2.16 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hotwife amateur"
]
1.79 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hotwife любительск"
]
1.20 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hotwife любительск"
]

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.