GET https://search.jues.net/search/embeds/10?q=boy%20sleeping

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.56 ms
(82.31%)
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
  379600
  385491
  389098
  392054
  401406
  404412
  418958
  419093
  419330
  422078
  422319
  422340
  422360
  424461
  428428
  428518
  435301
  437204
  439441
  439571
  439752
  440690
  440902
  442126
  442411
  443184
  447023
  448358
  448731
  450827
  453265
  454650
  455002
  462455
  463047
  464284
  464482
  464555
  465248
  466267
  466935
  467194
  468574
  469443
  473884
  475044
  476623
  477965
  479473
  480323
  481449
  482485
  484369
  484582
  484630
  484768
  485654
  485916
  487318
  488073
  496057
  499754
  499785
  502241
  504529
  508682
  512846
  513190
  514781
  516207
  517015
  517271
  517572
  518174
  518909
  519183
  520681
  521135
  521845
  522710
  523451
  524466
  524509
  527077
  529252
  531494
  534190
  544234
  555179
  561581
  562868
  563003
  563544
  567214
  569879
  570657
  572718
  574128
  574840
  582222
  620100
  637399
  643379
  652258
  661912
  664831
  666367
  684259
  687540
  688335
  705258
  717696
  721563
  721616
  722882
  779768
  814853
  818915
  823857
  824347
]
18.73 ms
(11.63%)
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
  477965
  479473
  481449
  439752
  442126
  467194
  480323
  389098
  392054
  422078
  422319
  422360
  476623
  379600
  385491
  404412
  424461
  443184
  466267
  468574
  475044
  418958
  437204
  447023
  448731
  453265
  522710
  484369
  499754
  518174
  518909
  524466
  527077
  484768
  485916
  487318
  502241
  517572
  519183
  484582
  496057
  514781
  524509
  469443
  488073
  512846
  529252
  563544
  508682
  523451
  499785
  555179
  620100
  465248
  521135
  517015
  422340
  439571
  484630
  520681
  401406
  419330
  428518
  419093
  439441
  435301
  440902
  428428
  440690
  442411
  814853
  824347
  818915
  823857
  448358
  464482
  466935
  485654
  455002
  462455
  450827
  454650
  473884
  504529
  534190
  513190
  516207
  521845
  531494
  517271
  463047
  464284
  464555
  482485
  569879
  582222
  574128
  544234
  561581
  562868
  563003
  572718
  652258
  661912
  664831
  688335
  705258
  721563
  721616
  722882
  666367
  684259
  687540
  717696
  567214
  570657
  574840
  637399
  643379
  779768
]
2.99 ms
(1.85%)
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
  379600
  385491
  389098
  392054
  401406
  404412
  418958
  419093
  419330
  422078
  422319
  422340
  422360
  424461
  428428
  428518
  435301
  437204
  439441
  439571
  439752
  440690
  440902
  442126
  442411
  443184
  447023
  448358
  448731
  450827
  453265
  454650
  455002
  462455
  463047
  464284
  464482
  464555
  465248
  466267
  466935
  467194
  468574
  469443
  473884
  475044
  476623
  477965
  479473
  480323
  481449
  482485
  484369
  484582
  484630
  484768
  485654
  485916
  487318
  488073
  496057
  499754
  499785
  502241
  504529
  508682
  512846
  513190
  514781
  516207
  517015
  517271
  517572
  518174
  518909
  519183
  520681
  521135
  521845
  522710
  523451
  524466
  524509
  527077
  529252
  531494
  534190
  544234
  555179
  561581
  562868
  563003
  563544
  567214
  569879
  570657
  572718
  574128
  574840
  582222
  620100
  637399
  643379
  652258
  661912
  664831
  666367
  684259
  687540
  688335
  705258
  717696
  721563
  721616
  722882
  779768
  814853
  818915
  823857
  824347
]
1.93 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "boy sleeping"
]
1.74 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "парен спящ"
]
1.59 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "парен спящ"
]
1.52 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.