GET https://search.jues.net/search/embeds/3?q=%D1%81%D0%B5%D0%BA%D1%81%20%D0%B2%20%D0%BA%D1%83%D1%85%D0%BD%D1%8F

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
214.11 ms
(53.36%)
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
  24289
  29403
  66348
  157493
  172024
  172685
  193874
  246509
  308331
  326158
  327638
  373311
  382018
  382444
  383577
  383583
  384334
  384889
  386872
  389893
  392028
  396891
  397967
  401532
  402125
  407746
  409881
  410015
  421113
  422172
  424182
  427486
  429776
  440894
  441224
  453232
  455319
  455994
  456990
  457572
  459257
  460348
  462943
  463180
  464015
  464459
  466961
  472852
  475600
  477453
  481238
  482467
  482639
  492199
  494852
  499189
  504154
  506273
  507415
  509348
  510705
  511205
  512563
  512612
  512960
  517077
  519394
  519659
  539360
  542979
  545492
  546629
  550643
  552802
  557322
  560366
  561455
  561464
  561505
  565865
  566953
  567431
  569685
  575195
  577364
  580866
  584562
  585395
  601102
  609604
  613238
  618948
  621592
  642407
  642409
  659397
  675393
  675618
  684961
  685400
  685519
  714554
  716106
  717546
  717914
  734180
  738226
  742220
  742763
  757113
  761890
  761949
  780254
  786080
  796953
  801175
  803256
  806754
  810867
  813710
]
165.75 ms
(41.30%)
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
  24289
  29403
  66348
  157493
  172024
  172685
  193874
  246509
  308331
  326158
  327638
  373311
  382018
  382444
  383577
  383583
  384334
  384889
  386872
  389893
  392028
  396891
  397967
  401532
  402125
  407746
  409881
  410015
  421113
  422172
  424182
  427486
  429776
  440894
  441224
  453232
  455319
  455994
  456990
  457572
  459257
  460348
  462943
  463180
  464015
  464459
  466961
  472852
  475600
  477453
  481238
  482467
  482639
  492199
  494852
  499189
  504154
  506273
  507415
  509348
  510705
  511205
  512563
  512612
  512960
  517077
  519394
  519659
  539360
  542979
  545492
  546629
  550643
  552802
  557322
  560366
  561455
  561464
  561505
  565865
  566953
  567431
  569685
  575195
  577364
  580866
  584562
  585395
  601102
  609604
  613238
  618948
  621592
  642407
  642409
  659397
  675393
  675618
  684961
  685400
  685519
  714554
  716106
  717546
  717914
  734180
  738226
  742220
  742763
  757113
  761890
  761949
  780254
  786080
  796953
  801175
  803256
  806754
  810867
  813710
]
14.72 ms
(3.67%)
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
  373311
  424182
  66348
  685519
  675618
  172685
  389893
  585395
  510705
  482639
  453232
  584562
  613238
  429776
  512563
  459257
  326158
  499189
  472852
  172024
  685400
  717546
  742220
  565865
  621592
  780254
  560366
  575195
  504154
  742763
  757113
  384334
  734180
  422172
  327638
  29403
  561505
  494852
  796953
  384889
  577364
  609604
  401532
  561464
  761949
  519394
  382444
  402125
  517077
  246509
  308331
  813710
  716106
  714554
  810867
  464459
  561455
  642409
  392028
  382018
  482467
  509348
  557322
  542979
  409881
  455994
  512612
  519659
  506273
  441224
  475600
  512960
  457572
  460348
  462943
  477453
  786080
  396891
  466961
  456990
  539360
  546629
  552802
  566953
  427486
  463180
  511205
  507415
  569685
  455319
  659397
  801175
  803256
  642407
  545492
  383577
  410015
  397967
  193874
  481238
  684961
  761890
  738226
  386872
  675393
  157493
  464015
  550643
  618948
  601102
  24289
  407746
  567431
  580866
  492199
  383583
  421113
  717914
  806754
  440894
]
1.88 ms
(0.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "секс в кухня"
]
1.78 ms
(0.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс в кухн"
]
1.55 ms
(0.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс в кухн"
]
1.49 ms
(0.37%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.