GET https://search.jues.net/search/embeds/3?q=petite%20xxx

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
178.69 ms
(88.74%)
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
  194398
  385315
  389675
  390782
  391350
  392655
  393881
  394818
  535664
  541787
  546294
  547172
  548595
  551051
  559208
  564278
  565835
  590156
  590504
  593887
  611817
  617754
  625743
  628750
  630877
  631166
  633908
  633995
  634043
  639501
  642110
  642639
  643854
  648787
  649548
  650048
  652092
  660328
  671490
  678711
  679269
  681198
  686752
  688880
  689207
  690214
  693618
  703106
  708716
  709913
  712062
  713042
  713767
  714914
  725767
  727786
  729786
  730218
  730221
  730794
  738907
  738925
  739016
  739062
  744123
  748063
  748671
  751022
  751943
  752581
  756461
  757556
  758726
  758851
  762136
  762628
  767460
  768628
  768834
  774640
  775626
  777126
  778630
  779057
  780387
  781070
  783637
  783714
  783827
  784339
  786200
  786274
  787458
  789464
  791448
  792003
  792108
  792338
  793135
  795847
  796785
  799285
  800133
  807088
  810498
  810889
  811055
  812039
  813697
  818831
  819191
  819595
  821161
  821810
  822227
  825297
  826842
  826851
  826941
]
12.51 ms
(6.21%)
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
  778630
  780387
  781070
  783637
  783714
  784339
  786801
  789464
  807088
  391350
  392655
  194398
  385315
  394818
  393881
  389675
  390782
  818831
  825297
  826842
  826851
  826941
  821810
  813697
  819191
  819595
  821161
  822227
  535664
  548595
  565835
  547172
  541787
  546294
  551051
  559208
  564278
  648787
  686752
  712062
  713767
  649548
  671490
  688880
  690214
  703106
  708716
  714914
  650048
  652092
  660328
  678711
  679269
  681198
  689207
  693618
  709913
  713042
  590504
  633995
  634043
  642110
  617754
  639501
  642639
  633908
  590156
  593887
  611817
  625743
  628750
  630877
  631166
  643854
  777126
  779057
  783827
  786274
  795847
  796785
  812039
  774640
  775626
  787458
  792108
  793135
  800133
  810498
  727786
  730221
  739016
  748671
  751943
  752581
  758726
  767460
  786200
  791448
  792003
  792338
  799285
  810889
  811055
  730794
  738925
  744123
  748063
  756461
  757556
  758851
  768628
  768834
  729786
  730218
  738907
  751022
  762136
  762628
  725767
  739062
]
3.02 ms
(1.50%)
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
  194398
  385315
  389675
  390782
  391350
  392655
  393881
  394818
  535664
  541787
  546294
  547172
  548595
  551051
  559208
  564278
  565835
  590156
  590504
  593887
  611817
  617754
  625743
  628750
  630877
  631166
  633908
  633995
  634043
  639501
  642110
  642639
  643854
  648787
  649548
  650048
  652092
  660328
  671490
  678711
  679269
  681198
  686752
  688880
  689207
  690214
  693618
  703106
  708716
  709913
  712062
  713042
  713767
  714914
  725767
  727786
  729786
  730218
  730221
  730794
  738907
  738925
  739016
  739062
  744123
  748063
  748671
  751022
  751943
  752581
  756461
  757556
  758726
  758851
  762136
  762628
  767460
  768628
  768834
  774640
  775626
  777126
  778630
  779057
  780387
  781070
  783637
  783714
  783827
  784339
  786200
  786274
  787458
  789464
  791448
  792003
  792108
  792338
  793135
  795847
  796785
  799285
  800133
  807088
  810498
  810889
  811055
  812039
  813697
  818831
  819191
  819595
  821161
  821810
  822227
  825297
  826842
  826851
  826941
]
1.97 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "petite xxx"
]
1.97 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "petite xxx"
]
1.48 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "petite xxx"
]

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.