GET https://search.jues.net/search/embeds/10?q=pussy%20chubby

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
175.24 ms
(86.49%)
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
  6640
  40000
  67112
  107216
  152529
  191336
  343369
  381942
  385116
  385752
  388570
  391018
  391950
  393027
  393558
  396338
  397174
  398122
  398791
  400706
  401678
  403243
  404451
  407377
  407636
  407793
  411942
  412957
  413612
  414027
  431504
  433814
  447094
  455438
  456999
  469379
  470937
  473891
  479969
  484395
  487351
  491864
  495266
  495516
  495581
  496307
  496973
  502025
  502613
  503069
  503565
  513822
  513889
  517989
  518909
  524240
  525545
  526642
  527016
  530445
  539348
  539371
  542723
  543943
  544795
  546892
  549714
  554448
  554532
  557052
  562423
  564749
  564889
  569370
  570764
  570966
  573297
  574427
  574678
  577126
  577192
  584339
  592973
  593003
  593531
  599670
  622315
  645300
  650608
  695171
  726512
  726537
  726710
  726712
  726713
  727554
  785330
  808045
  808054
  810136
  810893
  813749
  814104
  814722
  817048
  819196
  819346
  819371
  823169
  824441
  824531
  824634
  825340
  825358
  825437
  826698
  827097
  827287
  827926
  827977
]
16.69 ms
(8.24%)
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
  808045
  808054
  810136
  152529
  393558
  385116
  398122
  400706
  107216
  391950
  388570
  470937
  484395
  404451
  412957
  431504
  487351
  447094
  473891
  502025
  503565
  513889
  496973
  517989
  554448
  574427
  570764
  570966
  574678
  695171
  557052
  562423
  592973
  622315
  593003
  599670
  593531
  785330
  810893
  726512
  726537
  726713
  726712
  726710
  727554
  411942
  469379
  455438
  456999
  526642
  527016
  518909
  385752
  67112
  191336
  393027
  343369
  381942
  40000
  6640
  391018
  396338
  397174
  398791
  401678
  403243
  407377
  407636
  407793
  414027
  413612
  433814
  813749
  814722
  819371
  823169
  825437
  826698
  814104
  817048
  824441
  827097
  827287
  819346
  824531
  824634
  825358
  819196
  825340
  827977
  827926
  479969
  491864
  502613
  503069
  495516
  495581
  513822
  524240
  525545
  496307
  530445
  539371
  495266
  539348
  543943
  569370
  577126
  542723
  544795
  546892
  573297
  549714
  554532
  564749
  564889
  577192
  584339
  645300
  650608
]
3.13 ms
(1.55%)
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
  6640
  40000
  67112
  107216
  152529
  191336
  343369
  381942
  385116
  385752
  388570
  391018
  391950
  393027
  393558
  396338
  397174
  398122
  398791
  400706
  401678
  403243
  404451
  407377
  407636
  407793
  411942
  412957
  413612
  414027
  431504
  433814
  447094
  455438
  456999
  469379
  470937
  473891
  479969
  484395
  487351
  491864
  495266
  495516
  495581
  496307
  496973
  502025
  502613
  503069
  503565
  513822
  513889
  517989
  518909
  524240
  525545
  526642
  527016
  530445
  539348
  539371
  542723
  543943
  544795
  546892
  549714
  554448
  554532
  557052
  562423
  564749
  564889
  569370
  570764
  570966
  573297
  574427
  574678
  577126
  577192
  584339
  592973
  593003
  593531
  599670
  622315
  645300
  650608
  695171
  726512
  726537
  726710
  726712
  726713
  727554
  785330
  808045
  808054
  810136
  810893
  813749
  814104
  814722
  817048
  819196
  819346
  819371
  823169
  824441
  824531
  824634
  825340
  825358
  825437
  826698
  827097
  827287
  827926
  827977
]
2.14 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy chubby"
]
1.87 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy chubby"
]
1.81 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy chubby"
]

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.