GET https://search.jues.net/search/embeds/10?q=fuck%20licking

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
173.63 ms
(88.12%)
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
  12405
  68945
  73571
  129246
  140007
  209941
  233112
  380621
  381749
  382606
  383111
  384796
  386206
  386514
  386871
  400348
  404211
  420303
  426784
  437363
  502043
  561775
  592428
  593832
  599595
  606260
  613055
  617377
  625208
  626520
  651617
  663415
  672092
  681246
  695638
  700921
  719047
  719108
  721775
  728506
  729013
  729253
  729587
  733126
  734283
  734417
  736999
  737371
  741143
  742938
  744225
  744821
  747133
  753278
  753299
  753303
  753381
  753405
  753861
  755289
  757284
  759880
  765444
  770464
  772430
  772560
  774077
  775587
  775627
  775647
  777036
  779509
  780316
  780627
  781971
  782773
  784258
  788688
  788877
  788957
  791841
  792003
  792245
  792657
  793546
  793808
  794459
  794488
  795004
  797962
  798109
  799728
  800008
  800758
  802349
  804130
  804233
  805315
  807954
  808038
  808642
  810586
  811004
  811460
  811989
  812119
  812316
  813475
  819143
  819823
  820041
  820141
  823487
  823598
  823842
  824125
  825125
  825227
  825803
  826987
]
12.84 ms
(6.52%)
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
  721775
  626520
  775627
  799728
  808642
  812119
  788688
  800758
  808038
  741143
  788957
  792003
  797962
  804130
  811989
  759880
  744225
  765444
  729253
  736999
  775647
  502043
  593832
  613055
  380621
  400348
  420303
  819823
  663415
  672092
  681246
  592428
  792657
  805315
  777036
  782773
  737371
  757284
  794459
  795004
  811004
  812316
  729013
  729587
  734283
  744821
  728506
  733126
  772430
  770464
  426784
  233112
  140007
  381749
  12405
  437363
  820141
  820041
  561775
  606260
  788877
  775587
  794488
  804233
  734417
  772560
  792245
  798109
  811460
  625208
  780316
  800008
  209941
  382606
  753861
  383111
  384796
  129246
  807954
  753278
  774077
  747133
  386871
  386514
  68945
  823487
  695638
  651617
  700921
  719108
  617377
  599595
  780627
  779509
  784258
  793808
  813475
  742938
  753381
  793546
  802349
  810586
  753299
  753303
  755289
  753405
  719047
  781971
  791841
  73571
  404211
  386206
  823598
  823842
  825125
  825227
  825803
  826987
  819143
  824125
]
3.23 ms
(1.64%)
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
  12405
  68945
  73571
  129246
  140007
  209941
  233112
  380621
  381749
  382606
  383111
  384796
  386206
  386514
  386871
  400348
  404211
  420303
  426784
  437363
  502043
  561775
  592428
  593832
  599595
  606260
  613055
  617377
  625208
  626520
  651617
  663415
  672092
  681246
  695638
  700921
  719047
  719108
  721775
  728506
  729013
  729253
  729587
  733126
  734283
  734417
  736999
  737371
  741143
  742938
  744225
  744821
  747133
  753278
  753299
  753303
  753381
  753405
  753861
  755289
  757284
  759880
  765444
  770464
  772430
  772560
  774077
  775587
  775627
  775647
  777036
  779509
  780316
  780627
  781971
  782773
  784258
  788688
  788877
  788957
  791841
  792003
  792245
  792657
  793546
  793808
  794459
  794488
  795004
  797962
  798109
  799728
  800008
  800758
  802349
  804130
  804233
  805315
  807954
  808038
  808642
  810586
  811004
  811460
  811989
  812119
  812316
  813475
  819143
  819823
  820041
  820141
  823487
  823598
  823842
  824125
  825125
  825227
  825803
  826987
]
2.43 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fuck licking"
]
2.02 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс лиза"
]
1.51 ms
(0.77%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.37 ms
(0.69%)
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.