GET https://search.jues.net/search/embeds/9?q=big%20ass%20gape

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
224.85 ms
(90.53%)
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
  393271
  398077
  428570
  429890
  515293
  529741
  530394
  531815
  531852
  537141
  541793
  542396
  543200
  543258
  543546
  543600
  543862
  543896
  544131
  544707
  544988
  545808
  545878
  547411
  547448
  547515
  548391
  548462
  550945
  551728
  552019
  552642
  554088
  555249
  555769
  555779
  556944
  557060
  558010
  558264
  558657
  559420
  561520
  564232
  565148
  565575
  568545
  570134
  571114
  571379
  575862
  575919
  576588
  577610
  582494
  584031
  586021
  588668
  590314
  594251
  604105
  614759
  622160
  623964
  638507
  645835
  647957
  656124
  662812
  663228
  663337
  663339
  663529
  665450
  669655
  675513
  690855
  693041
  696108
  713504
  714622
  715877
  720195
  720610
  730744
  745123
  748371
  751025
  760549
  771326
  790025
  792796
  797096
  801175
  802715
  809907
  810305
  813547
  813820
  814484
  815930
  817347
  817964
  819244
  819671
  819805
  821033
  823789
  824771
  825351
  825454
  825461
  825991
  826209
  826244
  826322
  827219
  827298
  827377
  827507
]
13.33 ms
(5.37%)
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
  565575
  690855
  647957
  696108
  693041
  552642
  590314
  622160
  638507
  623964
  586021
  588668
  801175
  792796
  802715
  810305
  730744
  745123
  771326
  748371
  760549
  604105
  614759
  713504
  714622
  715877
  720195
  797096
  531852
  720610
  790025
  751025
  809907
  429890
  428570
  594251
  393271
  398077
  813820
  817964
  819671
  824771
  813547
  815930
  817347
  826209
  826244
  826322
  827219
  827298
  827377
  827507
  814484
  819244
  819805
  821033
  823789
  825991
  825454
  825461
  825351
  530394
  531815
  515293
  529741
  537141
  541793
  543600
  543862
  544131
  547515
  548391
  548462
  555769
  558264
  565148
  570134
  571379
  576588
  582494
  542396
  543200
  543546
  544707
  545808
  547411
  550945
  551728
  552019
  555249
  557060
  558657
  561520
  564232
  571114
  575919
  584031
  543258
  543896
  544988
  545878
  547448
  554088
  555779
  556944
  558010
  559420
  568545
  575862
  577610
  645835
  656124
  662812
  663228
  663337
  663339
  663529
  665450
  669655
  675513
]
3.08 ms
(1.24%)
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
  393271
  398077
  428570
  429890
  515293
  529741
  530394
  531815
  531852
  537141
  541793
  542396
  543200
  543258
  543546
  543600
  543862
  543896
  544131
  544707
  544988
  545808
  545878
  547411
  547448
  547515
  548391
  548462
  550945
  551728
  552019
  552642
  554088
  555249
  555769
  555779
  556944
  557060
  558010
  558264
  558657
  559420
  561520
  564232
  565148
  565575
  568545
  570134
  571114
  571379
  575862
  575919
  576588
  577610
  582494
  584031
  586021
  588668
  590314
  594251
  604105
  614759
  622160
  623964
  638507
  645835
  647957
  656124
  662812
  663228
  663337
  663339
  663529
  665450
  669655
  675513
  690855
  693041
  696108
  713504
  714622
  715877
  720195
  720610
  730744
  745123
  748371
  751025
  760549
  771326
  790025
  792796
  797096
  801175
  802715
  809907
  810305
  813547
  813820
  814484
  815930
  817347
  817964
  819244
  819671
  819805
  821033
  823789
  824771
  825351
  825454
  825461
  825991
  826209
  826244
  826322
  827219
  827298
  827377
  827507
]
1.82 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большая большие жоп большая большие дырк"
]
1.82 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big ass gape"
]
1.80 ms
(0.72%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(0.68%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.