GET https://search.jues.net/search/embeds/3?q=young%20first%20time

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.93 ms
(80.15%)
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
  388429
  390815
  391423
  396314
  400166
  404939
  406075
  408240
  409093
  415388
  423650
  424646
  427592
  427981
  428512
  432582
  432732
  433656
  436437
  439927
  443981
  447242
  447955
  448562
  448726
  452228
  454132
  454238
  459667
  463811
  463889
  463927
  464324
  465372
  465525
  469213
  470817
  471402
  473733
  476258
  478652
  478712
  479190
  484125
  484423
  485246
  485881
  486055
  487325
  487339
  489390
  490879
  490908
  491802
  498423
  501598
  501838
  506529
  514796
  516450
  520008
  521059
  521989
  522434
  522832
  523226
  523320
  524281
  524712
  525044
  528353
  528385
  528403
  530582
  532745
  533760
  537209
  537933
  537970
  540721
  545602
  545755
  548594
  552043
  560396
  561703
  568088
  577342
  578815
  581246
  589674
  590796
  592194
  592956
  593372
  598067
  598806
  603693
  609582
  611001
  620295
  621352
  628082
  628614
  630632
  633718
  634510
  647906
  650155
  657467
  663537
  663930
  684211
  684305
  688548
  688664
  705832
  718710
  773906
  799016
]
19.93 ms
(13.43%)
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
  684211
  705832
  552043
  592194
  447242
  471402
  463927
  463811
  561703
  578815
  799016
  473733
  532745
  650155
  491802
  388429
  581246
  657467
  609582
  773906
  409093
  501838
  404939
  533760
  484125
  688548
  598067
  634510
  611001
  447955
  415388
  479190
  463889
  516450
  521059
  684305
  530582
  464324
  688664
  525044
  432732
  469213
  577342
  592956
  630632
  628614
  718710
  390815
  424646
  476258
  391423
  454132
  478712
  489390
  490908
  490879
  523320
  487339
  465525
  545602
  548594
  647906
  633718
  396314
  408240
  443981
  433656
  498423
  465372
  427592
  436437
  478652
  484423
  540721
  593372
  545755
  568088
  663537
  620295
  628082
  406075
  524281
  428512
  459667
  537970
  506529
  523226
  537933
  448562
  448726
  470817
  528385
  522832
  528403
  514796
  524712
  663930
  427981
  520008
  521989
  486055
  400166
  452228
  522434
  501598
  537209
  560396
  589674
  603693
  454238
  432582
  423650
  485881
  487325
  598806
  590796
  528353
  439927
  621352
  485246
]
2.71 ms
(1.83%)
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
  388429
  390815
  391423
  396314
  400166
  404939
  406075
  408240
  409093
  415388
  423650
  424646
  427592
  427981
  428512
  432582
  432732
  433656
  436437
  439927
  443981
  447242
  447955
  448562
  448726
  452228
  454132
  454238
  459667
  463811
  463889
  463927
  464324
  465372
  465525
  469213
  470817
  471402
  473733
  476258
  478652
  478712
  479190
  484125
  484423
  485246
  485881
  486055
  487325
  487339
  489390
  490879
  490908
  491802
  498423
  501598
  501838
  506529
  514796
  516450
  520008
  521059
  521989
  522434
  522832
  523226
  523320
  524281
  524712
  525044
  528353
  528385
  528403
  530582
  532745
  533760
  537209
  537933
  537970
  540721
  545602
  545755
  548594
  552043
  560396
  561703
  568088
  577342
  578815
  581246
  589674
  590796
  592194
  592956
  593372
  598067
  598806
  603693
  609582
  611001
  620295
  621352
  628082
  628614
  630632
  633718
  634510
  647906
  650155
  657467
  663537
  663930
  684211
  684305
  688548
  688664
  705832
  718710
  773906
  799016
]
1.94 ms
(1.31%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young first time"
]
1.57 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young вперв"
]
1.53 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young вперв"
]

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.