GET https://search.jues.net/search/embeds?q=mature%20solo%20toys

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.88 ms
(86.24%)
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
  89328
  215337
  290847
  332778
  386858
  391989
  397882
  452940
  460015
  467886
  471111
  531058
  534083
  535324
  546258
  546988
  547236
  547454
  554492
  555062
  555153
  555306
  555409
  555760
  558718
  562465
  568252
  583476
  592441
  596830
  602600
  604920
  605136
  605155
  612091
  614192
  629528
  664183
  670357
  672808
  672913
  672926
  701202
  712296
  714332
  714386
  719384
  720493
  726469
  726490
  728601
  733454
  741208
  744182
  744183
  744186
  744193
  744202
  744211
  744801
  744807
  746125
  746144
  746677
  752078
  752659
  752703
  754462
  755357
  759365
  761191
  769908
  770089
  770100
  770204
  770241
  772544
  776831
  776883
  777085
  777592
  785072
  785873
  788192
  788521
  794718
  797339
  799633
  799640
  800707
  803023
  803393
  803835
  803883
  804484
  805813
  807586
  810097
  811604
  813712
  814530
  816382
  817873
  817960
  819240
  819248
  819254
  822930
  823589
  824835
  825396
  825437
  825859
  826388
  827399
  827652
  827654
  827656
  827693
  827723
]
12.31 ms
(7.08%)
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
  788192
  803835
  819240
  811604
  825859
  744211
  744801
  770089
  746677
  752703
  452940
  817960
  805813
  813712
  602600
  592441
  741208
  827656
  827654
  827652
  672808
  776831
  752659
  397882
  386858
  535324
  629528
  744183
  772544
  794718
  807586
  726490
  744193
  755357
  728601
  825437
  827693
  822930
  720493
  785873
  804484
  744186
  612091
  814530
  672913
  605136
  777592
  604920
  89328
  817873
  819254
  827723
  825396
  776883
  788521
  800707
  290847
  555062
  467886
  819248
  562465
  554492
  770100
  744182
  744202
  761191
  714332
  746125
  770241
  759365
  391989
  460015
  215337
  824835
  534083
  546258
  546988
  803393
  744807
  769908
  785072
  803023
  726469
  754462
  712296
  797339
  816382
  823589
  558718
  672926
  614192
  605155
  799633
  733454
  596830
  555306
  583476
  746144
  332778
  826388
  827399
  531058
  568252
  555409
  555760
  719384
  810097
  803883
  770204
  752078
  701202
  777085
  555153
  471111
  547236
  547454
  670357
  664183
  714386
  799640
]
4.22 ms
(2.43%)
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
  89328
  215337
  290847
  332778
  386858
  391989
  397882
  452940
  460015
  467886
  471111
  531058
  534083
  535324
  546258
  546988
  547236
  547454
  554492
  555062
  555153
  555306
  555409
  555760
  558718
  562465
  568252
  583476
  592441
  596830
  602600
  604920
  605136
  605155
  612091
  614192
  629528
  664183
  670357
  672808
  672913
  672926
  701202
  712296
  714332
  714386
  719384
  720493
  726469
  726490
  728601
  733454
  741208
  744182
  744183
  744186
  744193
  744202
  744211
  744801
  744807
  746125
  746144
  746677
  752078
  752659
  752703
  754462
  755357
  759365
  761191
  769908
  770089
  770100
  770204
  770241
  772544
  776831
  776883
  777085
  777592
  785072
  785873
  788192
  788521
  794718
  797339
  799633
  799640
  800707
  803023
  803393
  803835
  803883
  804484
  805813
  807586
  810097
  811604
  813712
  814530
  816382
  817873
  817960
  819240
  819248
  819254
  822930
  823589
  824835
  825396
  825437
  825859
  826388
  827399
  827652
  827654
  827656
  827693
  827723
]
2.10 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature solo toys"
]
1.89 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature соло toys"
]
1.73 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature соло toys"
]

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.