GET https://search.jues.net/search/embeds/10?q=anus%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.15 ms
(82.02%)
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
  6763
  48395
  88942
  140294
  185873
  187919
  261058
  316153
  325804
  325867
  373724
  373859
  382637
  382818
  383164
  384338
  384750
  386793
  390805
  391147
  391170
  391470
  391655
  392391
  396012
  396159
  397977
  398221
  400775
  402239
  402439
  402700
  406471
  413219
  415761
  419452
  419910
  422958
  429114
  434374
  436044
  439565
  439797
  439815
  444795
  445786
  447904
  452284
  459535
  463913
  465606
  469131
  470174
  473909
  474706
  476113
  480207
  493411
  495566
  499383
  500342
  506195
  512928
  514241
  517928
  519317
  522260
  547423
  550684
  555054
  564327
  569260
  570208
  581248
  581806
  584301
  584712
  591187
  592412
  595454
  595847
  599026
  602183
  604205
  607230
  609205
  610616
  616152
  622666
  623716
  633163
  636884
  636925
  676441
  717359
  721911
  723591
  730363
  739794
  745503
  760738
  760924
  760932
  761033
  761053
  761200
  768730
  770282
  778643
  781568
  783073
  788193
  791547
  791725
  794887
  800333
  801300
  817155
  817375
  819053
]
18.56 ms
(11.61%)
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
  469131
  391655
  406471
  415761
  434374
  436044
  391170
  480207
  429114
  476113
  522260
  500342
  499383
  419910
  452284
  495566
  519317
  474706
  595847
  616152
  599026
  721911
  781568
  382818
  325804
  512928
  592412
  623716
  817375
  817155
  794887
  383164
  373859
  717359
  788193
  770282
  396159
  386793
  791547
  761053
  470174
  465606
  316153
  422958
  517928
  506195
  569260
  602183
  622666
  439797
  445786
  439815
  493411
  382637
  760932
  801300
  459535
  547423
  564327
  570208
  581806
  439565
  447904
  550684
  419452
  473909
  463913
  396012
  514241
  444795
  595454
  610616
  607230
  633163
  140294
  398221
  187919
  261058
  373724
  723591
  800333
  783073
  745503
  760924
  761033
  761200
  739794
  730363
  325867
  390805
  392391
  185873
  402700
  48395
  819053
  676441
  636884
  760738
  778643
  397977
  581248
  636925
  791725
  768730
  555054
  609205
  400775
  402439
  384338
  402239
  413219
  88942
  6763
  391470
  384750
  584301
  604205
  391147
  584712
  591187
]
3.41 ms
(2.13%)
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
  6763
  48395
  88942
  140294
  185873
  187919
  261058
  316153
  325804
  325867
  373724
  373859
  382637
  382818
  383164
  384338
  384750
  386793
  390805
  391147
  391170
  391470
  391655
  392391
  396012
  396159
  397977
  398221
  400775
  402239
  402439
  402700
  406471
  413219
  415761
  419452
  419910
  422958
  429114
  434374
  436044
  439565
  439797
  439815
  444795
  445786
  447904
  452284
  459535
  463913
  465606
  469131
  470174
  473909
  474706
  476113
  480207
  493411
  495566
  499383
  500342
  506195
  512928
  514241
  517928
  519317
  522260
  547423
  550684
  555054
  564327
  569260
  570208
  581248
  581806
  584301
  584712
  591187
  592412
  595454
  595847
  599026
  602183
  604205
  607230
  609205
  610616
  616152
  622666
  623716
  633163
  636884
  636925
  676441
  717359
  721911
  723591
  730363
  739794
  745503
  760738
  760924
  760932
  761033
  761053
  761200
  768730
  770282
  778643
  781568
  783073
  788193
  791547
  791725
  794887
  800333
  801300
  817155
  817375
  819053
]
2.00 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anus anal"
]
1.85 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анус анал"
]
1.33 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.