GET https://search.jues.net/search/embeds/9?q=retro%20sex%20films

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.15 ms
(84.56%)
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
  538949
  540203
  541368
  541587
  541632
  541633
  541646
  541833
  541871
  541888
  542188
  542480
  542954
  542961
  543480
  543496
  544296
  544472
  544478
  550020
  554205
  554784
  554786
  554787
  556987
  559051
  559119
  559378
  560085
  560924
  562831
  563419
  566243
  566688
  566702
  571028
  571428
  571442
  573763
  573765
  574244
  574258
  576631
  576638
  576639
  576680
  576686
  576691
  576698
  576699
  576704
  576705
  576707
  576710
  576720
  576723
  576726
  577357
  577363
  577374
  577384
  580254
  580258
  581266
  581295
  581300
  581398
  583832
  583860
  583885
  587817
  590954
  592003
  592376
  592388
  592437
  592440
  592492
  592530
  593365
  598348
  598407
  603147
  603247
  603273
  610047
  614745
  615738
  615740
  615743
  615748
  615751
  617814
  619082
  619394
  619468
  620130
  620148
  620153
  620157
  621305
  621306
  621691
  622364
  622373
  622381
  622382
  622953
  624154
  624155
  636268
  644005
  648204
  648256
  671735
  671737
  671764
  673537
  690783
  715670
]
18.16 ms
(9.65%)
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
  617814
  577363
  563419
  576680
  576639
  576705
  671737
  592388
  583860
  603273
  592003
  542954
  541888
  541587
  541633
  576726
  541833
  542188
  576710
  571428
  544296
  543496
  574244
  566688
  610047
  619394
  622364
  559119
  542961
  554784
  544478
  576638
  576723
  554205
  574258
  636268
  621691
  560924
  581266
  673537
  581295
  592492
  592376
  559051
  583832
  541368
  587817
  621306
  577357
  671764
  615743
  540203
  573763
  593365
  620153
  622382
  615738
  615751
  554786
  550020
  538949
  576699
  598348
  562831
  566702
  541632
  556987
  544472
  690783
  541646
  671735
  590954
  621305
  576707
  543480
  715670
  580254
  615740
  615748
  576698
  577374
  619082
  571442
  580258
  576631
  619468
  620148
  624154
  542480
  648204
  576686
  560085
  648256
  644005
  622373
  620130
  592530
  583885
  592440
  581300
  592437
  622953
  624155
  577384
  598407
  603147
  622381
  541871
  614745
  581398
  554787
  573765
  566243
  576704
  620157
  576691
  603247
  559378
  576720
  571028
]
3.54 ms
(1.88%)
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
  538949
  540203
  541368
  541587
  541632
  541633
  541646
  541833
  541871
  541888
  542188
  542480
  542954
  542961
  543480
  543496
  544296
  544472
  544478
  550020
  554205
  554784
  554786
  554787
  556987
  559051
  559119
  559378
  560085
  560924
  562831
  563419
  566243
  566688
  566702
  571028
  571428
  571442
  573763
  573765
  574244
  574258
  576631
  576638
  576639
  576680
  576686
  576691
  576698
  576699
  576704
  576705
  576707
  576710
  576720
  576723
  576726
  577357
  577363
  577374
  577384
  580254
  580258
  581266
  581295
  581300
  581398
  583832
  583860
  583885
  587817
  590954
  592003
  592376
  592388
  592437
  592440
  592492
  592530
  593365
  598348
  598407
  603147
  603247
  603273
  610047
  614745
  615738
  615740
  615743
  615748
  615751
  617814
  619082
  619394
  619468
  620130
  620148
  620153
  620157
  621305
  621306
  621691
  622364
  622373
  622381
  622382
  622953
  624154
  624155
  636268
  644005
  648204
  648256
  671735
  671737
  671764
  673537
  690783
  715670
]
2.04 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "retro sex films"
]
1.84 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ретр секс фильм"
]
1.81 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "ретр секс фильм"
]
1.68 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.