GET https://search.jues.net/search/embeds/3?q=amateur%20gaping

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.74 ms
(84.87%)
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
  65568
  389966
  391911
  391926
  391945
  392023
  395970
  396670
  400802
  404028
  413058
  413341
  414104
  414125
  414132
  416515
  416529
  416616
  416677
  416678
  418148
  419452
  420129
  421207
  421220
  422723
  423350
  424397
  424765
  429880
  429889
  429890
  429899
  429900
  431540
  432274
  433038
  434874
  441384
  443260
  444322
  445211
  445409
  446874
  446989
  448464
  449068
  449404
  450434
  453408
  453582
  454274
  454927
  458281
  461724
  463205
  464794
  467910
  469431
  470414
  476981
  480650
  483731
  487191
  487414
  491436
  492165
  494231
  497675
  501641
  507284
  510425
  510803
  513209
  514868
  517724
  521145
  524389
  525468
  527915
  527922
  528508
  541274
  542127
  550530
  560666
  560917
  566208
  571809
  573748
  575601
  580597
  583474
  586219
  586688
  592187
  594389
  599538
  602092
  602793
  603612
  604426
  604545
  605219
  605725
  605746
  622693
  634108
  672950
  709693
  712555
  725631
  772535
  782452
]
17.26 ms
(9.34%)
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
  414104
  434874
  441384
  414132
  469431
  483731
  449068
  487414
  514868
  541274
  550530
  583474
  672950
  560917
  566208
  592187
  782452
  725631
  391926
  528508
  461724
  400802
  413341
  480650
  575601
  580597
  521145
  594389
  604545
  709693
  416678
  443260
  413058
  424765
  605219
  634108
  599538
  446989
  458281
  445211
  432274
  416515
  453582
  450434
  449404
  467910
  513209
  527922
  492165
  542127
  772535
  602793
  712555
  392023
  391945
  404028
  416616
  444322
  476981
  525468
  487191
  463205
  65568
  420129
  424397
  464794
  418148
  429880
  510425
  391911
  433038
  448464
  510803
  517724
  429890
  414125
  429889
  497675
  586688
  422723
  421220
  423350
  416677
  454927
  419452
  454274
  453408
  431540
  416529
  507284
  571809
  560666
  604426
  605725
  396670
  421207
  573748
  429899
  491436
  470414
  602092
  389966
  429900
  395970
  446874
  524389
  494231
  603612
  445409
  586219
  501641
  605746
  622693
  527915
]
3.06 ms
(1.65%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск gaping"
]
2.90 ms
(1.57%)
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
  65568
  389966
  391911
  391926
  391945
  392023
  395970
  396670
  400802
  404028
  413058
  413341
  414104
  414125
  414132
  416515
  416529
  416616
  416677
  416678
  418148
  419452
  420129
  421207
  421220
  422723
  423350
  424397
  424765
  429880
  429889
  429890
  429899
  429900
  431540
  432274
  433038
  434874
  441384
  443260
  444322
  445211
  445409
  446874
  446989
  448464
  449068
  449404
  450434
  453408
  453582
  454274
  454927
  458281
  461724
  463205
  464794
  467910
  469431
  470414
  476981
  480650
  483731
  487191
  487414
  491436
  492165
  494231
  497675
  501641
  507284
  510425
  510803
  513209
  514868
  517724
  521145
  524389
  525468
  527915
  527922
  528508
  541274
  542127
  550530
  560666
  560917
  566208
  571809
  573748
  575601
  580597
  583474
  586219
  586688
  592187
  594389
  599538
  602092
  602793
  603612
  604426
  604545
  605219
  605725
  605746
  622693
  634108
  672950
  709693
  712555
  725631
  772535
  782452
]
1.69 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur gaping"
]
1.51 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск gaping"
]

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.