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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
213.17 ms
(88.52%)
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
  187918
  215337
  332778
  386645
  386798
  387510
  387711
  388722
  388729
  390571
  390713
  398511
  403324
  417015
  419535
  429863
  440947
  460171
  469575
  471105
  471696
  472688
  475842
  480472
  485207
  493182
  494141
  510907
  513201
  531058
  531268
  531866
  534083
  534559
  539372
  541618
  546258
  546988
  547464
  555082
  560943
  571123
  604514
  606576
  615516
  624788
  630423
  637503
  648761
  660365
  669010
  669023
  669072
  700997
  710559
  712296
  712580
  714698
  715473
  720622
  724023
  724252
  726469
  726896
  728146
  728385
  729907
  731759
  731763
  731808
  731823
  733541
  734062
  735872
  738330
  740744
  741716
  741742
  741764
  742390
  742409
  744807
  746683
  748522
  754462
  755369
  755952
  755960
  759987
  765340
  765699
  766606
  769908
  770904
  772549
  781646
  781775
  785072
  788517
  795867
  799016
  799360
  800573
  801977
  802446
  803023
  803393
  811221
  813712
  817189
  817394
  818824
  819235
  819602
  824101
  824442
  824835
  826388
  826489
  827399
]
17.62 ms
(7.32%)
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
  748522
  755369
  770904
  724023
  742409
  772549
  731759
  735872
  715473
  781646
  460171
  440947
  387510
  215337
  824835
  531268
  534083
  546258
  571123
  546988
  803393
  729907
  744807
  769908
  785072
  803023
  734062
  731823
  726469
  731808
  738330
  754462
  712296
  781775
  802446
  493182
  388729
  398511
  417015
  817394
  818824
  819235
  824442
  471696
  531866
  534559
  480472
  485207
  547464
  555082
  541618
  669010
  669072
  714698
  720622
  660365
  669023
  712580
  604514
  624788
  630423
  795867
  801977
  811221
  788517
  800573
  741716
  741742
  755952
  755960
  766606
  731763
  733541
  726896
  742390
  765340
  746683
  765699
  728146
  740744
  615516
  637503
  700997
  710559
  799016
  187918
  387711
  386798
  390713
  471105
  494141
  648761
  606576
  759987
  429863
  475842
  510907
  539372
  469575
  560943
  724252
  741764
  728385
  799360
  472688
  403324
  388722
  419535
  513201
  390571
  386645
  332778
  817189
  819602
  826489
  826388
  827399
  813712
  824101
  531058
]
2.68 ms
(1.11%)
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
  187918
  215337
  332778
  386645
  386798
  387510
  387711
  388722
  388729
  390571
  390713
  398511
  403324
  417015
  419535
  429863
  440947
  460171
  469575
  471105
  471696
  472688
  475842
  480472
  485207
  493182
  494141
  510907
  513201
  531058
  531268
  531866
  534083
  534559
  539372
  541618
  546258
  546988
  547464
  555082
  560943
  571123
  604514
  606576
  615516
  624788
  630423
  637503
  648761
  660365
  669010
  669023
  669072
  700997
  710559
  712296
  712580
  714698
  715473
  720622
  724023
  724252
  726469
  726896
  728146
  728385
  729907
  731759
  731763
  731808
  731823
  733541
  734062
  735872
  738330
  740744
  741716
  741742
  741764
  742390
  742409
  744807
  746683
  748522
  754462
  755369
  755952
  755960
  759987
  765340
  765699
  766606
  769908
  770904
  772549
  781646
  781775
  785072
  788517
  795867
  799016
  799360
  800573
  801977
  802446
  803023
  803393
  811221
  813712
  817189
  817394
  818824
  819235
  819602
  824101
  824442
  824835
  826388
  826489
  827399
]
1.95 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.88 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature toys"
]
1.84 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature toys"
]
1.66 ms
(0.69%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.