GET https://search.jues.net/search/embeds/3?q=teen%20small%20young

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.87 ms
(85.15%)
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
  399853
  400426
  401120
  403496
  413228
  416185
  417428
  418421
  418484
  418493
  429105
  443729
  451596
  463873
  463954
  465128
  466161
  466987
  472179
  494692
  506445
  519725
  529152
  530632
  537767
  541879
  543720
  544471
  545717
  546200
  551431
  552127
  558033
  558601
  560184
  561833
  563874
  563876
  564000
  565265
  566523
  566807
  569674
  569692
  571468
  571686
  574606
  574870
  575737
  575786
  581687
  597518
  598471
  598553
  598745
  600105
  604425
  604467
  605335
  620300
  622623
  624231
  624273
  624830
  627804
  628363
  634187
  647343
  656575
  668377
  671626
  680182
  681813
  683341
  684541
  687541
  696219
  696978
  701009
  703101
  714432
  714448
  714473
  715228
  720484
  720800
  720825
  721325
  722781
  722897
  723492
  725112
  726292
  731693
  739074
  742422
  744303
  746155
  747956
  753943
  760586
  761076
  762702
  766432
  766990
  767060
  767510
  768120
  775962
  776878
  788800
  805347
  810701
  811669
  811863
  814069
  814554
  818390
  819510
  827610
]
15.92 ms
(9.36%)
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
  805347
  746155
  753943
  624231
  703101
  714432
  714448
  722781
  788800
  811863
  451596
  418493
  575786
  571468
  401120
  413228
  544471
  564000
  681813
  687541
  604425
  624273
  726292
  417428
  541879
  569692
  575737
  627804
  569674
  604467
  624830
  400426
  466987
  472179
  463873
  466161
  494692
  819510
  529152
  537767
  563876
  683341
  701009
  715228
  696978
  720484
  600105
  776878
  731693
  739074
  747956
  761076
  762702
  767510
  744303
  767060
  768120
  760586
  558601
  634187
  766432
  622623
  818390
  545717
  399853
  443729
  530632
  543720
  671626
  696219
  574870
  597518
  598471
  605335
  620300
  810701
  775962
  811669
  725112
  742422
  721325
  416185
  519725
  647343
  680182
  546200
  598745
  628363
  574606
  598553
  418484
  465128
  418421
  463954
  506445
  403496
  566807
  766990
  722897
  723492
  429105
  814554
  827610
  814069
  551431
  561833
  552127
  558033
  565265
  581687
  656575
  684541
  720800
  668377
  714473
  720825
  560184
  563874
  566523
  571686
]
2.60 ms
(1.53%)
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
  399853
  400426
  401120
  403496
  413228
  416185
  417428
  418421
  418484
  418493
  429105
  443729
  451596
  463873
  463954
  465128
  466161
  466987
  472179
  494692
  506445
  519725
  529152
  530632
  537767
  541879
  543720
  544471
  545717
  546200
  551431
  552127
  558033
  558601
  560184
  561833
  563874
  563876
  564000
  565265
  566523
  566807
  569674
  569692
  571468
  571686
  574606
  574870
  575737
  575786
  581687
  597518
  598471
  598553
  598745
  600105
  604425
  604467
  605335
  620300
  622623
  624231
  624273
  624830
  627804
  628363
  634187
  647343
  656575
  668377
  671626
  680182
  681813
  683341
  684541
  687541
  696219
  696978
  701009
  703101
  714432
  714448
  714473
  715228
  720484
  720800
  720825
  721325
  722781
  722897
  723492
  725112
  726292
  731693
  739074
  742422
  744303
  746155
  747956
  753943
  760586
  761076
  762702
  766432
  766990
  767060
  767510
  768120
  775962
  776878
  788800
  805347
  810701
  811669
  811863
  814069
  814554
  818390
  819510
  827610
]
1.92 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen small young"
]
1.79 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen маленькая young"
]
1.47 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen маленькая young"
]

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.