GET https://search.jues.net/search/embeds/4?q=short%20hair%20girl

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
150.35 ms
(87.95%)
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
  31563
  72416
  97598
  105834
  382656
  383016
  398779
  439926
  528472
  531052
  533590
  533620
  541533
  543752
  544257
  544331
  545597
  562561
  573828
  576255
  592539
  605149
  613181
  624152
  642392
  645810
  645889
  651088
  652246
  652990
  653949
  654370
  654772
  654805
  655740
  658019
  658625
  659122
  659594
  659795
  660598
  666453
  670079
  671141
  672278
  672316
  673030
  675028
  683515
  692036
  696526
  698580
  713172
  713289
  715428
  717650
  720214
  721845
  721937
  723046
  725268
  726469
  726850
  726901
  727765
  727941
  729367
  729848
  733436
  735401
  735563
  738469
  740507
  742477
  743200
  743256
  744102
  744803
  744807
  746677
  748434
  749052
  749085
  750885
  751385
  751621
  753381
  754300
  754776
  755888
  757064
  758735
  759503
  760490
  761452
  770319
  771772
  772482
  772875
  773949
  782759
  782781
  783607
  789370
  790458
  790903
  791035
  791113
  791621
  799144
  799160
  799703
  803503
  804766
  811315
  813451
  817013
  819631
  824408
  827530
]
11.74 ms
(6.87%)
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
  743256
  544257
  592539
  382656
  97598
  31563
  398779
  817013
  819631
  827530
  531052
  533620
  543752
  544331
  545597
  654370
  654772
  660598
  666453
  698580
  715428
  717650
  645810
  651088
  652246
  652990
  654805
  658019
  696526
  562561
  790903
  799144
  811315
  813451
  727941
  744807
  753381
  791621
  804766
  735401
  744803
  757064
  772482
  726850
  749052
  751621
  754300
  726469
  733436
  746677
  750885
  727765
  799160
  799703
  105834
  383016
  541533
  645889
  783607
  759503
  791035
  740507
  743200
  758735
  824408
  533590
  713172
  670079
  692036
  613181
  642392
  782781
  726901
  772875
  725268
  773949
  742477
  720214
  723046
  789370
  72416
  605149
  748434
  721845
  439926
  624152
  528472
  576255
  573828
  671141
  683515
  655740
  658625
  659122
  659795
  672316
  673030
  675028
  653949
  659594
  672278
  782759
  729367
  729848
  744102
  749085
  751385
  761452
  790458
  791113
  755888
  770319
  771772
  735563
  738469
  754776
  760490
  713289
  721937
  803503
]
3.03 ms
(1.77%)
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
  31563
  72416
  97598
  105834
  382656
  383016
  398779
  439926
  528472
  531052
  533590
  533620
  541533
  543752
  544257
  544331
  545597
  562561
  573828
  576255
  592539
  605149
  613181
  624152
  642392
  645810
  645889
  651088
  652246
  652990
  653949
  654370
  654772
  654805
  655740
  658019
  658625
  659122
  659594
  659795
  660598
  666453
  670079
  671141
  672278
  672316
  673030
  675028
  683515
  692036
  696526
  698580
  713172
  713289
  715428
  717650
  720214
  721845
  721937
  723046
  725268
  726469
  726850
  726901
  727765
  727941
  729367
  729848
  733436
  735401
  735563
  738469
  740507
  742477
  743200
  743256
  744102
  744803
  744807
  746677
  748434
  749052
  749085
  750885
  751385
  751621
  753381
  754300
  754776
  755888
  757064
  758735
  759503
  760490
  761452
  770319
  771772
  772482
  772875
  773949
  782759
  782781
  783607
  789370
  790458
  790903
  791035
  791113
  791621
  799144
  799160
  799703
  803503
  804766
  811315
  813451
  817013
  819631
  824408
  827530
]
1.69 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "short hair девушк"
]
1.59 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "short hair girl"
]
1.43 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.12 ms
(0.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "short hair девушк"
]

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.