GET https://search.jues.net/search/embeds/7?q=public%20big%20tits

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.66 ms
(86.49%)
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
  145667
  154512
  323393
  387753
  394577
  420170
  456850
  461683
  469243
  516758
  517497
  523146
  528675
  530094
  530547
  534569
  537570
  538768
  539598
  541579
  543307
  550164
  557461
  560884
  570942
  575663
  579455
  594872
  601854
  605225
  606640
  607316
  619655
  628623
  629642
  629825
  634452
  638407
  638426
  641252
  642962
  644872
  649581
  649904
  651178
  652573
  662410
  663893
  667471
  668281
  672764
  677749
  687616
  696432
  700304
  707884
  709405
  711905
  715449
  723108
  723971
  724781
  724804
  725417
  725864
  732113
  733430
  734071
  738352
  739646
  744974
  746329
  748346
  748483
  749424
  753028
  757245
  757688
  758926
  769995
  771498
  772556
  776672
  781133
  782060
  782121
  786403
  789048
  789069
  789265
  789424
  789669
  790158
  792925
  792927
  797335
  798169
  798783
  799709
  802735
  803684
  803840
  804389
  804596
  808295
  809761
  811987
  812232
  812530
  813070
  814185
  814377
  818657
  820646
  821618
  821748
  822441
  822981
  823351
  824179
]
13.19 ms
(8.29%)
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
  789669
  802735
  812530
  732113
  758926
  769995
  757688
  797335
  323393
  530547
  541579
  672764
  789265
  725417
  812232
  746329
  749424
  798783
  145667
  528675
  629642
  733430
  649904
  776672
  771498
  824179
  724804
  638426
  154512
  820646
  823351
  644872
  821618
  818657
  821748
  651178
  638407
  804596
  744974
  725864
  723108
  534569
  814185
  814377
  517497
  530094
  543307
  570942
  709405
  652573
  700304
  707884
  641252
  792927
  799709
  757245
  629825
  809761
  711905
  813070
  461683
  469243
  634452
  789048
  792925
  803684
  822441
  822981
  516758
  649581
  668281
  781133
  739646
  772556
  607316
  628623
  687616
  523146
  560884
  662410
  667471
  786403
  803840
  789424
  790158
  782060
  394577
  738352
  420170
  734071
  557461
  789069
  539598
  748483
  387753
  606640
  696432
  748346
  538768
  663893
  723971
  456850
  715449
  619655
  753028
  575663
  804389
  811987
  550164
  601854
  782121
  642962
  537570
  579455
  594872
  798169
  808295
  724781
  605225
  677749
]
2.43 ms
(1.53%)
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
  145667
  154512
  323393
  387753
  394577
  420170
  456850
  461683
  469243
  516758
  517497
  523146
  528675
  530094
  530547
  534569
  537570
  538768
  539598
  541579
  543307
  550164
  557461
  560884
  570942
  575663
  579455
  594872
  601854
  605225
  606640
  607316
  619655
  628623
  629642
  629825
  634452
  638407
  638426
  641252
  642962
  644872
  649581
  649904
  651178
  652573
  662410
  663893
  667471
  668281
  672764
  677749
  687616
  696432
  700304
  707884
  709405
  711905
  715449
  723108
  723971
  724781
  724804
  725417
  725864
  732113
  733430
  734071
  738352
  739646
  744974
  746329
  748346
  748483
  749424
  753028
  757245
  757688
  758926
  769995
  771498
  772556
  776672
  781133
  782060
  782121
  786403
  789048
  789069
  789265
  789424
  789669
  790158
  792925
  792927
  797335
  798169
  798783
  799709
  802735
  803684
  803840
  804389
  804596
  808295
  809761
  811987
  812232
  812530
  813070
  814185
  814377
  818657
  820646
  821618
  821748
  822441
  822981
  823351
  824179
]
1.64 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public big tits"
]
1.55 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на улиц большие сиськ"
]
1.36 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на улиц большие сиськ"
]
1.32 ms
(0.83%)
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.