GET https://search.jues.net/search/embeds/4?q=redhead%20russian%20webcam

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.78 ms
(83.29%)
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
  386384
  421196
  421810
  431754
  438657
  439767
  442869
  446064
  456610
  458349
  459056
  459613
  462322
  464732
  472119
  475595
  478392
  478525
  480501
  484776
  484904
  492283
  495744
  497290
  503154
  503821
  508412
  508414
  510338
  518840
  519597
  529086
  534932
  535348
  543644
  544887
  549794
  553958
  557004
  557941
  567165
  567368
  568733
  571843
  575287
  591168
  594630
  595517
  598050
  598081
  599283
  607537
  613398
  616013
  620046
  622746
  623104
  631318
  637727
  647175
  661933
  690936
  705411
  706143
  706692
  707906
  711739
  716709
  722305
  722349
  730835
  740553
  740623
  743658
  745311
  747572
  753641
  757924
  761974
  762507
  763874
  766504
  778088
  778160
  778535
  780143
  787291
  787939
  789164
  789732
  789781
  791037
  791075
  791179
  791723
  792535
  794360
  800657
  803447
  803523
  803563
  804820
  804873
  805177
  810354
  816101
  816128
  816143
  816609
  818873
  819850
  819851
  819996
  820071
  824311
  825528
  825715
  825795
  826863
  827003
]
17.20 ms
(10.10%)
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
  459613
  484776
  544887
  543644
  791179
  791723
  761974
  816101
  816128
  824311
  819851
  820071
  705411
  706143
  711739
  706692
  722349
  594630
  623104
  631318
  778535
  803447
  757924
  792535
  753641
  747572
  730835
  613398
  637727
  787291
  787939
  791037
  804820
  810354
  568733
  557941
  462322
  459056
  464732
  475595
  503821
  508414
  458349
  575287
  431754
  567368
  571843
  553958
  567165
  690936
  591168
  616013
  421196
  421810
  478525
  446064
  472119
  503154
  495744
  497290
  508412
  510338
  518840
  519597
  661933
  818873
  825795
  826863
  816609
  819850
  825528
  827003
  535348
  707906
  716709
  722305
  647175
  598081
  599283
  620046
  622746
  789781
  791075
  805177
  778160
  800657
  803523
  803563
  740553
  794360
  762507
  763874
  740623
  766504
  745311
  778088
  780143
  789164
  789732
  804873
  480501
  386384
  492283
  595517
  439767
  549794
  442869
  456610
  607537
  598050
  743658
  484904
  557004
  478392
  438657
  529086
  825715
  816143
  819996
  534932
]
3.38 ms
(1.99%)
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
  386384
  421196
  421810
  431754
  438657
  439767
  442869
  446064
  456610
  458349
  459056
  459613
  462322
  464732
  472119
  475595
  478392
  478525
  480501
  484776
  484904
  492283
  495744
  497290
  503154
  503821
  508412
  508414
  510338
  518840
  519597
  529086
  534932
  535348
  543644
  544887
  549794
  553958
  557004
  557941
  567165
  567368
  568733
  571843
  575287
  591168
  594630
  595517
  598050
  598081
  599283
  607537
  613398
  616013
  620046
  622746
  623104
  631318
  637727
  647175
  661933
  690936
  705411
  706143
  706692
  707906
  711739
  716709
  722305
  722349
  730835
  740553
  740623
  743658
  745311
  747572
  753641
  757924
  761974
  762507
  763874
  766504
  778088
  778160
  778535
  780143
  787291
  787939
  789164
  789732
  789781
  791037
  791075
  791179
  791723
  792535
  794360
  800657
  803447
  803523
  803563
  804820
  804873
  805177
  810354
  816101
  816128
  816143
  816609
  818873
  819850
  819851
  819996
  820071
  824311
  825528
  825715
  825795
  826863
  827003
]
2.54 ms
(1.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "redhead russian webcam"
]
1.89 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рыжая русск вебкамер"
]
1.69 ms
(0.99%)
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.