GET https://search.jues.net/search/embeds/5?q=solo%20hair

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
161.38 ms
(87.59%)
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
  381863
  383080
  383503
  384590
  414229
  417469
  418031
  425843
  428249
  454749
  461252
  469147
  511407
  523126
  531793
  532868
  533075
  535364
  536769
  540584
  543187
  543692
  548813
  549675
  551808
  552779
  558495
  560758
  562493
  566600
  574449
  586086
  593028
  598043
  598867
  601744
  607305
  608456
  627314
  629915
  631439
  634123
  636493
  642396
  646819
  651676
  661054
  675897
  692041
  697339
  700701
  705065
  706422
  713477
  714687
  723205
  723208
  729466
  743610
  753014
  754312
  754445
  754477
  756020
  760649
  766390
  766412
  770088
  772636
  773026
  774198
  777705
  778557
  778636
  780582
  782595
  783266
  783393
  784236
  786614
  786723
  786809
  787019
  788532
  789653
  790425
  791348
  792740
  798770
  802904
  804634
  804761
  806539
  806621
  807854
  807861
  810156
  810616
  810795
  812054
  812110
  812225
  816848
  816859
  819100
  819101
  819226
  821517
  822681
  823321
  824888
  825406
  825626
  825866
  826035
  827453
  827457
  827458
]
12.81 ms
(6.95%)
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
  543187
  566600
  706422
  636493
  598867
  778636
  784236
  729466
  773026
  786723
  792740
  807854
  810156
  812054
  756020
  754445
  627314
  786614
  806621
  807861
  469147
  381863
  414229
  417469
  454749
  425843
  461252
  523126
  418031
  798770
  428249
  511407
  549675
  552779
  560758
  661054
  675897
  595376
  601744
  586086
  810616
  743610
  760649
  802904
  383080
  384590
  383503
  816859
  819100
  819226
  822681
  824888
  825406
  825866
  826035
  819101
  827453
  827458
  816848
  821517
  823321
  825626
  828081
  827457
  532868
  531793
  536769
  533075
  535364
  540584
  543692
  551808
  562493
  548813
  646819
  700701
  705065
  713477
  723208
  651676
  692041
  697339
  723205
  714687
  558495
  574449
  593028
  607305
  634123
  598043
  629915
  642396
  608456
  631439
  780582
  783393
  786809
  788532
  789653
  790425
  791348
  804634
  804761
  810795
  812110
  777705
  778557
  782595
  783266
  806539
  812225
  753014
  754312
  754477
  766390
  766412
  770088
  772636
  774198
  787019
]
2.68 ms
(1.46%)
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
  381863
  383080
  383503
  384590
  414229
  417469
  418031
  425843
  428249
  454749
  461252
  469147
  511407
  523126
  531793
  532868
  533075
  535364
  536769
  540584
  543187
  543692
  548813
  549675
  551808
  552779
  558495
  560758
  562493
  566600
  574449
  586086
  593028
  598043
  598867
  601744
  607305
  608456
  627314
  629915
  631439
  634123
  636493
  642396
  646819
  651676
  661054
  675897
  692041
  697339
  700701
  705065
  706422
  713477
  714687
  723205
  723208
  729466
  743610
  753014
  754312
  754445
  754477
  756020
  760649
  766390
  766412
  770088
  772636
  773026
  774198
  777705
  778557
  778636
  780582
  782595
  783266
  783393
  784236
  786614
  786723
  786809
  787019
  788532
  789653
  790425
  791348
  792740
  798770
  802904
  804634
  804761
  806539
  806621
  807854
  807861
  810156
  810616
  810795
  812054
  812110
  812225
  816848
  816859
  819100
  819101
  819226
  821517
  822681
  823321
  824888
  825406
  825626
  825866
  826035
  827453
  827457
  827458
]
2.17 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo hair"
]
1.80 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло hair"
]
1.75 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "соло hair"
]
1.65 ms
(0.90%)
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.