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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.50 ms
(86.97%)
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
  14374
  385315
  389675
  390782
  394818
  398870
  535664
  546294
  547172
  548595
  551051
  559208
  565835
  590504
  593887
  611817
  616146
  617754
  625743
  626998
  628750
  630877
  631166
  633908
  633995
  639501
  642110
  642639
  643854
  648787
  649548
  650048
  652092
  660328
  671490
  678711
  679269
  681198
  686752
  688880
  689207
  690214
  699671
  703106
  708716
  712062
  713042
  713767
  714914
  720158
  725767
  729786
  730218
  730221
  730794
  732166
  734995
  738907
  738925
  739016
  739062
  741183
  742925
  743212
  744123
  748063
  748671
  751022
  751319
  751943
  752581
  756461
  757146
  757556
  758136
  758726
  758851
  759213
  762006
  762136
  762628
  764322
  765364
  767460
  768834
  774121
  774640
  775051
  777126
  777710
  779057
  779915
  783827
  786200
  786274
  787458
  791448
  792003
  792108
  792338
  792679
  793135
  795847
  796785
  799285
  800133
  810498
  811055
  812039
  812193
  813697
  818831
  819191
  819595
  821161
  822227
  825297
  826842
  826851
  826941
]
13.19 ms
(7.24%)
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
  385315
  394818
  389675
  390782
  818831
  825297
  826842
  826851
  826941
  813697
  819191
  819595
  821161
  822227
  535664
  548595
  565835
  547172
  546294
  551051
  559208
  648787
  686752
  712062
  713767
  649548
  671490
  688880
  690214
  703106
  708716
  714914
  650048
  652092
  660328
  678711
  679269
  681198
  689207
  713042
  590504
  633995
  642110
  617754
  639501
  642639
  633908
  593887
  611817
  625743
  628750
  630877
  631166
  643854
  777126
  779057
  783827
  786274
  795847
  796785
  812039
  774640
  787458
  792108
  793135
  800133
  810498
  730221
  739016
  748671
  751943
  752581
  758726
  767460
  786200
  791448
  792003
  792338
  799285
  811055
  730794
  738925
  744123
  748063
  756461
  757556
  758851
  768834
  729786
  730218
  738907
  751022
  762136
  762628
  725767
  739062
  741183
  742925
  743212
  751319
  758136
  759213
  762006
  764322
  765364
  732166
  734995
  757146
  774121
  616146
  626998
  699671
  720158
  775051
  777710
  779915
  792679
  812193
  14374
  398870
]
2.92 ms
(1.60%)
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
  14374
  385315
  389675
  390782
  394818
  398870
  535664
  546294
  547172
  548595
  551051
  559208
  565835
  590504
  593887
  611817
  616146
  617754
  625743
  626998
  628750
  630877
  631166
  633908
  633995
  639501
  642110
  642639
  643854
  648787
  649548
  650048
  652092
  660328
  671490
  678711
  679269
  681198
  686752
  688880
  689207
  690214
  699671
  703106
  708716
  712062
  713042
  713767
  714914
  720158
  725767
  729786
  730218
  730221
  730794
  732166
  734995
  738907
  738925
  739016
  739062
  741183
  742925
  743212
  744123
  748063
  748671
  751022
  751319
  751943
  752581
  756461
  757146
  757556
  758136
  758726
  758851
  759213
  762006
  762136
  762628
  764322
  765364
  767460
  768834
  774121
  774640
  775051
  777126
  777710
  779057
  779915
  783827
  786200
  786274
  787458
  791448
  792003
  792108
  792338
  792679
  793135
  795847
  796785
  799285
  800133
  810498
  811055
  812039
  812193
  813697
  818831
  819191
  819595
  821161
  822227
  825297
  826842
  826851
  826941
]
2.05 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "petite teens"
]
1.97 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "petite teens"
]
1.82 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "petite teens"
]

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.