GET https://search.jues.net/search/embeds/4?q=girls%20cute

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.52 ms
(82.92%)
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
  4451
  12546
  22843
  29374
  322900
  383096
  408989
  410299
  426670
  454896
  459665
  469400
  533078
  536208
  552437
  558082
  558673
  567836
  568211
  584387
  584664
  585937
  595548
  595971
  599091
  606828
  609891
  615994
  616536
  617729
  620181
  630286
  630478
  632284
  638014
  650723
  651801
  655841
  656982
  658192
  661902
  666996
  667084
  669930
  673437
  676734
  678772
  690424
  691422
  694131
  696472
  699552
  702319
  707093
  709495
  712273
  715171
  719814
  720205
  722237
  722854
  730830
  735985
  736278
  740366
  743272
  744758
  746650
  748983
  749513
  749518
  750328
  751266
  751270
  753663
  755892
  756047
  758740
  759171
  762472
  763189
  764296
  767313
  767555
  769199
  772076
  774944
  776982
  778506
  778682
  778822
  779543
  779623
  779952
  782578
  782985
  783637
  784214
  784230
  787026
  787707
  791586
  791669
  798890
  801664
  803640
  809943
  810164
  810182
  810463
  812456
  814098
  817994
  819794
  823352
  824204
  825546
  827341
]
14.84 ms
(10.30%)
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
  776982
  779623
  782578
  782985
  784230
  810182
  408989
  459665
  426670
  558673
  743272
  595548
  599091
  809943
  749513
  749518
  410299
  469400
  558082
  552437
  702319
  715171
  694131
  722237
  630478
  617729
  735985
  758740
  803640
  740366
  755892
  744758
  750328
  383096
  22843
  12546
  819794
  824204
  825546
  536208
  584664
  655841
  691422
  661902
  667084
  673437
  676734
  719814
  656982
  669930
  595971
  616536
  630286
  620181
  778506
  778682
  798890
  769199
  730830
  751266
  759171
  767555
  753663
  746650
  772076
  751270
  767313
  774944
  784214
  791586
  810164
  810463
  454896
  322900
  4451
  814098
  817994
  823352
  827341
  29374
  533078
  568211
  584387
  650723
  651801
  658192
  666996
  696472
  712273
  690424
  720205
  722854
  678772
  699552
  567836
  585937
  609891
  615994
  638014
  606828
  779952
  781201
  787707
  778822
  779543
  791669
  801664
  812456
  767576
  787026
  736278
  748983
  762472
  763189
  756047
  764296
  632284
  707093
  709495
  783637
]
3.16 ms
(2.19%)
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
  4451
  12546
  22843
  29374
  322900
  383096
  408989
  410299
  426670
  454896
  459665
  469400
  533078
  536208
  552437
  558082
  558673
  567836
  568211
  584387
  584664
  585937
  595548
  595971
  599091
  606828
  609891
  615994
  616536
  617729
  620181
  630286
  630478
  632284
  638014
  650723
  651801
  655841
  656982
  658192
  661902
  666996
  667084
  669930
  673437
  676734
  678772
  690424
  691422
  694131
  696472
  699552
  702319
  707093
  709495
  712273
  715171
  719814
  720205
  722237
  722854
  730830
  735985
  736278
  740366
  743272
  744758
  746650
  748983
  749513
  749518
  750328
  751266
  751270
  753663
  755892
  756047
  758740
  759171
  762472
  763189
  764296
  767313
  767555
  769199
  772076
  774944
  776982
  778506
  778682
  778822
  779543
  779623
  779952
  782578
  782985
  783637
  784214
  784230
  787026
  787707
  791586
  791669
  798890
  801664
  803640
  809943
  810164
  810182
  810463
  812456
  814098
  817994
  819794
  823352
  824204
  825546
  827341
]
2.23 ms
(1.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girls cute"
]
1.62 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк cute"
]
1.40 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк cute"
]
1.38 ms
(0.96%)
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.