GET https://search.jues.net/search/embeds/10?q=squirt%20dildo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.14 ms
(79.59%)
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
  413373
  413826
  415818
  420299
  422340
  426295
  434364
  438748
  444194
  445175
  448816
  451261
  452638
  452823
  452897
  452953
  461086
  469023
  469738
  470458
  471118
  476705
  479661
  485283
  487486
  502043
  506516
  506692
  508885
  510905
  512447
  512975
  513572
  516884
  527280
  533013
  534772
  536783
  546042
  561479
  566761
  566855
  569379
  577905
  582540
  587451
  587506
  589229
  597216
  599976
  601613
  608574
  614858
  617410
  622454
  623262
  629828
  631641
  632649
  633123
  633451
  633502
  633780
  635234
  636321
  639716
  639745
  639798
  640789
  641972
  642044
  642775
  644913
  645238
  645861
  646776
  649546
  649596
  666426
  666853
  666895
  675008
  675010
  677784
  683261
  687313
  696582
  699397
  702622
  708195
  718698
  725792
  730073
  738472
  738492
  739158
  745276
  746882
  750701
  752647
  752648
  758330
  765222
  770155
  777642
  777935
  780025
  782894
  783905
  785816
  787511
  791179
  803381
  803455
  808341
  810463
  813819
  814437
  814777
  826610
]
26.65 ms
(14.72%)
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
  696582
  699397
  649596
  582540
  599976
  632649
  633123
  633451
  601613
  614858
  487486
  745276
  770155
  780025
  512975
  566761
  426295
  451261
  506516
  479661
  718698
  635234
  702622
  434364
  444194
  438748
  803381
  536783
  677784
  448816
  569379
  644913
  452953
  666895
  649546
  639798
  639716
  803455
  413826
  510905
  445175
  782894
  420299
  758330
  587451
  785816
  791179
  752647
  739158
  777642
  813819
  422340
  413373
  814777
  546042
  645238
  646776
  640789
  636321
  750701
  642775
  471118
  470458
  415818
  461086
  675010
  645861
  642044
  639745
  502043
  516884
  752648
  485283
  589229
  512447
  508885
  527280
  631641
  452897
  826610
  476705
  561479
  622454
  783905
  808341
  738472
  738492
  730073
  746882
  725792
  810463
  513572
  765222
  469023
  469738
  452638
  566855
  666853
  683261
  633780
  617410
  452823
  587506
  787511
  534772
  577905
  687313
  708195
  608574
  629828
  777935
  623262
  533013
  675008
  597216
  633502
  666426
  814437
  506692
  641972
]
3.13 ms
(1.73%)
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
  413373
  413826
  415818
  420299
  422340
  426295
  434364
  438748
  444194
  445175
  448816
  451261
  452638
  452823
  452897
  452953
  461086
  469023
  469738
  470458
  471118
  476705
  479661
  485283
  487486
  502043
  506516
  506692
  508885
  510905
  512447
  512975
  513572
  516884
  527280
  533013
  534772
  536783
  546042
  561479
  566761
  566855
  569379
  577905
  582540
  587451
  587506
  589229
  597216
  599976
  601613
  608574
  614858
  617410
  622454
  623262
  629828
  631641
  632649
  633123
  633451
  633502
  633780
  635234
  636321
  639716
  639745
  639798
  640789
  641972
  642044
  642775
  644913
  645238
  645861
  646776
  649546
  649596
  666426
  666853
  666895
  675008
  675010
  677784
  683261
  687313
  696582
  699397
  702622
  708195
  718698
  725792
  730073
  738472
  738492
  739158
  745276
  746882
  750701
  752647
  752648
  758330
  765222
  770155
  777642
  777935
  780025
  782894
  783905
  785816
  787511
  791179
  803381
  803455
  808341
  810463
  813819
  814437
  814777
  826610
]
1.99 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.89 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сквирт оргазм дилд"
]
1.76 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "squirt dildo"
]
1.54 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.