GET https://search.jues.net/search/embeds/6?q=milf%20maid

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.53 ms
(85.57%)
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
  76043
  153472
  173134
  383321
  384580
  385911
  386658
  387275
  391114
  391517
  402103
  402131
  403467
  403476
  403487
  403555
  407562
  412583
  416273
  427295
  429570
  439595
  446756
  447535
  450830
  451719
  454414
  457582
  459939
  460610
  461697
  462455
  464440
  464979
  465256
  466263
  466265
  466827
  468137
  472876
  472891
  472897
  472913
  472956
  472958
  479108
  483849
  488372
  489060
  489937
  489941
  491914
  492606
  494732
  502289
  505818
  505953
  509586
  512734
  517443
  520364
  522785
  528395
  528877
  530308
  535314
  535700
  543475
  547863
  548024
  549067
  551971
  553661
  555146
  559711
  561759
  562989
  563210
  566323
  574060
  577471
  578682
  579838
  582782
  583678
  587185
  591383
  596961
  596987
  599707
  600406
  603929
  615513
  624293
  628683
  641156
  643296
  703501
  705371
  719923
  721945
  729299
  732163
  734835
  736791
  765769
  775121
  784767
  792561
  798269
  806928
  815530
  818009
  820143
  823276
  824017
  825269
  828334
  828710
  828874
]
12.87 ms
(8.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
  596987
  599707
  402131
  439595
  472958
  479108
  429570
  465256
  466265
  447535
  472891
  489060
  491914
  512734
  488372
  824017
  828334
  547863
  387275
  402103
  818009
  451719
  450830
  459939
  579838
  555146
  563210
  705371
  719923
  721945
  624293
  643296
  784767
  806928
  792561
  173134
  828874
  530308
  466263
  412583
  583678
  553661
  587185
  472956
  492606
  385911
  522785
  520364
  528395
  543475
  582782
  549067
  559711
  566323
  528877
  775121
  825269
  628683
  153472
  407562
  462455
  468137
  505953
  509586
  483849
  574060
  577471
  703501
  600406
  603929
  641156
  591383
  596961
  765769
  729299
  732163
  734835
  736791
  615513
  461697
  472913
  391517
  427295
  391114
  820143
  561759
  823276
  828710
  548024
  798269
  489941
  454414
  578682
  517443
  505818
  386658
  76043
  384580
  383321
  403476
  403487
  403467
  403555
  416273
  815530
  446756
  464440
  466827
  472876
  457582
  460610
  464979
  472897
  494732
  502289
  535314
  535700
  489937
  551971
  562989
]
2.81 ms
(1.77%)
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
  76043
  153472
  173134
  383321
  384580
  385911
  386658
  387275
  391114
  391517
  402103
  402131
  403467
  403476
  403487
  403555
  407562
  412583
  416273
  427295
  429570
  439595
  446756
  447535
  450830
  451719
  454414
  457582
  459939
  460610
  461697
  462455
  464440
  464979
  465256
  466263
  466265
  466827
  468137
  472876
  472891
  472897
  472913
  472956
  472958
  479108
  483849
  488372
  489060
  489937
  489941
  491914
  492606
  494732
  502289
  505818
  505953
  509586
  512734
  517443
  520364
  522785
  528395
  528877
  530308
  535314
  535700
  543475
  547863
  548024
  549067
  551971
  553661
  555146
  559711
  561759
  562989
  563210
  566323
  574060
  577471
  578682
  579838
  582782
  583678
  587185
  591383
  596961
  596987
  599707
  600406
  603929
  615513
  624293
  628683
  641156
  643296
  703501
  705371
  719923
  721945
  729299
  732163
  734835
  736791
  765769
  775121
  784767
  792561
  798269
  806928
  815530
  818009
  820143
  823276
  824017
  825269
  828334
  828710
  828874
]
1.92 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf горничн"
]
1.83 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf maid"
]
1.75 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf горничн"
]

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.