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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.40 ms
(88.04%)
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
  529594
  530412
  530651
  530668
  531301
  532390
  532654
  532986
  533614
  535371
  535744
  543656
  545967
  546456
  547018
  547062
  548097
  549488
  551891
  557477
  557501
  560121
  561511
  562540
  570882
  570883
  572388
  573916
  576492
  589561
  592759
  593049
  593661
  597103
  599809
  604881
  610070
  614236
  614277
  614359
  614360
  620997
  624466
  628358
  641924
  643026
  643031
  655585
  658846
  676409
  695530
  698246
  713585
  714602
  715668
  716160
  719924
  719939
  721938
  725313
  730630
  732901
  734377
  734420
  736161
  736961
  742673
  745910
  745991
  746598
  747121
  748183
  752864
  753070
  753702
  759113
  759142
  761159
  766766
  768063
  768975
  769993
  770933
  778505
  784093
  786187
  786948
  790433
  791804
  792584
  792782
  794262
  798925
  798981
  800452
  804391
  804429
  804584
  808309
  810338
  812521
  815377
  817697
  817888
  818668
  818995
  819096
  819428
  819437
  819507
  820364
  820982
  821170
  821731
  822633
  823560
  824025
  825181
  825738
]
11.64 ms
(6.72%)
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
  786948
  815377
  821170
  818668
  823560
  573916
  655585
  719939
  746598
  825738
  819507
  824025
  549488
  597103
  592759
  800452
  808309
  745991
  770933
  798925
  812521
  745910
  768975
  794262
  589561
  742673
  560121
  778505
  561511
  734377
  547062
  535744
  548097
  557501
  562540
  676409
  570882
  641924
  713585
  530651
  547018
  759142
  792584
  532390
  546456
  761159
  532986
  804584
  531301
  714602
  551891
  628358
  804429
  593049
  819428
  819437
  828117
  530668
  533614
  543656
  557477
  545967
  599809
  604881
  614360
  620997
  643026
  748183
  759113
  752864
  730630
  753702
  766766
  576492
  804391
  658846
  535371
  614359
  736161
  790433
  768063
  736961
  593661
  753070
  818995
  825181
  529594
  572388
  721938
  822633
  820364
  570883
  614236
  734420
  719924
  784093
  715668
  747121
  532654
  695530
  810338
  820982
  725313
  732901
  817888
  819096
  821731
  817697
  530412
  698246
  716160
  624466
  610070
  614277
  798981
  786187
  792782
  769993
  791804
  643031
]
2.35 ms
(1.36%)
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
  529594
  530412
  530651
  530668
  531301
  532390
  532654
  532986
  533614
  535371
  535744
  543656
  545967
  546456
  547018
  547062
  548097
  549488
  551891
  557477
  557501
  560121
  561511
  562540
  570882
  570883
  572388
  573916
  576492
  589561
  592759
  593049
  593661
  597103
  599809
  604881
  610070
  614236
  614277
  614359
  614360
  620997
  624466
  628358
  641924
  643026
  643031
  655585
  658846
  676409
  695530
  698246
  713585
  714602
  715668
  716160
  719924
  719939
  721938
  725313
  730630
  732901
  734377
  734420
  736161
  736961
  742673
  745910
  745991
  746598
  747121
  748183
  752864
  753070
  753702
  759113
  759142
  761159
  766766
  768063
  768975
  769993
  770933
  778505
  784093
  786187
  786948
  790433
  791804
  792584
  792782
  794262
  798925
  798981
  800452
  804391
  804429
  804584
  808309
  810338
  812521
  815377
  817697
  817888
  818668
  818995
  819096
  819428
  819437
  819507
  820364
  820982
  821170
  821731
  822633
  823560
  824025
  825181
  825738
]
1.82 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на улиц большие сиськ"
]
1.81 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на улиц большие сиськ"
]
1.54 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public big tits"
]

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.