GET https://search.jues.net/search/embeds/9?q=pussy%20hole

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.28 ms
(85.69%)
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
  546193
  548301
  548448
  552378
  553221
  554712
  554836
  555615
  556079
  556098
  557218
  557838
  559419
  559420
  561784
  562161
  562575
  563284
  573187
  581366
  583301
  586432
  587691
  588058
  588498
  589626
  590525
  593208
  603138
  609556
  610953
  612978
  617573
  620528
  620581
  623689
  624916
  625027
  625743
  628611
  629638
  629725
  631490
  632501
  632940
  633479
  638467
  641516
  641522
  641604
  643146
  643447
  644713
  649738
  650526
  650538
  653126
  661901
  662812
  663339
  664457
  665450
  666053
  666395
  666602
  669655
  675513
  681538
  682612
  684855
  684888
  684891
  687366
  689930
  692744
  694193
  697301
  697759
  698249
  698252
  698256
  699304
  699383
  700237
  700900
  702318
  703259
  703271
  704990
  705210
  705769
  706013
  707481
  709224
  710280
  711975
  712784
  713159
  713416
  713453
  714190
  719451
  719960
  720026
  720278
  777276
  779302
  783905
  785881
  792237
  796837
  801806
  801816
  801818
  801833
  803032
  803133
  803189
  803478
  804482
]
13.14 ms
(8.45%)
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
  583301
  548301
  548448
  552378
  553221
  556079
  557218
  557838
  559420
  561784
  562575
  573187
  662812
  663339
  665450
  666053
  669655
  675513
  684888
  684891
  694193
  699304
  699383
  700237
  702318
  704990
  707481
  713159
  713453
  719960
  720026
  649738
  650526
  653126
  681538
  682612
  689930
  692744
  697301
  697759
  703259
  703271
  705769
  706013
  710280
  711975
  713416
  720278
  650538
  661901
  664457
  666395
  666602
  684855
  687366
  698249
  698252
  698256
  700900
  705210
  709224
  712784
  714190
  719451
  546193
  554712
  554836
  555615
  556098
  559419
  562161
  563284
  581366
  587691
  588058
  612978
  620581
  625027
  629638
  633479
  641604
  643146
  643447
  586432
  609556
  620528
  623689
  624916
  629725
  588498
  589626
  590525
  593208
  603138
  617573
  628611
  632501
  644713
  610953
  625743
  631490
  632940
  638467
  641516
  641522
  777276
  779302
  783905
  785881
  792237
  796837
  801806
  801816
  801818
  801833
  803032
  803133
  803189
  803478
  804482
]
2.54 ms
(1.63%)
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
  546193
  548301
  548448
  552378
  553221
  554712
  554836
  555615
  556079
  556098
  557218
  557838
  559419
  559420
  561784
  562161
  562575
  563284
  573187
  581366
  583301
  586432
  587691
  588058
  588498
  589626
  590525
  593208
  603138
  609556
  610953
  612978
  617573
  620528
  620581
  623689
  624916
  625027
  625743
  628611
  629638
  629725
  631490
  632501
  632940
  633479
  638467
  641516
  641522
  641604
  643146
  643447
  644713
  649738
  650526
  650538
  653126
  661901
  662812
  663339
  664457
  665450
  666053
  666395
  666602
  669655
  675513
  681538
  682612
  684855
  684888
  684891
  687366
  689930
  692744
  694193
  697301
  697759
  698249
  698252
  698256
  699304
  699383
  700237
  700900
  702318
  703259
  703271
  704990
  705210
  705769
  706013
  707481
  709224
  710280
  711975
  712784
  713159
  713416
  713453
  714190
  719451
  719960
  720026
  720278
  777276
  779302
  783905
  785881
  792237
  796837
  801806
  801816
  801818
  801833
  803032
  803133
  803189
  803478
  804482
]
1.92 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy hole"
]
1.64 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy дырк"
]
1.60 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy дырк"
]

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.