GET https://search.jues.net/search/embeds/8?q=gape%20mature

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.26 ms
(86.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
  88614
  340567
  474266
  478006
  485156
  492658
  493743
  506257
  509432
  513672
  516140
  517272
  524986
  529658
  531757
  531836
  533779
  537171
  537476
  537667
  538749
  541790
  543714
  545043
  545225
  546147
  546409
  548116
  548389
  554487
  554843
  555016
  555077
  555288
  555307
  555312
  555359
  558718
  559292
  560913
  563685
  564281
  568261
  576985
  583460
  586407
  588202
  588393
  593052
  593184
  601930
  604562
  604880
  610006
  614192
  615693
  619656
  625738
  642065
  662914
  665835
  668561
  692265
  692701
  711728
  714694
  719389
  719890
  720571
  723659
  726322
  729228
  729290
  731758
  735910
  736036
  739180
  743934
  748463
  749234
  752668
  757438
  766599
  766698
  768348
  770149
  775693
  780682
  780691
  781485
  783368
  783374
  784358
  788185
  790845
  792804
  794241
  794859
  794914
  797359
  797785
  797969
  798999
  799027
  801917
  802365
  802372
  804030
  804208
  804215
  809339
  810069
  810332
  811691
  815162
  815171
  817765
  819253
  825140
  827431
]
14.20 ms
(8.26%)
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
  610006
  586407
  588202
  642065
  784358
  748463
  797785
  801917
  804208
  810069
  749234
  735910
  770149
  604562
  615693
  799027
  804215
  478006
  492658
  516140
  493743
  513672
  517272
  555016
  524986
  509432
  555077
  555359
  558718
  555288
  692265
  619656
  614192
  601930
  781485
  804030
  766698
  736036
  546147
  554487
  593052
  802372
  743934
  568261
  340567
  88614
  819253
  723659
  827431
  815162
  817765
  815171
  825140
  474266
  485156
  529658
  537667
  531757
  533779
  537171
  506257
  537476
  538749
  531836
  541790
  543714
  548116
  548389
  559292
  564281
  545225
  546409
  583460
  560913
  563685
  668561
  692701
  711728
  662914
  665835
  714694
  719389
  719890
  545043
  554843
  555307
  555312
  576985
  588393
  593184
  604880
  780682
  780691
  794859
  810332
  811691
  775693
  788185
  792804
  794914
  797969
  802365
  809339
  729290
  752668
  783368
  790845
  794241
  797359
  798999
  766599
  729228
  731758
  739180
  726322
  757438
  768348
  625738
  720571
  783374
]
3.16 ms
(1.84%)
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
  88614
  340567
  474266
  478006
  485156
  492658
  493743
  506257
  509432
  513672
  516140
  517272
  524986
  529658
  531757
  531836
  533779
  537171
  537476
  537667
  538749
  541790
  543714
  545043
  545225
  546147
  546409
  548116
  548389
  554487
  554843
  555016
  555077
  555288
  555307
  555312
  555359
  558718
  559292
  560913
  563685
  564281
  568261
  576985
  583460
  586407
  588202
  588393
  593052
  593184
  601930
  604562
  604880
  610006
  614192
  615693
  619656
  625738
  642065
  662914
  665835
  668561
  692265
  692701
  711728
  714694
  719389
  719890
  720571
  723659
  726322
  729228
  729290
  731758
  735910
  736036
  739180
  743934
  748463
  749234
  752668
  757438
  766599
  766698
  768348
  770149
  775693
  780682
  780691
  781485
  783368
  783374
  784358
  788185
  790845
  792804
  794241
  794859
  794914
  797359
  797785
  797969
  798999
  799027
  801917
  802365
  802372
  804030
  804208
  804215
  809339
  810069
  810332
  811691
  815162
  815171
  817765
  819253
  825140
  827431
]
1.75 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие дырк mature"
]
1.69 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "gape mature"
]
1.39 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большая большие дырк mature"
]
1.36 ms
(0.79%)
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.