GET https://search.jues.net/search/embeds/10?q=pickup%20public

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.82 ms
(84.56%)
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
  33711
  83386
  210281
  380426
  382089
  383487
  386227
  387399
  392902
  393129
  401560
  415107
  417704
  451567
  451602
  455612
  461006
  466671
  467133
  471593
  479683
  480842
  483326
  486485
  486494
  487481
  489003
  491690
  491719
  494715
  496571
  496976
  497952
  508586
  511038
  512688
  521009
  521928
  527549
  528995
  529026
  529074
  543213
  546862
  549452
  560162
  562300
  565422
  565455
  566554
  566578
  566580
  567567
  569017
  570223
  570384
  572136
  572848
  573881
  578153
  580690
  589746
  592657
  594318
  594857
  594860
  594944
  594947
  594968
  599746
  613858
  619132
  623442
  625333
  650306
  663908
  665468
  667317
  672145
  672188
  673054
  673099
  673136
  673144
  673779
  689697
  690480
  693160
  695993
  698001
  706293
  707497
  715449
  719374
  721953
  724331
  725265
  729578
  729601
  731620
  740052
  740539
  740966
  743627
  743897
  745929
  756343
  760897
  762674
  767380
  768380
  769469
  780943
  786360
  795147
  817458
  817461
  822231
  822806
  823148
]
15.91 ms
(9.29%)
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
  690480
  715449
  650306
  672188
  721953
  594944
  599746
  594318
  725265
  729578
  745929
  786360
  756343
  740539
  760897
  724331
  768380
  731620
  393129
  415107
  570223
  383487
  528995
  494715
  572136
  613858
  83386
  486485
  566554
  565422
  566580
  451602
  455612
  461006
  471593
  491719
  521928
  483326
  489003
  491690
  497952
  527549
  619132
  529074
  496976
  392902
  822806
  823148
  549452
  578153
  546862
  560162
  667317
  673054
  663908
  665468
  673144
  795147
  480842
  508586
  487481
  417704
  451567
  573881
  767380
  780943
  401560
  479683
  566578
  743627
  387399
  486494
  466671
  496571
  380426
  382089
  33711
  817458
  817461
  822231
  511038
  512688
  529026
  521009
  543213
  562300
  567567
  569017
  572848
  570384
  673136
  672145
  673099
  689697
  698001
  706293
  673779
  693160
  695993
  719374
  565455
  580690
  594857
  592657
  594947
  594968
  625333
  589746
  594860
  729601
  740052
  740966
  743897
  769469
  762674
  623442
  707497
  467133
  210281
  386227
]
2.97 ms
(1.73%)
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
  33711
  83386
  210281
  380426
  382089
  383487
  386227
  387399
  392902
  393129
  401560
  415107
  417704
  451567
  451602
  455612
  461006
  466671
  467133
  471593
  479683
  480842
  483326
  486485
  486494
  487481
  489003
  491690
  491719
  494715
  496571
  496976
  497952
  508586
  511038
  512688
  521009
  521928
  527549
  528995
  529026
  529074
  543213
  546862
  549452
  560162
  562300
  565422
  565455
  566554
  566578
  566580
  567567
  569017
  570223
  570384
  572136
  572848
  573881
  578153
  580690
  589746
  592657
  594318
  594857
  594860
  594944
  594947
  594968
  599746
  613858
  619132
  623442
  625333
  650306
  663908
  665468
  667317
  672145
  672188
  673054
  673099
  673136
  673144
  673779
  689697
  690480
  693160
  695993
  698001
  706293
  707497
  715449
  719374
  721953
  724331
  725265
  729578
  729601
  731620
  740052
  740539
  740966
  743627
  743897
  745929
  756343
  760897
  762674
  767380
  768380
  769469
  780943
  786360
  795147
  817458
  817461
  822231
  822806
  823148
]
2.29 ms
(1.34%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.99 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pickup public"
]
1.75 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пикап на улиц"
]
1.53 ms
(0.89%)
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.