GET https://search.jues.net/search/embeds/6?q=public%20park

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.58 ms
(83.97%)
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
  109041
  223442
  360205
  364718
  382383
  386316
  398794
  401940
  405725
  412332
  413007
  413801
  417709
  420426
  422398
  422488
  425745
  426389
  427214
  428423
  429261
  446761
  450646
  451583
  451606
  452225
  455565
  455850
  456261
  456607
  457561
  458114
  458584
  458686
  458830
  460098
  460100
  460395
  461174
  462352
  466671
  470224
  472344
  472799
  473647
  475179
  475574
  478106
  478212
  478261
  479952
  480673
  482882
  486494
  487133
  487159
  488877
  493288
  494046
  497166
  499706
  502318
  503041
  504613
  504833
  506571
  514296
  523944
  523968
  524002
  525650
  527044
  527456
  528416
  528715
  528993
  529015
  529058
  529918
  544299
  544614
  545352
  546446
  549101
  549222
  551227
  555440
  557895
  560014
  560170
  562804
  568790
  569865
  570356
  570609
  571598
  578133
  579456
  580327
  586381
  589357
  593122
  599623
  599792
  601580
  606647
  615082
  617647
  626911
  628004
  630749
  668025
  709452
  719915
  729357
  793992
  818657
  821065
  822815
  825580
]
16.90 ms
(10.16%)
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
  545352
  460098
  422488
  472799
  527456
  479952
  586381
  793992
  486494
  466671
  223442
  428423
  413801
  626911
  417709
  401940
  455565
  529015
  719915
  599792
  493288
  382383
  628004
  544614
  506571
  502318
  487133
  452225
  528715
  475179
  560170
  568790
  473647
  360205
  497166
  528416
  109041
  729357
  504613
  425745
  446761
  593122
  462352
  412332
  450646
  405725
  523968
  458686
  398794
  487159
  514296
  458114
  461174
  451583
  524002
  818657
  570609
  557895
  426389
  460395
  599623
  458584
  413007
  460100
  601580
  528993
  457561
  525650
  569865
  478106
  475574
  482882
  709452
  606647
  456607
  546446
  364718
  578133
  488877
  549222
  562804
  503041
  529918
  668025
  615082
  825580
  571598
  579456
  480673
  499706
  422398
  458830
  470224
  551227
  580327
  630749
  527044
  523944
  386316
  822815
  821065
  570356
  420426
  429261
  456261
  451606
  478261
  617647
  455850
  427214
  478212
  472344
  494046
  504833
  529058
  589357
  560014
  544299
  555440
  549101
]
3.24 ms
(1.95%)
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
  109041
  223442
  360205
  364718
  382383
  386316
  398794
  401940
  405725
  412332
  413007
  413801
  417709
  420426
  422398
  422488
  425745
  426389
  427214
  428423
  429261
  446761
  450646
  451583
  451606
  452225
  455565
  455850
  456261
  456607
  457561
  458114
  458584
  458686
  458830
  460098
  460100
  460395
  461174
  462352
  466671
  470224
  472344
  472799
  473647
  475179
  475574
  478106
  478212
  478261
  479952
  480673
  482882
  486494
  487133
  487159
  488877
  493288
  494046
  497166
  499706
  502318
  503041
  504613
  504833
  506571
  514296
  523944
  523968
  524002
  525650
  527044
  527456
  528416
  528715
  528993
  529015
  529058
  529918
  544299
  544614
  545352
  546446
  549101
  549222
  551227
  555440
  557895
  560014
  560170
  562804
  568790
  569865
  570356
  570609
  571598
  578133
  579456
  580327
  586381
  589357
  593122
  599623
  599792
  601580
  606647
  615082
  617647
  626911
  628004
  630749
  668025
  709452
  719915
  729357
  793992
  818657
  821065
  822815
  825580
]
1.81 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public park"
]
1.70 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на улиц парк природ"
]
1.60 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(0.84%)
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.