GET https://search.jues.net/search/embeds/10?q=solo%20pantyhose

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.22 ms
(83.11%)
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
  391984
  392004
  393220
  410694
  418112
  418130
  419167
  425823
  427395
  428700
  429860
  429862
  429881
  432928
  434325
  436937
  439274
  445977
  446302
  451598
  454004
  460201
  463966
  466524
  468949
  473429
  473838
  475593
  476325
  478987
  483762
  485470
  487428
  492758
  497906
  508266
  510271
  513501
  516364
  518105
  521481
  521559
  525904
  526291
  528348
  529361
  537091
  540790
  541274
  541803
  542097
  544788
  547452
  548201
  552478
  555705
  556448
  556900
  557980
  558683
  560252
  560379
  563649
  564209
  569252
  576943
  586005
  587196
  589676
  592617
  596632
  605679
  607541
  607959
  608505
  608550
  616048
  626216
  628604
  630558
  656935
  660385
  664441
  667189
  669907
  671018
  680242
  681251
  685127
  709674
  710638
  713885
  717410
  730011
  736942
  739131
  739169
  740492
  742323
  745126
  745136
  749259
  752633
  757427
  758164
  758778
  758788
  781400
  785591
  786881
  790193
  794205
  795723
  796833
  800677
  807011
  808728
  808998
  811057
]
15.36 ms
(10.04%)
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
  529361
  518105
  544788
  393220
  418130
  432928
  436937
  419167
  410694
  540790
  454004
  473838
  445977
  478987
  451598
  537091
  508266
  516364
  525904
  521559
  528348
  473429
  476325
  483762
  541274
  556900
  560252
  560379
  576943
  541803
  542097
  548201
  557980
  547452
  552478
  563649
  569252
  669907
  709674
  656935
  660385
  664441
  680242
  685127
  713885
  717410
  667189
  671018
  681251
  710638
  555705
  556448
  558683
  564209
  596632
  605679
  607541
  616047
  608505
  608550
  586005
  587196
  626216
  589676
  592617
  607959
  616048
  630558
  790193
  800677
  736942
  781400
  785591
  795723
  796833
  807011
  808728
  808998
  811057
  739169
  740492
  758164
  758788
  739131
  742323
  745126
  749259
  730011
  745136
  757427
  752633
  758778
  628604
  786881
  794205
  391984
  427395
  429860
  434325
  392004
  425823
  429862
  429881
  475593
  439274
  446302
  460201
  463966
  526291
  487428
  521481
  492758
  497906
  513501
  418112
  428700
  485470
  466524
  468949
  510271
]
3.25 ms
(2.13%)
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
  391984
  392004
  393220
  410694
  418112
  418130
  419167
  425823
  427395
  428700
  429860
  429862
  429881
  432928
  434325
  436937
  439274
  445977
  446302
  451598
  454004
  460201
  463966
  466524
  468949
  473429
  473838
  475593
  476325
  478987
  483762
  485470
  487428
  492758
  497906
  508266
  510271
  513501
  516364
  518105
  521481
  521559
  525904
  526291
  528348
  529361
  537091
  540790
  541274
  541803
  542097
  544788
  547452
  548201
  552478
  555705
  556448
  556900
  557980
  558683
  560252
  560379
  563649
  564209
  569252
  576943
  586005
  587196
  589676
  592617
  596632
  605679
  607541
  607959
  608505
  608550
  616048
  626216
  628604
  630558
  656935
  660385
  664441
  667189
  669907
  671018
  680242
  681251
  685127
  709674
  710638
  713885
  717410
  730011
  736942
  739131
  739169
  740492
  742323
  745126
  745136
  749259
  752633
  757427
  758164
  758778
  758788
  781400
  785591
  786881
  790193
  794205
  795723
  796833
  800677
  807011
  808728
  808998
  811057
]
1.97 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo pantyhose"
]
1.87 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло pantyhose"
]
1.74 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "соло pantyhose"
]

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.