GET https://search.jues.net/search/embeds/7?q=anal%20first

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.00 ms
(83.09%)
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
  6982
  14369
  385706
  386062
  386271
  391113
  395698
  395746
  399722
  400682
  401280
  405708
  412442
  413707
  417317
  419033
  429457
  431948
  432735
  436437
  439125
  444912
  447441
  456263
  459803
  460697
  461554
  462787
  462804
  462806
  464580
  468085
  475055
  476183
  478492
  488454
  488537
  490823
  491228
  491609
  491947
  496164
  499902
  501534
  508754
  514756
  514794
  520794
  523569
  523761
  531093
  535465
  560611
  561851
  566657
  568756
  571218
  571229
  575798
  579210
  580623
  580631
  583476
  586664
  597264
  598069
  601536
  605322
  615554
  616795
  620711
  633722
  633772
  633776
  634169
  639254
  639804
  641682
  644972
  650192
  650200
  664192
  668527
  674945
  679798
  680164
  680204
  695316
  709589
  718647
  720873
  720911
  724371
  724698
  726847
  731303
  736440
  747136
  749456
  750317
  757549
  759340
  760975
  761578
  771015
  784754
  791604
  791686
  792137
  793901
  805366
  806192
  806325
  815201
  817272
  818377
  820774
  823427
  827971
]
16.60 ms
(10.07%)
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
  566657
  579210
  586664
  615554
  405708
  462806
  412442
  478492
  514794
  523761
  386062
  431948
  817272
  827971
  514756
  680204
  616795
  792137
  736440
  761578
  757549
  771015
  620711
  633722
  709589
  720873
  720911
  6982
  806192
  749456
  826228
  499902
  580623
  568756
  580631
  436437
  460697
  386271
  395746
  401280
  429457
  432735
  413707
  644972
  488454
  491228
  468085
  491609
  531093
  523569
  535465
  575798
  571218
  571229
  650192
  650200
  679798
  664192
  668527
  674945
  680164
  695316
  718647
  560611
  561851
  598069
  634169
  641682
  597264
  633772
  633776
  639804
  605322
  639254
  791686
  793901
  805366
  759340
  784754
  791604
  806325
  726847
  750317
  724371
  724698
  731303
  747136
  760975
  601536
  391113
  400682
  444912
  462804
  439125
  462787
  14369
  399722
  447441
  456263
  459803
  461554
  417317
  419033
  464580
  490823
  491947
  501534
  488537
  496164
  508754
  520794
  385706
  395698
  815201
  818377
  820774
  823427
  476183
  475055
  583476
]
3.06 ms
(1.86%)
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
  6982
  14369
  385706
  386062
  386271
  391113
  395698
  395746
  399722
  400682
  401280
  405708
  412442
  413707
  417317
  419033
  429457
  431948
  432735
  436437
  439125
  444912
  447441
  456263
  459803
  460697
  461554
  462787
  462804
  462806
  464580
  468085
  475055
  476183
  478492
  488454
  488537
  490823
  491228
  491609
  491947
  496164
  499902
  501534
  508754
  514756
  514794
  520794
  523569
  523761
  531093
  535465
  560611
  561851
  566657
  568756
  571218
  571229
  575798
  579210
  580623
  580631
  583476
  586664
  597264
  598069
  601536
  605322
  615554
  616795
  620711
  633722
  633772
  633776
  634169
  639254
  639804
  641682
  644972
  650192
  650200
  664192
  668527
  674945
  679798
  680164
  680204
  695316
  709589
  718647
  720873
  720911
  724371
  724698
  726847
  731303
  736440
  747136
  749456
  750317
  757549
  759340
  760975
  761578
  771015
  784754
  791604
  791686
  792137
  793901
  805366
  806192
  806325
  815201
  817272
  818377
  820774
  823427
  827971
]
2.70 ms
(1.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал first"
]
1.94 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал first"
]
1.86 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal first"
]
1.71 ms
(1.04%)
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.