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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.42 ms
(82.11%)
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
  391947
  398965
  398993
  426870
  452651
  455127
  462130
  470937
  471969
  476636
  482955
  483960
  485383
  485421
  485971
  495573
  500429
  506074
  509749
  520366
  536447
  537078
  544978
  548049
  556601
  558000
  571132
  590525
  599985
  600272
  600813
  619899
  621376
  628672
  631322
  640898
  644622
  650064
  650641
  658431
  659938
  666515
  695358
  700899
  714189
  719408
  725220
  725247
  725251
  725459
  725483
  725497
  725498
  725539
  731088
  731151
  735828
  735925
  735944
  736010
  736381
  739634
  739935
  741211
  741713
  741737
  741765
  742544
  742562
  742765
  744167
  744388
  744396
  744400
  744416
  744435
  745321
  745373
  746132
  747245
  749604
  762177
  787654
  790193
  792538
  794816
  795927
  795947
  795956
  795990
  799713
  800729
  800734
  800741
  800749
  803440
  807016
  807017
  819350
  819962
  823848
  824294
  825320
  825361
  825433
  825435
  825858
  825882
  826127
  826194
  826197
  826303
  826374
  826582
  826927
  827181
  827594
  827657
  827669
  827725
]
15.03 ms
(9.84%)
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
  742544
  742562
  742765
  749604
  631322
  719408
  795956
  826127
  462130
  391947
  790193
  455127
  471969
  520366
  485383
  398965
  495573
  485421
  452651
  500429
  548049
  650064
  666515
  741737
  741713
  426870
  485971
  476636
  483960
  398993
  470937
  482955
  825361
  825435
  823848
  825320
  825433
  825858
  826374
  826582
  826927
  827181
  827594
  827725
  819962
  826197
  819350
  824294
  825882
  826194
  826303
  827657
  827669
  537078
  506074
  509749
  536447
  544978
  556601
  571132
  558000
  650641
  695358
  714189
  658431
  700899
  659938
  600272
  640898
  644622
  590525
  621376
  628672
  599985
  600813
  619899
  792538
  795990
  800729
  800741
  800749
  787654
  794816
  795947
  800734
  807016
  807017
  725247
  725251
  725459
  725483
  731088
  735925
  735944
  741211
  744167
  745373
  747245
  795927
  799713
  803440
  725220
  735828
  736381
  739634
  744396
  744416
  744435
  745321
  762177
  725497
  731151
  736010
  739935
  741765
  744388
  744400
  746132
  725498
  725539
]
4.28 ms
(2.80%)
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
  391947
  398965
  398993
  426870
  452651
  455127
  462130
  470937
  471969
  476636
  482955
  483960
  485383
  485421
  485971
  495573
  500429
  506074
  509749
  520366
  536447
  537078
  544978
  548049
  556601
  558000
  571132
  590525
  599985
  600272
  600813
  619899
  621376
  628672
  631322
  640898
  644622
  650064
  650641
  658431
  659938
  666515
  695358
  700899
  714189
  719408
  725220
  725247
  725251
  725459
  725483
  725497
  725498
  725539
  731088
  731151
  735828
  735925
  735944
  736010
  736381
  739634
  739935
  741211
  741713
  741737
  741765
  742544
  742562
  742765
  744167
  744388
  744396
  744400
  744416
  744435
  745321
  745373
  746132
  747245
  749604
  762177
  787654
  790193
  792538
  794816
  795927
  795947
  795956
  795990
  799713
  800729
  800734
  800741
  800749
  803440
  807016
  807017
  819350
  819962
  823848
  824294
  825320
  825361
  825433
  825435
  825858
  825882
  826127
  826194
  826197
  826303
  826374
  826582
  826927
  827181
  827594
  827657
  827669
  827725
]
2.28 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam chubby russian"
]
2.14 ms
(1.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер chubby русск"
]
2.01 ms
(1.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вебкамер chubby русск"
]

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.