GET https://search.jues.net/search/embeds/10?q=small%20tits%20shower

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.56 ms
(83.53%)
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
  382276
  397555
  398431
  399475
  405742
  424056
  443248
  446815
  457774
  460474
  462584
  466016
  466645
  476769
  477908
  488733
  491809
  492805
  494318
  496041
  496800
  500878
  503706
  505333
  516348
  516647
  519994
  521902
  522246
  532006
  536331
  538201
  538217
  540139
  541865
  545539
  546745
  549364
  549384
  551999
  552602
  552604
  554893
  556051
  556352
  563206
  563772
  565359
  565371
  565499
  565565
  566031
  568503
  569422
  570869
  574908
  579520
  580335
  580971
  583469
  585136
  585397
  585680
  590813
  592417
  599130
  601438
  603082
  603095
  604915
  605581
  614662
  618725
  624023
  626907
  629604
  635234
  650919
  653328
  656107
  665182
  665490
  670265
  672388
  680137
  681457
  688997
  689490
  689565
  690658
  701917
  718581
  718665
  721280
  721839
  727759
  729552
  741647
  744612
  747442
  747944
  754480
  774468
  777619
  778975
  778980
  782123
  783267
  783939
  789212
  789888
  792388
  801227
  802827
  802832
  805212
  807067
  808523
  810863
  821120
]
17.51 ms
(10.71%)
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
  552602
  585680
  604915
  624023
  802832
  466645
  538217
  538201
  551999
  603082
  398431
  774468
  821120
  476769
  446815
  460474
  462584
  532006
  540139
  505333
  516647
  519994
  516348
  522246
  536331
  546745
  549384
  554893
  556352
  563206
  563772
  570869
  541865
  569422
  583469
  549364
  680137
  681457
  688997
  690658
  701917
  650919
  656107
  672388
  689490
  670265
  689565
  718665
  552604
  601438
  614662
  629604
  618725
  585397
  599130
  605581
  626907
  783267
  789888
  792388
  807067
  777619
  778980
  801227
  810863
  782123
  783939
  789212
  808523
  747442
  741647
  729552
  727759
  744612
  747944
  754480
  718581
  721280
  721839
  778975
  802827
  805212
  405742
  443248
  466016
  397555
  399475
  477908
  382276
  494318
  496041
  503706
  491809
  496800
  521902
  488733
  585136
  545539
  568503
  565371
  566031
  556051
  565499
  574908
  579520
  665490
  565359
  565565
  592417
  603095
  590813
  635234
  424056
  457774
  580335
  500878
  492805
  580971
  665182
  653328
]
2.38 ms
(1.46%)
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
  382276
  397555
  398431
  399475
  405742
  424056
  443248
  446815
  457774
  460474
  462584
  466016
  466645
  476769
  477908
  488733
  491809
  492805
  494318
  496041
  496800
  500878
  503706
  505333
  516348
  516647
  519994
  521902
  522246
  532006
  536331
  538201
  538217
  540139
  541865
  545539
  546745
  549364
  549384
  551999
  552602
  552604
  554893
  556051
  556352
  563206
  563772
  565359
  565371
  565499
  565565
  566031
  568503
  569422
  570869
  574908
  579520
  580335
  580971
  583469
  585136
  585397
  585680
  590813
  592417
  599130
  601438
  603082
  603095
  604915
  605581
  614662
  618725
  624023
  626907
  629604
  635234
  650919
  653328
  656107
  665182
  665490
  670265
  672388
  680137
  681457
  688997
  689490
  689565
  690658
  701917
  718581
  718665
  721280
  721839
  727759
  729552
  741647
  744612
  747442
  747944
  754480
  774468
  777619
  778975
  778980
  782123
  783267
  783939
  789212
  789888
  792388
  801227
  802827
  802832
  805212
  807067
  808523
  810863
  821120
]
1.94 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "small tits shower"
]
1.78 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "маленькая сиськ shower"
]
1.77 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "маленькая сиськ shower"
]

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.