GET https://search.jues.net/search/embeds/3?q=teen%20tights

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.07 ms
(81.57%)
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
  20180
  383742
  389587
  397553
  418839
  419167
  425285
  432419
  432421
  432422
  432437
  432451
  432463
  432484
  432532
  432546
  432569
  432580
  433024
  433054
  433059
  433061
  433358
  433419
  433426
  433447
  433452
  433554
  433742
  434195
  434220
  434232
  434236
  439274
  444895
  452604
  452652
  452671
  452955
  454004
  454367
  456311
  458062
  460080
  462910
  463382
  464797
  464891
  465972
  466027
  470156
  470312
  470929
  470946
  473838
  474956
  475512
  478054
  478393
  483024
  487428
  489128
  493571
  495292
  496882
  498635
  498639
  499207
  504349
  505250
  509952
  512901
  512922
  514258
  515478
  518412
  518817
  520739
  521093
  521345
  525067
  526291
  528471
  540428
  545489
  552110
  552482
  560379
  560422
  572326
  584611
  591631
  594265
  594386
  597807
  598536
  598958
  618833
  637447
  640407
  680275
  717235
  745081
  753395
  753397
  777058
  787242
  788852
  828429
  828543
  828545
  828557
  828563
  828665
  828673
  828676
  828763
  828766
  828780
]
17.61 ms
(11.87%)
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
  433024
  433419
  397553
  432546
  433054
  452652
  456311
  470156
  470929
  433358
  433426
  460080
  515478
  528471
  512922
  493571
  498639
  498635
  518412
  518817
  525067
  828766
  828673
  828665
  828557
  637447
  745081
  753397
  828545
  828563
  773672
  520739
  828763
  828543
  828676
  828429
  787242
  383742
  432421
  419167
  418839
  454004
  458062
  462910
  473838
  489128
  452604
  470312
  454367
  464891
  466027
  540428
  509952
  521345
  499207
  514258
  478054
  552110
  560379
  560422
  584611
  545489
  680275
  572326
  591631
  597807
  594265
  594386
  598536
  598958
  777058
  788852
  618833
  425285
  432437
  432463
  432484
  432569
  433059
  433447
  433452
  433554
  434220
  470946
  434232
  452671
  464797
  432422
  432451
  432532
  432580
  444895
  452955
  463382
  20180
  432419
  433061
  434195
  434236
  475512
  478393
  433742
  439274
  465972
  474956
  526291
  483024
  487428
  496882
  495292
  505250
  512901
  504349
  521093
  640407
  753395
  389587
  552482
  828780
  717235
]
2.87 ms
(1.93%)
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
  20180
  383742
  389587
  397553
  418839
  419167
  425285
  432419
  432421
  432422
  432437
  432451
  432463
  432484
  432532
  432546
  432569
  432580
  433024
  433054
  433059
  433061
  433358
  433419
  433426
  433447
  433452
  433554
  433742
  434195
  434220
  434232
  434236
  439274
  444895
  452604
  452652
  452671
  452955
  454004
  454367
  456311
  458062
  460080
  462910
  463382
  464797
  464891
  465972
  466027
  470156
  470312
  470929
  470946
  473838
  474956
  475512
  478054
  478393
  483024
  487428
  489128
  493571
  495292
  496882
  498635
  498639
  499207
  504349
  505250
  509952
  512901
  512922
  514258
  515478
  518412
  518817
  520739
  521093
  521345
  525067
  526291
  528471
  540428
  545489
  552110
  552482
  560379
  560422
  572326
  584611
  591631
  594265
  594386
  597807
  598536
  598958
  618833
  637447
  640407
  680275
  717235
  745081
  753395
  753397
  777058
  787242
  788852
  828429
  828543
  828545
  828557
  828563
  828665
  828673
  828676
  828763
  828766
  828780
]
1.96 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen tights"
]
1.72 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen колготк"
]
1.50 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen колготк"
]

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.