GET https://search.jues.net/search/embeds/5?q=lick%20hairy%20mature

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.35 ms
(81.12%)
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
  381950
  386218
  388347
  389973
  407753
  407769
  407878
  408969
  411375
  411393
  411736
  411750
  416926
  419554
  419873
  421974
  424426
  428920
  432889
  443428
  443687
  443698
  443707
  443725
  443760
  447166
  449096
  450187
  451967
  452115
  453161
  454221
  458924
  460181
  460729
  460743
  460921
  462022
  462451
  462799
  465331
  465338
  466085
  466095
  466721
  466885
  466965
  467233
  467547
  469276
  469383
  472316
  472611
  473249
  473256
  474112
  474409
  475895
  476252
  476351
  476399
  477116
  477547
  477989
  479685
  482330
  483090
  484391
  484392
  484439
  484463
  484563
  485129
  485457
  485731
  486894
  504104
  510533
  512536
  519089
  519141
  526077
  526401
  526737
  526892
  527873
  529245
  529383
  541637
  549228
  549771
  555204
  555209
  555314
  555377
  555387
  555413
  563212
  567751
  592388
  596000
  610006
  624227
  644306
  663381
  669276
  718496
  727744
  748231
  748463
  750063
  804208
  807340
  814431
  814794
  814926
  815299
  815559
  819823
  820327
]
18.15 ms
(12.24%)
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
  411750
  408969
  820327
  814794
  815299
  450187
  451967
  466721
  474409
  485129
  460181
  469383
  474112
  483090
  519089
  526077
  526401
  510533
  526892
  504104
  469276
  472611
  555413
  541637
  555209
  563212
  555387
  663381
  718496
  555204
  610006
  748463
  804208
  748231
  407753
  443698
  462022
  381950
  419554
  443428
  460921
  477989
  411375
  467547
  411393
  443687
  473256
  476351
  443725
  443760
  465331
  465338
  466965
  477547
  479685
  526737
  484391
  519141
  529245
  484439
  389973
  416926
  407878
  428920
  432889
  814431
  814926
  815559
  477116
  449096
  462799
  485457
  549228
  555377
  555314
  669276
  592388
  596000
  750063
  727744
  624227
  644306
  482330
  419873
  388347
  443707
  447166
  452115
  472316
  549771
  424426
  460729
  460743
  484563
  486894
  453161
  421974
  466885
  484463
  407769
  411736
  476252
  485731
  458924
  475895
  512536
  527873
  567751
  807340
  473249
  466095
  466085
  467233
  484392
  454221
  819823
  386218
  462451
  476399
  529383
]
2.62 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
  381950
  386218
  388347
  389973
  407753
  407769
  407878
  408969
  411375
  411393
  411736
  411750
  416926
  419554
  419873
  421974
  424426
  428920
  432889
  443428
  443687
  443698
  443707
  443725
  443760
  447166
  449096
  450187
  451967
  452115
  453161
  454221
  458924
  460181
  460729
  460743
  460921
  462022
  462451
  462799
  465331
  465338
  466085
  466095
  466721
  466885
  466965
  467233
  467547
  469276
  469383
  472316
  472611
  473249
  473256
  474112
  474409
  475895
  476252
  476351
  476399
  477116
  477547
  477989
  479685
  482330
  483090
  484391
  484392
  484439
  484463
  484563
  485129
  485457
  485731
  486894
  504104
  510533
  512536
  519089
  519141
  526077
  526401
  526737
  526892
  527873
  529245
  529383
  541637
  549228
  549771
  555204
  555209
  555314
  555377
  555387
  555413
  563212
  567751
  592388
  596000
  610006
  624227
  644306
  663381
  669276
  718496
  727744
  748231
  748463
  750063
  804208
  807340
  814431
  814794
  814926
  815299
  815559
  819823
  820327
]
2.02 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "lick hairy mature"
]
1.95 ms
(1.31%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "лиза волосатая mature"
]
1.54 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "лиза волосатая mature"
]

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.