GET https://search.jues.net/search/embeds/6?q=retro%20big%20vagina

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.65 ms
(81.18%)
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
  233733
  418978
  471874
  519234
  522914
  524986
  538873
  538937
  541329
  541337
  542471
  543502
  544113
  544294
  544299
  544318
  544483
  544571
  544855
  546447
  546943
  548289
  549214
  549758
  550224
  550320
  550332
  554351
  554786
  554886
  557187
  561007
  561024
  561599
  562840
  562963
  562999
  563004
  563169
  563227
  563419
  563448
  563462
  564467
  566244
  566371
  566619
  568274
  569480
  569915
  570258
  570332
  572541
  573105
  573906
  574237
  574291
  576693
  576697
  576699
  577346
  577352
  577357
  577375
  579304
  580921
  581313
  583079
  584250
  587795
  587797
  589817
  592443
  592512
  592636
  608354
  609919
  615459
  615565
  617648
  618868
  619401
  620152
  620162
  621313
  621994
  622364
  624394
  625487
  626546
  629899
  633161
  644259
  644311
  644922
  649614
  650836
  651684
  652876
  653328
  668465
  670040
  671737
  671755
  672372
  674081
  681059
  681182
  682839
  690822
  690831
  690846
  694063
  697229
  705549
  706939
  712006
  716368
  727747
  727769
]
18.80 ms
(12.45%)
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
  572541
  566619
  576697
  554886
  546447
  580921
  649614
  682839
  561024
  644259
  626546
  538873
  519234
  561599
  570332
  650836
  550224
  563462
  609919
  608354
  592443
  233733
  522914
  549214
  544299
  562999
  570258
  577352
  549758
  544294
  563004
  566244
  584250
  651684
  652876
  681059
  668465
  681182
  577346
  633161
  624394
  574291
  629899
  618868
  619401
  644922
  550332
  561007
  569480
  569915
  544483
  562840
  563169
  574237
  670040
  671737
  674081
  705549
  706939
  653328
  671755
  562963
  563227
  615459
  621994
  587795
  592512
  620152
  644311
  727747
  712006
  557187
  576699
  554786
  577375
  563448
  577357
  583079
  690831
  694063
  690846
  620162
  621313
  727769
  541329
  544113
  576693
  548289
  541337
  542471
  573105
  546943
  573906
  581313
  587797
  625487
  524986
  544855
  564467
  592636
  471874
  538937
  543502
  544318
  544571
  550320
  563419
  568274
  554351
  566371
  672372
  690822
  697229
  579304
  589817
  615565
  622364
  617648
  716368
  418978
]
2.26 ms
(1.50%)
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
  233733
  418978
  471874
  519234
  522914
  524986
  538873
  538937
  541329
  541337
  542471
  543502
  544113
  544294
  544299
  544318
  544483
  544571
  544855
  546447
  546943
  548289
  549214
  549758
  550224
  550320
  550332
  554351
  554786
  554886
  557187
  561007
  561024
  561599
  562840
  562963
  562999
  563004
  563169
  563227
  563419
  563448
  563462
  564467
  566244
  566371
  566619
  568274
  569480
  569915
  570258
  570332
  572541
  573105
  573906
  574237
  574291
  576693
  576697
  576699
  577346
  577352
  577357
  577375
  579304
  580921
  581313
  583079
  584250
  587795
  587797
  589817
  592443
  592512
  592636
  608354
  609919
  615459
  615565
  617648
  618868
  619401
  620152
  620162
  621313
  621994
  622364
  624394
  625487
  626546
  629899
  633161
  644259
  644311
  644922
  649614
  650836
  651684
  652876
  653328
  668465
  670040
  671737
  671755
  672372
  674081
  681059
  681182
  682839
  690822
  690831
  690846
  694063
  697229
  705549
  706939
  712006
  716368
  727747
  727769
]
2.22 ms
(1.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "retro big vagina"
]
1.80 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ретр большие вагин"
]
1.76 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "ретр большие вагин"
]

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.