GET https://search.jues.net/search/embeds/8?q=homemade%20big

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
170.15 ms
(87.45%)
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
  247538
  405832
  426256
  461636
  462590
  475655
  480744
  485389
  489071
  504044
  507269
  512371
  514691
  518919
  529868
  530614
  533405
  533424
  533766
  536190
  536821
  537506
  537650
  538167
  538170
  539345
  539637
  540500
  541187
  543586
  544974
  547037
  548473
  549483
  552149
  555528
  556564
  558157
  562704
  563997
  564032
  567114
  567200
  571157
  573177
  574992
  575980
  577273
  584080
  591704
  599521
  601590
  603374
  604922
  604926
  607481
  613040
  613527
  617388
  620047
  620185
  622841
  623331
  623951
  623961
  627218
  628035
  628523
  629843
  631708
  632311
  634645
  634691
  638186
  639578
  639888
  646165
  650446
  651805
  652310
  653087
  653135
  653963
  658539
  663824
  663844
  664252
  665939
  671694
  671696
  675880
  680530
  681939
  685317
  697483
  700733
  706597
  709242
  712120
  715439
  716549
  722959
  723082
  733924
  733930
  736008
  736104
  743508
  743634
  745857
  746453
  748605
  756369
  759680
  761956
  763586
  764128
  778300
  790476
  813851
]
13.46 ms
(6.92%)
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
  539345
  567200
  629843
  623961
  426256
  536821
  544974
  552149
  555528
  575980
  549483
  650446
  653087
  671694
  671696
  680530
  653135
  646165
  709242
  547037
  562704
  601590
  604922
  623951
  634691
  603374
  613040
  613527
  639888
  604926
  631708
  639578
  759680
  541187
  564032
  573177
  577273
  518919
  540500
  475655
  743634
  778300
  736104
  733930
  743508
  745857
  764128
  716549
  538167
  681939
  628035
  663824
  485389
  533405
  571157
  652310
  653963
  665939
  697483
  627218
  617388
  623331
  462590
  539637
  685317
  622841
  706597
  599521
  620185
  507269
  489071
  504044
  514691
  512371
  574992
  651805
  675880
  620047
  591704
  543586
  658539
  700733
  607481
  632311
  638186
  663844
  664252
  628523
  813851
  733924
  790476
  756369
  634645
  247538
  538170
  746453
  584080
  405832
  567114
  558157
  712120
  748605
  736008
  761956
  722959
  723082
  480744
  763586
  715439
  461636
  537650
  533766
  537506
  529868
  536190
  530614
  533424
  548473
  556564
  563997
]
3.49 ms
(1.80%)
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
  247538
  405832
  426256
  461636
  462590
  475655
  480744
  485389
  489071
  504044
  507269
  512371
  514691
  518919
  529868
  530614
  533405
  533424
  533766
  536190
  536821
  537506
  537650
  538167
  538170
  539345
  539637
  540500
  541187
  543586
  544974
  547037
  548473
  549483
  552149
  555528
  556564
  558157
  562704
  563997
  564032
  567114
  567200
  571157
  573177
  574992
  575980
  577273
  584080
  591704
  599521
  601590
  603374
  604922
  604926
  607481
  613040
  613527
  617388
  620047
  620185
  622841
  623331
  623951
  623961
  627218
  628035
  628523
  629843
  631708
  632311
  634645
  634691
  638186
  639578
  639888
  646165
  650446
  651805
  652310
  653087
  653135
  653963
  658539
  663824
  663844
  664252
  665939
  671694
  671696
  675880
  680530
  681939
  685317
  697483
  700733
  706597
  709242
  712120
  715439
  716549
  722959
  723082
  733924
  733930
  736008
  736104
  743508
  743634
  745857
  746453
  748605
  756369
  759680
  761956
  763586
  764128
  778300
  790476
  813851
]
2.26 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade big"
]
2.09 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск большие"
]
1.68 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.74%)
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.