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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.83 ms
(83.35%)
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
  400708
  413889
  421841
  431514
  441502
  444908
  446977
  447078
  449356
  449398
  453121
  455245
  455729
  458172
  459389
  462991
  463694
  466165
  466429
  470330
  471513
  471831
  474572
  477239
  478375
  478978
  479641
  479644
  481844
  482785
  484418
  488120
  490015
  496554
  498600
  499826
  504250
  504684
  506866
  508128
  510341
  510591
  510832
  513155
  513909
  516087
  516524
  518820
  519169
  519460
  520728
  520870
  521287
  522121
  522647
  522839
  523823
  524029
  524149
  524203
  524296
  524344
  525179
  525261
  525451
  526513
  526659
  527243
  527701
  527885
  528571
  528711
  528713
  531446
  533978
  534320
  542528
  549990
  554526
  557164
  557595
  558210
  558523
  559008
  559106
  564636
  564719
  565167
  565786
  566323
  567910
  569835
  574298
  574416
  574443
  582035
  582797
  586485
  588674
  588802
  593167
  598553
  600987
  601103
  603835
  604038
  607227
  616237
  617019
  618972
  620714
  621312
  622386
  624833
  626294
  638303
  643681
  660834
  670113
  677973
]
22.00 ms
(11.19%)
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
  513909
  526659
  482785
  558523
  559008
  582797
  564719
  567910
  574298
  586485
  588802
  617019
  616237
  621312
  449398
  463694
  466165
  479644
  470330
  421841
  447078
  458172
  459389
  466429
  441502
  508128
  516524
  522839
  521287
  524344
  525179
  525261
  526513
  527885
  504250
  506866
  510832
  518820
  519460
  677973
  582035
  601103
  431514
  504684
  400708
  528711
  527701
  559106
  565786
  566323
  603835
  600987
  471513
  478375
  510341
  488120
  542528
  531446
  593167
  446977
  574443
  574416
  496554
  534320
  565167
  498600
  474572
  588674
  598553
  643681
  549990
  444908
  618972
  484418
  490015
  519169
  520728
  524296
  513155
  522647
  523823
  528713
  527243
  524203
  558210
  564636
  670113
  660834
  557595
  624833
  607227
  453121
  479641
  413889
  477239
  449356
  471831
  455729
  462991
  481844
  524149
  528571
  525451
  520870
  522121
  604038
  620714
  533978
  569835
  622386
  455245
  516087
  499826
  510591
  557164
  626294
  638303
  478978
  524029
  554526
]
2.69 ms
(1.37%)
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
  400708
  413889
  421841
  431514
  441502
  444908
  446977
  447078
  449356
  449398
  453121
  455245
  455729
  458172
  459389
  462991
  463694
  466165
  466429
  470330
  471513
  471831
  474572
  477239
  478375
  478978
  479641
  479644
  481844
  482785
  484418
  488120
  490015
  496554
  498600
  499826
  504250
  504684
  506866
  508128
  510341
  510591
  510832
  513155
  513909
  516087
  516524
  518820
  519169
  519460
  520728
  520870
  521287
  522121
  522647
  522839
  523823
  524029
  524149
  524203
  524296
  524344
  525179
  525261
  525451
  526513
  526659
  527243
  527701
  527885
  528571
  528711
  528713
  531446
  533978
  534320
  542528
  549990
  554526
  557164
  557595
  558210
  558523
  559008
  559106
  564636
  564719
  565167
  565786
  566323
  567910
  569835
  574298
  574416
  574443
  582035
  582797
  586485
  588674
  588802
  593167
  598553
  600987
  601103
  603835
  604038
  607227
  616237
  617019
  618972
  620714
  621312
  622386
  624833
  626294
  638303
  643681
  660834
  670113
  677973
]
2.11 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big ass shorts"
]
2.08 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.96 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие жоп шорт"
]
1.89 ms
(0.96%)
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.