GET https://search.jues.net/search/embeds/4?q=doggy%20girl

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.94 ms
(84.89%)
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
  12148
  382449
  382501
  384258
  385738
  387656
  391567
  392721
  396821
  405444
  413356
  424287
  441211
  448734
  451717
  452662
  483847
  485637
  487646
  495439
  498648
  499411
  501541
  503394
  511241
  522190
  535958
  538448
  539669
  539784
  541086
  541952
  542145
  546477
  554868
  578135
  579072
  579570
  582706
  590108
  597891
  600537
  602111
  603564
  608488
  609516
  613442
  616530
  623036
  624592
  632868
  638718
  639124
  641339
  647134
  650029
  650649
  653326
  655201
  655492
  657156
  657642
  658162
  659041
  660460
  661769
  662638
  663883
  684725
  687310
  687949
  688393
  688458
  688474
  689534
  705647
  709340
  709553
  711749
  719772
  721260
  727844
  727874
  730135
  733786
  734828
  738751
  742345
  747065
  747507
  748669
  750756
  752057
  754635
  760334
  762094
  764464
  765353
  765955
  768576
  768599
  778272
  778432
  778771
  778783
  779161
  779659
  783884
  792329
  792406
  794330
  794620
  795186
  796003
  799825
  802366
  805091
  813738
  813888
  825574
]
15.47 ms
(9.06%)
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
  778783
  794620
  762094
  752057
  764464
  768576
  765955
  778771
  661769
  663883
  687310
  600537
  727874
  387656
  487646
  539669
  503394
  499411
  542145
  554868
  541086
  579072
  662638
  657642
  608488
  747507
  709340
  711749
  451717
  392721
  391567
  535958
  655492
  650029
  709553
  638718
  783884
  802366
  12148
  495439
  825574
  384258
  441211
  424287
  813888
  511241
  539784
  579570
  582706
  689534
  609516
  624592
  641339
  778272
  742345
  734828
  754635
  452662
  405444
  522190
  541952
  602111
  727844
  765353
  498648
  750756
  385738
  382449
  813738
  483847
  546477
  647134
  655201
  659041
  684725
  660460
  687949
  688393
  688458
  688474
  653326
  657156
  658162
  705647
  616530
  597891
  623036
  632868
  590108
  805091
  779161
  794330
  768599
  730135
  760334
  747065
  613442
  721260
  778432
  792329
  795186
  796003
  396821
  382501
  413356
  448734
  485637
  538448
  501541
  578135
  650649
  719772
  603564
  639124
  799825
  779659
  748669
  792406
  733786
  738751
]
2.99 ms
(1.75%)
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
  12148
  382449
  382501
  384258
  385738
  387656
  391567
  392721
  396821
  405444
  413356
  424287
  441211
  448734
  451717
  452662
  483847
  485637
  487646
  495439
  498648
  499411
  501541
  503394
  511241
  522190
  535958
  538448
  539669
  539784
  541086
  541952
  542145
  546477
  554868
  578135
  579072
  579570
  582706
  590108
  597891
  600537
  602111
  603564
  608488
  609516
  613442
  616530
  623036
  624592
  632868
  638718
  639124
  641339
  647134
  650029
  650649
  653326
  655201
  655492
  657156
  657642
  658162
  659041
  660460
  661769
  662638
  663883
  684725
  687310
  687949
  688393
  688458
  688474
  689534
  705647
  709340
  709553
  711749
  719772
  721260
  727844
  727874
  730135
  733786
  734828
  738751
  742345
  747065
  747507
  748669
  750756
  752057
  754635
  760334
  762094
  764464
  765353
  765955
  768576
  768599
  778272
  778432
  778771
  778783
  779161
  779659
  783884
  792329
  792406
  794330
  794620
  795186
  796003
  799825
  802366
  805091
  813738
  813888
  825574
]
2.15 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "doggy girl"
]
1.80 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рак девушк"
]
1.71 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 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.