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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.98 ms
(84.99%)
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
  210146
  210302
  249622
  382017
  383705
  384902
  385814
  386211
  391739
  393792
  395394
  396821
  402398
  404035
  417284
  420020
  425341
  427092
  429268
  431498
  442344
  450858
  454457
  455836
  456987
  457537
  458245
  458436
  458695
  459326
  461005
  461947
  466960
  470206
  470265
  472810
  476849
  479572
  480002
  483452
  485560
  487496
  488896
  490059
  494802
  495302
  497654
  498880
  499681
  504548
  505947
  505986
  511725
  515062
  515333
  519665
  524681
  527535
  527549
  527561
  528218
  529027
  529901
  535008
  535763
  535897
  542526
  542734
  544943
  545240
  548644
  551263
  553331
  555206
  555392
  555450
  555463
  555723
  560273
  560749
  561252
  565372
  565436
  569033
  569534
  572265
  573948
  575948
  580253
  580736
  580864
  580966
  580974
  581040
  583999
  599668
  599777
  601612
  606265
  614377
  616227
  616976
  620160
  622029
  630818
  650228
  680499
  736354
  750976
  787444
  808303
  808669
  817664
  819103
  823801
  825738
  826322
  827669
  828055
  828170
]
16.20 ms
(9.18%)
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
  472810
  470206
  511725
  580253
  384902
  461005
  580966
  385814
  383705
  535763
  736354
  487496
  542526
  483452
  458436
  505986
  485560
  515333
  551263
  599777
  495302
  429268
  616976
  750976
  650228
  548644
  249622
  561252
  583999
  455836
  565372
  480002
  823801
  828055
  454457
  466960
  630818
  494802
  527549
  395394
  620160
  808669
  461947
  417284
  456987
  622029
  386211
  544943
  458245
  601612
  393792
  528218
  614377
  497654
  488896
  553331
  573948
  572265
  450858
  555392
  519665
  542734
  580864
  476849
  527561
  581040
  555723
  575948
  457537
  490059
  470265
  535008
  382017
  555206
  616227
  442344
  498880
  819103
  825738
  787444
  396821
  555450
  569534
  680499
  527535
  808303
  535897
  560749
  425341
  499681
  391739
  560273
  529027
  210146
  817664
  828170
  515062
  524681
  431498
  545240
  555463
  580974
  580736
  599668
  420020
  210302
  565436
  505947
  606265
  402398
  459326
  569033
  458695
  479572
  427092
  826322
  827669
  404035
  504548
  529901
]
2.82 ms
(1.60%)
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
  210146
  210302
  249622
  382017
  383705
  384902
  385814
  386211
  391739
  393792
  395394
  396821
  402398
  404035
  417284
  420020
  425341
  427092
  429268
  431498
  442344
  450858
  454457
  455836
  456987
  457537
  458245
  458436
  458695
  459326
  461005
  461947
  466960
  470206
  470265
  472810
  476849
  479572
  480002
  483452
  485560
  487496
  488896
  490059
  494802
  495302
  497654
  498880
  499681
  504548
  505947
  505986
  511725
  515062
  515333
  519665
  524681
  527535
  527549
  527561
  528218
  529027
  529901
  535008
  535763
  535897
  542526
  542734
  544943
  545240
  548644
  551263
  553331
  555206
  555392
  555450
  555463
  555723
  560273
  560749
  561252
  565372
  565436
  569033
  569534
  572265
  573948
  575948
  580253
  580736
  580864
  580966
  580974
  581040
  583999
  599668
  599777
  601612
  606265
  614377
  616227
  616976
  620160
  622029
  630818
  650228
  680499
  736354
  750976
  787444
  808303
  808669
  817664
  819103
  823801
  825738
  826322
  827669
  828055
  828170
]
1.99 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на улиц парк природ"
]
1.91 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public park"
]
1.83 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на улиц парк природ"
]
1.74 ms
(0.99%)
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.