GET https://search.jues.net/search/embeds/10?q=big%20cock%20brunette

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.93 ms
(86.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
  295200
  311005
  361909
  378272
  383399
  385709
  390334
  396645
  413216
  429809
  457503
  459556
  482661
  485238
  530462
  533553
  535514
  537667
  540795
  541403
  542967
  544321
  547127
  547239
  556257
  558262
  558988
  560254
  563813
  564330
  564875
  566481
  567048
  569818
  575862
  578131
  579089
  581279
  582772
  593466
  597754
  617456
  630767
  641747
  644079
  645884
  651253
  651509
  651591
  652276
  653583
  653727
  664284
  667974
  688319
  689682
  692523
  694851
  695672
  696055
  696238
  700559
  702749
  705232
  705749
  706223
  710192
  711566
  712265
  718946
  719046
  719176
  719253
  724718
  729737
  732014
  732508
  733049
  737573
  738277
  738736
  739884
  745333
  747102
  754549
  757324
  796832
  802597
  810056
  811049
  813767
  814999
  815079
  816266
  816381
  817839
  818248
  818370
  819166
  819754
  820548
  821126
  821165
  821241
  821265
  821740
  822007
  822098
  822670
  822679
  823192
  823985
  824083
  827487
  827689
  827768
  828250
  828569
  828570
]
13.86 ms
(7.27%)
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
  644079
  593466
  597754
  630767
  641747
  729737
  737573
  811049
  732014
  732508
  724718
  738277
  745333
  738736
  739884
  747102
  757324
  702749
  719253
  295200
  578131
  457503
  689682
  530462
  719046
  810056
  719176
  383399
  390334
  821165
  459556
  413216
  385709
  828250
  828570
  828569
  667974
  651253
  664284
  796832
  733049
  754549
  818370
  813767
  396645
  816266
  821126
  537667
  541403
  710192
  696238
  617456
  802597
  311005
  361909
  378272
  429809
  819754
  820548
  822670
  823192
  823985
  540795
  821265
  822007
  827487
  814999
  816381
  817839
  819166
  821740
  822056
  822098
  822679
  824083
  815079
  818248
  821241
  827768
  827689
  485238
  482661
  533553
  535514
  547127
  547239
  564330
  579089
  581279
  542967
  544321
  556257
  558262
  558988
  566481
  567048
  569818
  560254
  563813
  564875
  575862
  582772
  651591
  653727
  688319
  692523
  694851
  695672
  696055
  700559
  705232
  705749
  706223
  711566
  712265
  718946
  645884
  651509
  652276
  653583
]
3.85 ms
(2.02%)
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
  295200
  311005
  361909
  378272
  383399
  385709
  390334
  396645
  413216
  429809
  457503
  459556
  482661
  485238
  530462
  533553
  535514
  537667
  540795
  541403
  542967
  544321
  547127
  547239
  556257
  558262
  558988
  560254
  563813
  564330
  564875
  566481
  567048
  569818
  575862
  578131
  579089
  581279
  582772
  593466
  597754
  617456
  630767
  641747
  644079
  645884
  651253
  651509
  651591
  652276
  653583
  653727
  664284
  667974
  688319
  689682
  692523
  694851
  695672
  696055
  696238
  700559
  702749
  705232
  705749
  706223
  710192
  711566
  712265
  718946
  719046
  719176
  719253
  724718
  729737
  732014
  732508
  733049
  737573
  738277
  738736
  739884
  745333
  747102
  754549
  757324
  796832
  802597
  810056
  811049
  813767
  814999
  815079
  816266
  816381
  817839
  818248
  818370
  819166
  819754
  820548
  821126
  821165
  821241
  821265
  821740
  822007
  822098
  822670
  822679
  823192
  823985
  824083
  827487
  827689
  827768
  828250
  828569
  828570
]
2.14 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие cock черноволосая"
]
2.09 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.96 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие cock черноволосая"
]
1.77 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big cock brunette"
]

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.