GET https://search.jues.net/search/embeds/10?q=saggy%20mature%20solo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.83 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
  382993
  383920
  387407
  452925
  454331
  457631
  464962
  466756
  469305
  470007
  470851
  476320
  486813
  490381
  492427
  495042
  495892
  496842
  499885
  505348
  512027
  513162
  517519
  517522
  523385
  524286
  524470
  526096
  529997
  537271
  537871
  537957
  542215
  542467
  544143
  550925
  554803
  554901
  558247
  563539
  570887
  570951
  573164
  573174
  576440
  578218
  578625
  581033
  582466
  586081
  586441
  588911
  590222
  592998
  599810
  604826
  612968
  619791
  623936
  628522
  629602
  638477
  649377
  649528
  668509
  668696
  670185
  687312
  695603
  710447
  710461
  710564
  714316
  714332
  714479
  715567
  726829
  728578
  736017
  736077
  742402
  742549
  744197
  746125
  749087
  751511
  756043
  757219
  759117
  759139
  770103
  776544
  788360
  793037
  793053
  794213
  794216
  794234
  794243
  796452
  796871
  797324
  799155
  800542
  800707
  800727
  800753
  800754
  802071
  803441
  803516
  803687
  803700
  804441
  809542
  809554
  810092
  812554
  812742
  825419
]
13.88 ms
(8.61%)
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
  793037
  794213
  794216
  796452
  797324
  799155
  800707
  802071
  803441
  803516
  810092
  464962
  466756
  387407
  452925
  457631
  470007
  495042
  486813
  517519
  776544
  749087
  383920
  382993
  825419
  469305
  492427
  470851
  490381
  454331
  495892
  496842
  513162
  526096
  537271
  505348
  517522
  523385
  537957
  512027
  524286
  529997
  537871
  499885
  524470
  476320
  570887
  570951
  578218
  542215
  542467
  554803
  558247
  563539
  581033
  544143
  550925
  554901
  573164
  573174
  576440
  582466
  668509
  668696
  695603
  710564
  714316
  714332
  714479
  649377
  670185
  687312
  715567
  649528
  710447
  710461
  578625
  588911
  604826
  590222
  592998
  599810
  628522
  629602
  586441
  612968
  619791
  623936
  586081
  638477
  793053
  794243
  796871
  800727
  809542
  794234
  800753
  803687
  803700
  804441
  812742
  728578
  736077
  746125
  759117
  788360
  800542
  800754
  809554
  812554
  736017
  751511
  756043
  757219
  770103
  742549
  759139
  726829
  742402
  744197
]
2.88 ms
(1.79%)
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
  382993
  383920
  387407
  452925
  454331
  457631
  464962
  466756
  469305
  470007
  470851
  476320
  486813
  490381
  492427
  495042
  495892
  496842
  499885
  505348
  512027
  513162
  517519
  517522
  523385
  524286
  524470
  526096
  529997
  537271
  537871
  537957
  542215
  542467
  544143
  550925
  554803
  554901
  558247
  563539
  570887
  570951
  573164
  573174
  576440
  578218
  578625
  581033
  582466
  586081
  586441
  588911
  590222
  592998
  599810
  604826
  612968
  619791
  623936
  628522
  629602
  638477
  649377
  649528
  668509
  668696
  670185
  687312
  695603
  710447
  710461
  710564
  714316
  714332
  714479
  715567
  726829
  728578
  736017
  736077
  742402
  742549
  744197
  746125
  749087
  751511
  756043
  757219
  759117
  759139
  770103
  776544
  788360
  793037
  793053
  794213
  794216
  794234
  794243
  796452
  796871
  797324
  799155
  800542
  800707
  800727
  800753
  800754
  802071
  803441
  803516
  803687
  803700
  804441
  809542
  809554
  810092
  812554
  812742
  825419
]
2.02 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "saggy mature solo"
]
1.76 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "saggy mature соло"
]
1.51 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.21 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "saggy 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.