GET https://search.jues.net/search/embeds/9?q=teen%20small%20young

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.57 ms
(81.95%)
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
  391567
  395812
  395984
  404633
  415223
  419198
  419590
  422500
  422594
  422709
  423259
  428302
  463948
  463965
  473112
  483498
  486354
  489484
  491644
  494695
  501809
  508438
  511733
  512257
  514796
  515202
  518270
  523985
  524089
  525102
  526188
  528459
  529846
  530757
  532831
  533471
  545517
  545610
  550067
  550099
  558138
  558947
  561653
  562116
  565471
  566703
  567166
  568556
  568573
  568580
  569677
  569682
  573788
  574818
  575059
  575137
  576101
  576112
  576859
  580669
  583677
  584022
  584539
  590542
  595383
  595489
  596648
  597045
  597940
  598092
  598806
  606508
  612399
  612799
  619175
  622331
  622398
  622402
  623849
  626878
  627809
  627813
  628387
  628406
  630540
  631965
  632001
  632046
  634482
  637094
  637123
  646838
  660439
  666546
  666868
  666883
  677053
  677142
  692127
  701118
  716161
  720487
  722717
  727798
  731379
  741306
  747387
  747595
  750143
  751770
  754192
  774155
  774162
  790036
  790754
  791181
  800588
  811628
  812150
  813902
]
18.10 ms
(11.54%)
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
  494695
  523985
  576101
  561653
  574818
  692127
  597940
  596648
  576859
  622398
  566703
  565471
  634482
  612399
  612799
  791181
  747595
  473112
  391567
  501809
  489484
  404633
  701118
  812150
  774162
  731379
  774155
  716161
  597045
  575059
  573788
  575137
  423259
  530757
  529846
  533471
  550067
  550099
  558138
  567166
  584539
  545610
  584022
  568556
  568580
  576112
  583677
  660439
  677142
  646838
  666546
  666883
  606508
  627809
  630540
  631965
  623849
  590542
  598092
  628387
  628406
  619175
  622331
  622402
  632001
  632046
  637094
  800588
  598806
  637123
  518270
  722717
  720487
  666868
  419590
  568573
  569677
  811628
  627813
  395984
  483498
  515202
  463965
  512257
  514796
  463948
  428302
  569682
  558947
  580669
  595383
  422709
  415223
  422500
  524089
  526188
  562116
  545517
  595489
  790754
  790036
  395812
  419198
  422594
  525102
  508438
  528459
  532831
  486354
  491644
  511733
  813902
  677053
  626878
  754192
  727798
  741306
  751770
  747387
  750143
]
2.79 ms
(1.78%)
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
  391567
  395812
  395984
  404633
  415223
  419198
  419590
  422500
  422594
  422709
  423259
  428302
  463948
  463965
  473112
  483498
  486354
  489484
  491644
  494695
  501809
  508438
  511733
  512257
  514796
  515202
  518270
  523985
  524089
  525102
  526188
  528459
  529846
  530757
  532831
  533471
  545517
  545610
  550067
  550099
  558138
  558947
  561653
  562116
  565471
  566703
  567166
  568556
  568573
  568580
  569677
  569682
  573788
  574818
  575059
  575137
  576101
  576112
  576859
  580669
  583677
  584022
  584539
  590542
  595383
  595489
  596648
  597045
  597940
  598092
  598806
  606508
  612399
  612799
  619175
  622331
  622398
  622402
  623849
  626878
  627809
  627813
  628387
  628406
  630540
  631965
  632001
  632046
  634482
  637094
  637123
  646838
  660439
  666546
  666868
  666883
  677053
  677142
  692127
  701118
  716161
  720487
  722717
  727798
  731379
  741306
  747387
  747595
  750143
  751770
  754192
  774155
  774162
  790036
  790754
  791181
  800588
  811628
  812150
  813902
]
2.06 ms
(1.31%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen маленькая young"
]
1.91 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen small young"
]
1.83 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen маленькая young"
]
1.64 ms
(1.04%)
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.