GET https://search.jues.net/search/embeds/9?q=love%20big

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.04 ms
(81.66%)
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
  73990
  358603
  398842
  401218
  406645
  410029
  426129
  426315
  433956
  437233
  438181
  447145
  453451
  458210
  460425
  460627
  462065
  462544
  471111
  484446
  488467
  496586
  497498
  499366
  500519
  506353
  512276
  514221
  530442
  550907
  551035
  552292
  559452
  592925
  601341
  608931
  609361
  615243
  625360
  631316
  634702
  640304
  644363
  650374
  653829
  660462
  666180
  667805
  667979
  668698
  669895
  671682
  672897
  681636
  694684
  697738
  698862
  702959
  710127
  711537
  718416
  718461
  721483
  721571
  723355
  725317
  727421
  727513
  727689
  730419
  731695
  733483
  734620
  737863
  740173
  740794
  741877
  742970
  743118
  746135
  748197
  748471
  748709
  748996
  750781
  752437
  755252
  755424
  755659
  757816
  762123
  762429
  764271
  764638
  766239
  766534
  771966
  773621
  784524
  786225
  786353
  790809
  794178
  795306
  797891
  798211
  800719
  801504
  806097
  806700
  806705
  810676
  810974
  811283
  812860
  813625
  817526
  821562
  823526
]
20.06 ms
(12.04%)
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
  667805
  667979
  668698
  669895
  694684
  718461
  625360
  640304
  609361
  786225
  794178
  797891
  806700
  740794
  755659
  766534
  786353
  812860
  734620
  740173
  741877
  750781
  757816
  762123
  727689
  730419
  743118
  748197
  748709
  762429
  766239
  773621
  806097
  806705
  810974
  488467
  821562
  506353
  698862
  681636
  650374
  671682
  702959
  601341
  733483
  748996
  771966
  752437
  460425
  406645
  484446
  358603
  426315
  410029
  817526
  460627
  471111
  530442
  551035
  552292
  721571
  615243
  634702
  608931
  592925
  631316
  784524
  800719
  746135
  731695
  764638
  742970
  447145
  666180
  790809
  810676
  811283
  401218
  514221
  500519
  499366
  462065
  559452
  550907
  718416
  653829
  660462
  795306
  801504
  727421
  727513
  755424
  737863
  738586
  755252
  725317
  764271
  644363
  723355
  458210
  433956
  462544
  497498
  512276
  426129
  813625
  453451
  496586
  672897
  711537
  721483
  697738
  710127
  798211
  748471
  73990
  437233
  398842
  438181
  823526
]
4.16 ms
(2.50%)
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
  73990
  358603
  398842
  401218
  406645
  410029
  426129
  426315
  433956
  437233
  438181
  447145
  453451
  458210
  460425
  460627
  462065
  462544
  471111
  484446
  488467
  496586
  497498
  499366
  500519
  506353
  512276
  514221
  530442
  550907
  551035
  552292
  559452
  592925
  601341
  608931
  609361
  615243
  625360
  631316
  634702
  640304
  644363
  650374
  653829
  660462
  666180
  667805
  667979
  668698
  669895
  671682
  672897
  681636
  694684
  697738
  698862
  702959
  710127
  711537
  718416
  718461
  721483
  721571
  723355
  725317
  727421
  727513
  727689
  730419
  731695
  733483
  734620
  737863
  740173
  740794
  741877
  742970
  743118
  746135
  748197
  748471
  748709
  748996
  750781
  752437
  755252
  755424
  755659
  757816
  762123
  762429
  764271
  764638
  766239
  766534
  771966
  773621
  784524
  786225
  786353
  790809
  794178
  795306
  797891
  798211
  800719
  801504
  806097
  806700
  806705
  810676
  810974
  811283
  812860
  813625
  817526
  821562
  823526
]
1.91 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "love big"
]
1.78 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "love большие"
]
1.26 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "love большие"
]

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.