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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.41 ms
(85.17%)
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
  13373
  54387
  385291
  385380
  401966
  406168
  410651
  411896
  414222
  415404
  416152
  418531
  420301
  426197
  427221
  428828
  429250
  430490
  434113
  434128
  435658
  447469
  448704
  454824
  456235
  456907
  457393
  458592
  458609
  464212
  464646
  464904
  466465
  466614
  468691
  474688
  482366
  487711
  488747
  494072
  501253
  510403
  510669
  513267
  513989
  514747
  519482
  521186
  521464
  523923
  526109
  526896
  527491
  527496
  528293
  528998
  529030
  533760
  535057
  536689
  538192
  540273
  540677
  551574
  565341
  566903
  567184
  568370
  580712
  591965
  601309
  605345
  607572
  613485
  615593
  621516
  633638
  633780
  636980
  637043
  643436
  644069
  662963
  667289
  668182
  668986
  671276
  673149
  675672
  678984
  689354
  700620
  702176
  705365
  705586
  716278
  716878
  717912
  718651
  720715
  724771
  726833
  727758
  727765
  728773
  731862
  733401
  739789
  742045
  744211
  745196
  749743
  750236
  754212
  755412
  758911
  758971
  772078
  793855
  810233
]
17.12 ms
(9.44%)
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
  401966
  464646
  428828
  466465
  529030
  514747
  494072
  535057
  519482
  488747
  565341
  700620
  758911
  755412
  705365
  468691
  429250
  454824
  510403
  540677
  528998
  540273
  513989
  523923
  551574
  566903
  668986
  673149
  613485
  601309
  406168
  474688
  526896
  414222
  435658
  458609
  580712
  464904
  482366
  415404
  742045
  720715
  13373
  456235
  621516
  430490
  567184
  662963
  526109
  527496
  538192
  667289
  689354
  668182
  678984
  671276
  702176
  607572
  644069
  643436
  633638
  744211
  724771
  726833
  728773
  733401
  745196
  727758
  727765
  749743
  705586
  418531
  456907
  528293
  536689
  716878
  633780
  410651
  416152
  434128
  457393
  510669
  466614
  636980
  615593
  810233
  54387
  411896
  434113
  385380
  527491
  718651
  385291
  754212
  772078
  427221
  420301
  447469
  448704
  464212
  568370
  513267
  458592
  521186
  487711
  521464
  731862
  426197
  637043
  675672
  716278
  591965
  750236
  793855
  758971
  717912
  739789
  501253
  533760
  605345
]
2.51 ms
(1.39%)
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
  13373
  54387
  385291
  385380
  401966
  406168
  410651
  411896
  414222
  415404
  416152
  418531
  420301
  426197
  427221
  428828
  429250
  430490
  434113
  434128
  435658
  447469
  448704
  454824
  456235
  456907
  457393
  458592
  458609
  464212
  464646
  464904
  466465
  466614
  468691
  474688
  482366
  487711
  488747
  494072
  501253
  510403
  510669
  513267
  513989
  514747
  519482
  521186
  521464
  523923
  526109
  526896
  527491
  527496
  528293
  528998
  529030
  533760
  535057
  536689
  538192
  540273
  540677
  551574
  565341
  566903
  567184
  568370
  580712
  591965
  601309
  605345
  607572
  613485
  615593
  621516
  633638
  633780
  636980
  637043
  643436
  644069
  662963
  667289
  668182
  668986
  671276
  673149
  675672
  678984
  689354
  700620
  702176
  705365
  705586
  716278
  716878
  717912
  718651
  720715
  724771
  726833
  727758
  727765
  728773
  731862
  733401
  739789
  742045
  744211
  745196
  749743
  750236
  754212
  755412
  758911
  758971
  772078
  793855
  810233
]
1.92 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "casting big ass"
]
1.83 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "кастинг большая большие жоп"
]
1.75 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.