GET https://search.jues.net/search/embeds/3?q=long%20big%20dick

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.82 ms
(85.72%)
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
  55910
  106185
  397371
  418297
  426028
  434057
  436335
  437243
  446358
  446461
  449508
  449911
  450123
  452647
  458996
  460686
  461835
  464779
  465043
  465174
  465508
  465614
  468426
  470086
  470269
  471173
  473562
  477751
  481153
  486518
  486520
  493201
  499169
  499890
  500227
  502035
  504210
  504820
  508282
  510399
  510628
  511187
  511435
  513561
  514864
  516915
  521440
  524468
  527068
  529947
  533039
  533271
  533492
  535875
  537009
  537502
  537667
  537798
  538456
  539230
  539677
  540695
  542640
  542695
  543351
  544269
  553496
  557933
  561265
  567360
  584690
  590046
  620750
  621505
  632394
  635219
  639445
  647040
  658413
  658656
  665989
  690922
  693025
  694634
  711528
  718741
  719856
  722141
  730306
  730625
  734047
  737733
  738241
  740447
  745430
  746795
  750396
  761626
  762623
  775636
  778274
  779448
  786744
  789126
  803065
  806343
  807647
  807794
  807987
  813939
  814241
  815376
  818900
  821515
  823403
  826470
  828462
  828685
]
14.59 ms
(8.19%)
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
  538456
  537009
  658413
  694634
  718741
  639445
  775636
  762623
  803065
  807794
  750396
  711528
  465614
  553496
  502035
  693025
  730306
  106185
  486520
  533271
  542640
  543351
  511435
  473562
  761626
  584690
  635219
  437243
  449508
  465508
  786744
  450123
  529947
  465043
  567360
  745430
  464779
  521440
  499169
  504820
  590046
  807987
  397371
  510628
  510399
  460686
  465174
  449911
  470086
  493201
  504210
  527068
  533039
  557933
  734047
  418297
  470269
  471173
  516915
  500227
  508282
  511187
  826470
  828685
  807647
  826081
  828462
  730625
  822795
  535875
  533492
  544269
  621505
  458996
  446461
  513561
  524468
  452647
  481153
  814241
  813939
  539677
  540695
  690922
  647040
  665989
  722141
  719856
  778274
  779448
  806343
  789126
  620750
  632394
  499890
  426028
  823403
  468426
  477751
  486518
  537798
  434057
  436335
  514864
  818900
  821515
  446358
  537667
  539230
  542695
  561265
  658656
  738241
  737733
  55910
  461835
  740447
  746795
  815376
  537502
]
2.78 ms
(1.56%)
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
  55910
  106185
  397371
  418297
  426028
  434057
  436335
  437243
  446358
  446461
  449508
  449911
  450123
  452647
  458996
  460686
  461835
  464779
  465043
  465174
  465508
  465614
  468426
  470086
  470269
  471173
  473562
  477751
  481153
  486518
  486520
  493201
  499169
  499890
  500227
  502035
  504210
  504820
  508282
  510399
  510628
  511187
  511435
  513561
  514864
  516915
  521440
  524468
  527068
  529947
  533039
  533271
  533492
  535875
  537009
  537502
  537667
  537798
  538456
  539230
  539677
  540695
  542640
  542695
  543351
  544269
  553496
  557933
  561265
  567360
  584690
  590046
  620750
  621505
  632394
  635219
  639445
  647040
  658413
  658656
  665989
  690922
  693025
  694634
  711528
  718741
  719856
  722141
  730306
  730625
  734047
  737733
  738241
  740447
  745430
  746795
  750396
  761626
  762623
  775636
  778274
  779448
  786744
  789126
  803065
  806343
  807647
  807794
  807987
  813939
  814241
  815376
  818900
  821515
  823403
  826470
  828462
  828685
]
2.41 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "long big dick"
]
2.11 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "длинные большой большие член"
]
1.81 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(0.98%)
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.