GET https://search.jues.net/search/embeds/5?q=oil%20dildo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.09 ms
(55.37%)
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
  388856
  398057
  406108
  414116
  415877
  415966
  416561
  416678
  416681
  416684
  416696
  416725
  418121
  421369
  422676
  423663
  423995
  426550
  427027
  429596
  429608
  430262
  434327
  434443
  435689
  435798
  436186
  440708
  442035
  443086
  443247
  444531
  448873
  449017
  450323
  450557
  451316
  452826
  459185
  465680
  467598
  467939
  468665
  470403
  470405
  470470
  476674
  483583
  489338
  494493
  495206
  506260
  508353
  508895
  510541
  513965
  529797
  530480
  541322
  543856
  546202
  548260
  548467
  561021
  561038
  564297
  577313
  583283
  592593
  601113
  612070
  617114
  623281
  624191
  624197
  624893
  628113
  629281
  636183
  639791
  642029
  642042
  648710
  664717
  666736
  669079
  669361
  669386
  674043
  678707
  696607
  708062
  713185
  724993
  737722
  738483
  740934
  746201
  747328
  750881
  752634
  752661
  752697
  756770
  756992
  759370
  773188
  777016
  779769
  781754
  782515
  790109
  796372
  796663
  796705
  799161
  810662
  811696
  814980
  820787
]
142.55 ms
(37.39%)
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
  388856
  398057
  406108
  414116
  415877
  415966
  416561
  416678
  416681
  416684
  416696
  416725
  418121
  421369
  422676
  423663
  423995
  426550
  427027
  429596
  429608
  430262
  434327
  434443
  435689
  435798
  436186
  440708
  442035
  443086
  443247
  444531
  448873
  449017
  450323
  450557
  451316
  452826
  459185
  465680
  467598
  467939
  468665
  470403
  470405
  470470
  476674
  483583
  489338
  494493
  495206
  506260
  508353
  508895
  510541
  513965
  529797
  530480
  541322
  543856
  546202
  548260
  548467
  561021
  561038
  564297
  577313
  583283
  592593
  601113
  612070
  617114
  623281
  624191
  624197
  624893
  628113
  629281
  636183
  639791
  642029
  642042
  648710
  664717
  666736
  669079
  669361
  669386
  674043
  678707
  696607
  708062
  713185
  724993
  737722
  738483
  740934
  746201
  747328
  750881
  752634
  752661
  752697
  756770
  756992
  759370
  773188
  777016
  779769
  781754
  782515
  790109
  796372
  796663
  796705
  799161
  810662
  811696
  814980
  820787
]
20.44 ms
(5.36%)
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
  529797
  541322
  564297
  577313
  648710
  666736
  708062
  713185
  678707
  696607
  674043
  546202
  636183
  642042
  624197
  639791
  592593
  628113
  642029
  779769
  796372
  796663
  810662
  811696
  777016
  796705
  799161
  724993
  740934
  752697
  782515
  738483
  746201
  750881
  752634
  759370
  612070
  624893
  629281
  465680
  435798
  422676
  434327
  470405
  510541
  448873
  414116
  436186
  434443
  398057
  495206
  543856
  664717
  415966
  443247
  467939
  427027
  513965
  506260
  583283
  601113
  388856
  406108
  508353
  435689
  429608
  430262
  416681
  489338
  508895
  530480
  561038
  669079
  669361
  669386
  561021
  624191
  752661
  426550
  443086
  421369
  450323
  452826
  747328
  442035
  814980
  449017
  820787
  548467
  548260
  617114
  623281
  781754
  756992
  773188
  790109
  737722
  756770
  416561
  416725
  423663
  416678
  416684
  440708
  444531
  423995
  429596
  415877
  416696
  418121
  467598
  468665
  470403
  451316
  459185
  450557
  470470
  476674
  483583
  494493
]
2.08 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "oil dildo"
]
1.78 ms
(0.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "масл дилд"
]
1.72 ms
(0.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.41%)
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.