GET https://search.jues.net/search/embeds/3?q=white%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.03 ms
(82.47%)
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
  6651
  7015
  103889
  150507
  151564
  188293
  346082
  373905
  383625
  386949
  388466
  389527
  391590
  396011
  396206
  396627
  396645
  397095
  397934
  398257
  398446
  398988
  399924
  400004
  400026
  401146
  401267
  403081
  403397
  410062
  411119
  413125
  415313
  424617
  425301
  434702
  443872
  447527
  447970
  448524
  450104
  458138
  460217
  463868
  465542
  468345
  468399
  470903
  473847
  476725
  478256
  480718
  481618
  483903
  486218
  487205
  495882
  499179
  505758
  509223
  510303
  513195
  518624
  519332
  520844
  522043
  527628
  531331
  531757
  533986
  537476
  538272
  539275
  539283
  540844
  542250
  542573
  544310
  544326
  544369
  547405
  547433
  552642
  560953
  563945
  576142
  578325
  581467
  583960
  584346
  587185
  660384
  669034
  672105
  710686
  712717
  719940
  720085
  726258
  728430
  735017
  738000
  739910
  747523
  747749
  750295
  750298
  754192
  757031
  758502
  760913
  761695
  762976
  763839
  771572
  808317
  818924
  822709
  823972
  828849
]
14.86 ms
(10.29%)
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
  581467
  544326
  547433
  563945
  578325
  584346
  660384
  710686
  712717
  720085
  672105
  547405
  552642
  560953
  576142
  754192
  761695
  760913
  738000
  757031
  747523
  750298
  762976
  771572
  728430
  763839
  151564
  346082
  399924
  527628
  513195
  499179
  539275
  468399
  505758
  480718
  443872
  509223
  391590
  103889
  398988
  403081
  424617
  478256
  447970
  448524
  481618
  487205
  520844
  510303
  544310
  758502
  750295
  735017
  396206
  400026
  447527
  450104
  473847
  397095
  410062
  411119
  458138
  519332
  434702
  470903
  583960
  522043
  383625
  7015
  389527
  396645
  398257
  401146
  403397
  818924
  460217
  463868
  468345
  531757
  537476
  495882
  539283
  486218
  542573
  544369
  669034
  739910
  747749
  719940
  373905
  188293
  401267
  413125
  587185
  823972
  828849
  531331
  533986
  538272
  542250
  808317
  726258
  388466
  476725
  483903
  518624
  150507
  396011
  6651
  386949
  396627
  398446
  397934
  400004
  415313
  425301
  540844
  822709
  465542
]
2.62 ms
(1.82%)
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
  6651
  7015
  103889
  150507
  151564
  188293
  346082
  373905
  383625
  386949
  388466
  389527
  391590
  396011
  396206
  396627
  396645
  397095
  397934
  398257
  398446
  398988
  399924
  400004
  400026
  401146
  401267
  403081
  403397
  410062
  411119
  413125
  415313
  424617
  425301
  434702
  443872
  447527
  447970
  448524
  450104
  458138
  460217
  463868
  465542
  468345
  468399
  470903
  473847
  476725
  478256
  480718
  481618
  483903
  486218
  487205
  495882
  499179
  505758
  509223
  510303
  513195
  518624
  519332
  520844
  522043
  527628
  531331
  531757
  533986
  537476
  538272
  539275
  539283
  540844
  542250
  542573
  544310
  544326
  544369
  547405
  547433
  552642
  560953
  563945
  576142
  578325
  581467
  583960
  584346
  587185
  660384
  669034
  672105
  710686
  712717
  719940
  720085
  726258
  728430
  735017
  738000
  739910
  747523
  747749
  750295
  750298
  754192
  757031
  758502
  760913
  761695
  762976
  763839
  771572
  808317
  818924
  822709
  823972
  828849
]
2.14 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "white anal"
]
2.03 ms
(1.40%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "white анал"
]
1.82 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "white анал"
]

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.