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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.38 ms
(84.16%)
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
  393391
  398909
  400839
  404710
  410272
  411344
  415926
  430446
  432704
  447025
  448825
  452254
  452977
  457294
  457469
  464959
  466404
  469092
  470064
  475410
  475414
  476176
  476676
  477424
  478215
  480393
  501557
  502043
  504980
  508442
  509983
  509988
  512938
  515358
  516574
  516686
  517004
  519497
  519825
  521681
  522184
  522785
  523885
  525634
  533186
  535010
  535332
  537195
  539319
  541602
  543374
  550128
  550579
  550643
  550672
  555722
  561970
  565127
  569750
  570099
  571194
  576690
  582277
  583223
  583508
  584118
  585007
  591692
  593363
  595041
  595176
  596235
  599359
  599967
  600021
  600173
  600354
  600798
  601448
  604627
  604865
  604918
  606636
  607599
  614858
  617418
  622366
  630546
  634131
  637442
  639722
  639741
  640751
  649949
  652190
  652316
  667748
  699397
  702061
  716878
  750611
  751565
  751582
  760649
  763724
  770123
  772573
  775539
  780375
  785909
  786120
  803129
  803455
  807589
  807619
  808151
  809009
  815370
  816086
  819235
]
18.96 ms
(10.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
  807589
  809009
  775539
  785909
  751582
  770123
  607599
  807619
  404710
  522184
  516574
  522785
  593363
  604865
  452977
  523885
  509988
  515358
  699397
  637442
  614858
  640751
  411344
  512938
  519497
  599359
  585007
  815370
  452254
  537195
  519825
  533186
  464959
  569750
  550672
  600173
  600798
  595176
  803129
  772573
  760649
  808151
  476176
  447025
  599967
  539319
  667748
  803455
  477424
  432704
  475414
  509983
  398909
  630546
  600021
  751565
  502043
  521681
  535332
  393391
  457294
  525634
  652316
  570099
  780375
  750611
  763724
  478215
  430446
  508442
  476676
  561970
  583508
  601448
  819235
  652190
  535010
  470064
  816086
  457469
  541602
  634131
  591692
  617418
  600354
  596235
  702061
  475410
  480393
  584118
  555722
  571194
  550643
  649949
  583223
  604918
  504980
  639722
  516686
  639741
  466404
  582277
  410272
  543374
  550128
  576690
  550579
  716878
  595041
  786120
  448825
  604627
  400839
  415926
  469092
  565127
  606636
  622366
  501557
  517004
]
2.97 ms
(1.62%)
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
  393391
  398909
  400839
  404710
  410272
  411344
  415926
  430446
  432704
  447025
  448825
  452254
  452977
  457294
  457469
  464959
  466404
  469092
  470064
  475410
  475414
  476176
  476676
  477424
  478215
  480393
  501557
  502043
  504980
  508442
  509983
  509988
  512938
  515358
  516574
  516686
  517004
  519497
  519825
  521681
  522184
  522785
  523885
  525634
  533186
  535010
  535332
  537195
  539319
  541602
  543374
  550128
  550579
  550643
  550672
  555722
  561970
  565127
  569750
  570099
  571194
  576690
  582277
  583223
  583508
  584118
  585007
  591692
  593363
  595041
  595176
  596235
  599359
  599967
  600021
  600173
  600354
  600798
  601448
  604627
  604865
  604918
  606636
  607599
  614858
  617418
  622366
  630546
  634131
  637442
  639722
  639741
  640751
  649949
  652190
  652316
  667748
  699397
  702061
  716878
  750611
  751565
  751582
  760649
  763724
  770123
  772573
  775539
  780375
  785909
  786120
  803129
  803455
  807589
  807619
  808151
  809009
  815370
  816086
  819235
]
1.94 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom дилд toys"
]
1.80 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom дилд toys"
]
1.76 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom dildo toys"
]
1.63 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.