GET https://search.jues.net/search/embeds/5?q=pretty%20girls

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.73 ms
(85.28%)
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
  11393
  12449
  31245
  385322
  388858
  396386
  401089
  406072
  413257
  420700
  420864
  428647
  435653
  446121
  451744
  455678
  467322
  468711
  469800
  470188
  473752
  474304
  475108
  477446
  479987
  482122
  483986
  491339
  492906
  494250
  499246
  504402
  520018
  523446
  524023
  525523
  529510
  529943
  555167
  555800
  556172
  556506
  556936
  557629
  560224
  561656
  561658
  561716
  561718
  565589
  567511
  568359
  573506
  575699
  580403
  580519
  582576
  583180
  598923
  600700
  604729
  605331
  605960
  608287
  613465
  615625
  629013
  629779
  638464
  640149
  649470
  649863
  650145
  650447
  650852
  656470
  661339
  673454
  674090
  684140
  687299
  703897
  715754
  716792
  721310
  721837
  722869
  724103
  728041
  753089
  754991
  763447
  764665
  768456
  771375
  776206
  779459
  779775
  781354
  781569
  784167
  784393
  785554
  786715
  787902
  788905
  790634
  791413
  792388
  793173
  794811
  797610
  799212
  799260
  799722
  803600
  809002
  810702
  812105
  815133
]
14.12 ms
(8.81%)
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
  475108
  556172
  650145
  650447
  650852
  629779
  640149
  793173
  794811
  753089
  781569
  799260
  771375
  763447
  728041
  768456
  776206
  791413
  413257
  555800
  608287
  809002
  790634
  784167
  787902
  31245
  494250
  469800
  580519
  649863
  656470
  754991
  446121
  529510
  451744
  649470
  721310
  561718
  629013
  722869
  785554
  810702
  396386
  455678
  468711
  598923
  575699
  605331
  11393
  420864
  557629
  580403
  674090
  687299
  716792
  565589
  613465
  797610
  799212
  524023
  12449
  815133
  520018
  504402
  470188
  556506
  560224
  567511
  661339
  555167
  556936
  605960
  792388
  799722
  474304
  479987
  385322
  499246
  529943
  684140
  715754
  573506
  604729
  638464
  615625
  779459
  779775
  764665
  784393
  724103
  491339
  568359
  583180
  561658
  561656
  561716
  703897
  600700
  803600
  812105
  401089
  525523
  388858
  406072
  467322
  523446
  673454
  582576
  781354
  786715
  721837
  788905
  482122
  420700
  428647
  473752
  477446
  483986
  492906
  435653
]
2.36 ms
(1.47%)
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
  11393
  12449
  31245
  385322
  388858
  396386
  401089
  406072
  413257
  420700
  420864
  428647
  435653
  446121
  451744
  455678
  467322
  468711
  469800
  470188
  473752
  474304
  475108
  477446
  479987
  482122
  483986
  491339
  492906
  494250
  499246
  504402
  520018
  523446
  524023
  525523
  529510
  529943
  555167
  555800
  556172
  556506
  556936
  557629
  560224
  561656
  561658
  561716
  561718
  565589
  567511
  568359
  573506
  575699
  580403
  580519
  582576
  583180
  598923
  600700
  604729
  605331
  605960
  608287
  613465
  615625
  629013
  629779
  638464
  640149
  649470
  649863
  650145
  650447
  650852
  656470
  661339
  673454
  674090
  684140
  687299
  703897
  715754
  716792
  721310
  721837
  722869
  724103
  728041
  753089
  754991
  763447
  764665
  768456
  771375
  776206
  779459
  779775
  781354
  781569
  784167
  784393
  785554
  786715
  787902
  788905
  790634
  791413
  792388
  793173
  794811
  797610
  799212
  799260
  799722
  803600
  809002
  810702
  812105
  815133
]
1.88 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pretty девушк"
]
1.86 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pretty girls"
]
1.80 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pretty девушк"
]
1.59 ms
(0.99%)
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.