GET https://search.jues.net/search/embeds/3?q=your%20mom

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.62 ms
(82.97%)
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
  403109
  413456
  413459
  413472
  414162
  414788
  426657
  432852
  442695
  457490
  460181
  461631
  464416
  466646
  471609
  473410
  477871
  481328
  481815
  482243
  489127
  493115
  497517
  508595
  509378
  509712
  510953
  514390
  514883
  515624
  519413
  525160
  532061
  533965
  539816
  542369
  546912
  546922
  548844
  554979
  556832
  557557
  563009
  568991
  570710
  572286
  582265
  587158
  591167
  593382
  595992
  596927
  600398
  601054
  605607
  606733
  608595
  612867
  632766
  634269
  636468
  637512
  637758
  639152
  648776
  653475
  667880
  669893
  673056
  681446
  696415
  697143
  699607
  713718
  717669
  720743
  721112
  730494
  746615
  758079
  758587
  770954
  771823
  772051
  772093
  774691
  775535
  776586
  776731
  779566
  781792
  784776
  788875
  788946
  789594
  789733
  789968
  790744
  791592
  797675
  802547
  804455
  806556
  807508
  809064
  809070
  809075
  809085
  809354
  809369
  809482
  810804
  811337
  811500
  812564
  812593
  815099
  815117
  818519
  818532
]
19.46 ms
(11.48%)
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
  533965
  413459
  432852
  413456
  413472
  815099
  815117
  818519
  818532
  539816
  572286
  546912
  546922
  681446
  696415
  699607
  648776
  653475
  697143
  720743
  669893
  673056
  554979
  587158
  600398
  601054
  636468
  632766
  634269
  595992
  605607
  612867
  608595
  774691
  775535
  779566
  788875
  790744
  807508
  812593
  776586
  789594
  789733
  809070
  809085
  809354
  746615
  791592
  802547
  804455
  806556
  811500
  771823
  730494
  758587
  770954
  606733
  637758
  717669
  721112
  788946
  797675
  809369
  473410
  481328
  426657
  481815
  414788
  493115
  510953
  514883
  525160
  482243
  457490
  403109
  460181
  461631
  466646
  489127
  532061
  514390
  568991
  542369
  548844
  556832
  570710
  582265
  557557
  563009
  667880
  713718
  591167
  593382
  637512
  596927
  781792
  784776
  809064
  809075
  811337
  776731
  809482
  812564
  789968
  810804
  772093
  772051
  758079
  639152
  442695
  464416
  471609
  414162
  477871
  508595
  509378
  497517
  515624
  519413
  509712
]
2.93 ms
(1.73%)
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
  403109
  413456
  413459
  413472
  414162
  414788
  426657
  432852
  442695
  457490
  460181
  461631
  464416
  466646
  471609
  473410
  477871
  481328
  481815
  482243
  489127
  493115
  497517
  508595
  509378
  509712
  510953
  514390
  514883
  515624
  519413
  525160
  532061
  533965
  539816
  542369
  546912
  546922
  548844
  554979
  556832
  557557
  563009
  568991
  570710
  572286
  582265
  587158
  591167
  593382
  595992
  596927
  600398
  601054
  605607
  606733
  608595
  612867
  632766
  634269
  636468
  637512
  637758
  639152
  648776
  653475
  667880
  669893
  673056
  681446
  696415
  697143
  699607
  713718
  717669
  720743
  721112
  730494
  746615
  758079
  758587
  770954
  771823
  772051
  772093
  774691
  775535
  776586
  776731
  779566
  781792
  784776
  788875
  788946
  789594
  789733
  789968
  790744
  791592
  797675
  802547
  804455
  806556
  807508
  809064
  809070
  809075
  809085
  809354
  809369
  809482
  810804
  811337
  811500
  812564
  812593
  815099
  815117
  818519
  818532
]
1.89 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "your mom"
]
1.61 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "your mom"
]
1.52 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "your mom"
]
1.45 ms
(0.86%)
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.