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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.08 ms
(83.89%)
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
  182203
  182206
  382770
  390108
  413391
  419604
  425948
  429606
  432955
  433939
  434278
  435395
  448110
  451242
  457074
  463183
  464844
  471155
  477519
  478867
  494483
  498228
  498538
  513221
  513223
  514277
  514578
  515272
  518183
  518891
  524303
  525785
  526160
  528281
  528947
  529055
  532387
  533841
  541541
  548130
  560918
  568757
  570143
  572784
  579173
  580848
  588493
  588846
  592186
  593495
  595581
  596288
  596833
  599428
  599653
  602111
  602416
  606959
  607560
  609856
  631331
  636889
  640948
  641649
  651335
  657127
  660757
  663969
  665893
  669589
  672307
  672317
  711982
  738485
  739054
  746084
  748783
  749059
  749582
  750813
  751168
  754174
  755952
  758606
  770515
  772238
  772584
  774826
  775139
  776776
  777007
  777818
  780067
  780267
  780963
  781300
  782825
  783316
  783466
  783486
  784012
  784649
  784731
  784938
  788579
  790568
  791042
  791093
  793078
  806144
  806693
  807303
  808842
  809050
  809677
  813222
  814188
  814437
  814446
  820597
]
16.91 ms
(9.85%)
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
  528947
  548130
  814188
  809050
  413391
  448110
  514578
  669589
  588493
  599653
  432955
  541541
  182203
  533841
  657127
  665893
  602111
  596833
  636889
  631331
  775139
  777818
  772584
  746084
  751168
  770515
  776776
  790568
  806144
  433939
  419604
  814437
  513221
  579173
  580848
  672317
  596288
  781300
  783466
  602416
  791042
  434278
  498538
  606959
  588846
  514277
  651335
  641649
  477519
  777007
  739054
  814446
  809677
  607560
  390108
  464844
  457074
  518891
  560918
  663969
  672307
  595581
  425948
  382770
  820597
  478867
  532387
  592186
  599428
  780963
  782825
  783316
  774826
  788579
  749059
  755952
  806693
  780067
  793078
  513223
  783486
  791093
  813222
  660757
  572784
  518183
  494483
  524303
  570143
  515272
  808842
  463183
  435395
  429606
  451242
  568757
  711982
  807303
  750813
  772238
  784731
  748783
  758606
  738485
  749582
  754174
  640948
  780267
  784012
  784649
  525785
  593495
  528281
  529055
  526160
  498228
  784938
  609856
  471155
  182206
]
3.28 ms
(1.91%)
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
  182203
  182206
  382770
  390108
  413391
  419604
  425948
  429606
  432955
  433939
  434278
  435395
  448110
  451242
  457074
  463183
  464844
  471155
  477519
  478867
  494483
  498228
  498538
  513221
  513223
  514277
  514578
  515272
  518183
  518891
  524303
  525785
  526160
  528281
  528947
  529055
  532387
  533841
  541541
  548130
  560918
  568757
  570143
  572784
  579173
  580848
  588493
  588846
  592186
  593495
  595581
  596288
  596833
  599428
  599653
  602111
  602416
  606959
  607560
  609856
  631331
  636889
  640948
  641649
  651335
  657127
  660757
  663969
  665893
  669589
  672307
  672317
  711982
  738485
  739054
  746084
  748783
  749059
  749582
  750813
  751168
  754174
  755952
  758606
  770515
  772238
  772584
  774826
  775139
  776776
  777007
  777818
  780067
  780267
  780963
  781300
  782825
  783316
  783466
  783486
  784012
  784649
  784731
  784938
  788579
  790568
  791042
  791093
  793078
  806144
  806693
  807303
  808842
  809050
  809677
  813222
  814188
  814437
  814446
  820597
]
2.21 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big ass dildo"
]
1.99 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие жоп дилд"
]
1.59 ms
(0.92%)
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.