GET https://search.jues.net/search/embeds/8?q=bbw%20hair

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
484.29 ms
(94.88%)
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
  400849
  414369
  420178
  425724
  430297
  430707
  431643
  443637
  444913
  444940
  445607
  445935
  450171
  453125
  453190
  453242
  454227
  454447
  458000
  458761
  459476
  460294
  460969
  461731
  462818
  463152
  464336
  464359
  465571
  465698
  467029
  468900
  470041
  474089
  475592
  476229
  476260
  476339
  476619
  483448
  488439
  489272
  490304
  491164
  491411
  491865
  494282
  494289
  496017
  496662
  506345
  507643
  509842
  510425
  513583
  514843
  515350
  515952
  520143
  523169
  524903
  525468
  525479
  527415
  527418
  527885
  529378
  530745
  531539
  532630
  536481
  536491
  537098
  544834
  550220
  551115
  560123
  563732
  568365
  568982
  568989
  569098
  571102
  571823
  575924
  577211
  578198
  580642
  580744
  582444
  585746
  590870
  591942
  592951
  592985
  594207
  603217
  603264
  610293
  614742
  621787
  640314
  651609
  654634
  663427
  663490
  664837
  665110
  665113
  666776
  666784
  667554
  667644
  675515
  678764
  695163
  696513
  748128
  771482
  781914
]
16.82 ms
(3.29%)
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
  654634
  663427
  667644
  696513
  665113
  550220
  560123
  580642
  592985
  621787
  640314
  590870
  594207
  748128
  771482
  781914
  444913
  476229
  465571
  420178
  470041
  476619
  450171
  458000
  468900
  425724
  430297
  459476
  460294
  506345
  483448
  489272
  513583
  525468
  491865
  431643
  414369
  443637
  430707
  445935
  453125
  453242
  454227
  464336
  453190
  454447
  461731
  465698
  445607
  462818
  476260
  515350
  515952
  525479
  527418
  529378
  520143
  531539
  532630
  536491
  494289
  496017
  496662
  514843
  474089
  491411
  563732
  569098
  577211
  582444
  568365
  578198
  568982
  580744
  664837
  665110
  651609
  663490
  666776
  667554
  544834
  568989
  575924
  591942
  592951
  585746
  603217
  603264
  610293
  614742
  475592
  463152
  467029
  400849
  476339
  444940
  460969
  488439
  509842
  510425
  491164
  527885
  458761
  490304
  523169
  527415
  507643
  537098
  494282
  536481
  524903
  530745
  464359
  571102
  551115
  675515
  678764
  666784
  695163
  571823
]
2.71 ms
(0.53%)
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
  400849
  414369
  420178
  425724
  430297
  430707
  431643
  443637
  444913
  444940
  445607
  445935
  450171
  453125
  453190
  453242
  454227
  454447
  458000
  458761
  459476
  460294
  460969
  461731
  462818
  463152
  464336
  464359
  465571
  465698
  467029
  468900
  470041
  474089
  475592
  476229
  476260
  476339
  476619
  483448
  488439
  489272
  490304
  491164
  491411
  491865
  494282
  494289
  496017
  496662
  506345
  507643
  509842
  510425
  513583
  514843
  515350
  515952
  520143
  523169
  524903
  525468
  525479
  527415
  527418
  527885
  529378
  530745
  531539
  532630
  536481
  536491
  537098
  544834
  550220
  551115
  560123
  563732
  568365
  568982
  568989
  569098
  571102
  571823
  575924
  577211
  578198
  580642
  580744
  582444
  585746
  590870
  591942
  592951
  592985
  594207
  603217
  603264
  610293
  614742
  621787
  640314
  651609
  654634
  663427
  663490
  664837
  665110
  665113
  666776
  666784
  667554
  667644
  675515
  678764
  695163
  696513
  748128
  771482
  781914
]
1.96 ms
(0.38%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "bbw hair"
]
1.75 ms
(0.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bbw hair"
]
1.49 ms
(0.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "bbw hair"
]

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.