GET https://search.jues.net/search/embeds/3?q=blonde%20big%20toys

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
215.53 ms
(36.31%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беловолосая большие toys"
]
208.58 ms
(35.14%)
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
  32030
  159036
  190204
  209385
  256218
  381921
  383527
  385653
  387047
  390644
  391384
  396057
  400195
  400971
  404739
  407763
  409795
  411643
  411808
  415197
  415200
  415946
  416706
  418692
  420171
  420200
  420385
  423736
  423933
  432724
  434849
  447509
  449020
  457171
  460187
  463159
  465645
  470058
  471105
  471107
  472543
  478510
  479009
  479997
  480760
  482622
  485797
  497103
  509079
  513220
  515275
  515979
  517038
  517740
  531789
  534169
  548515
  550681
  556331
  558668
  566031
  568477
  575610
  576868
  578292
  579271
  582443
  584338
  585995
  588037
  602608
  606636
  615296
  618687
  620220
  624220
  624229
  626746
  629851
  633465
  640785
  643005
  643194
  644311
  651851
  654898
  669756
  681785
  684701
  691598
  698972
  700996
  707844
  713027
  717862
  720701
  721831
  722623
  722625
  724147
  727939
  740833
  741531
  743178
  744520
  755954
  758226
  760615
  766646
  774287
  776280
  785357
  795149
  803454
  807595
  811643
  814049
  817191
  819978
  821139
]
147.92 ms
(24.92%)
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
  32030
  159036
  190204
  209385
  256218
  381921
  383527
  385653
  387047
  390644
  391384
  396057
  400195
  400971
  404739
  407763
  409795
  411643
  411808
  415197
  415200
  415946
  416706
  418692
  420171
  420200
  420385
  423736
  423933
  432724
  434849
  447509
  449020
  457171
  460187
  463159
  465645
  470058
  471105
  471107
  472543
  478510
  479009
  479997
  480760
  482622
  485797
  497103
  509079
  513220
  515275
  515979
  517038
  517740
  531789
  534169
  548515
  550681
  556331
  558668
  566031
  568477
  575610
  576868
  578292
  579271
  582443
  584338
  585995
  588037
  602608
  606636
  615296
  618687
  620220
  624220
  624229
  626746
  629851
  633465
  640785
  643005
  643194
  644311
  651851
  654898
  669756
  681785
  684701
  691598
  698972
  700996
  707844
  713027
  717862
  720701
  721831
  722623
  722625
  724147
  727939
  740833
  741531
  743178
  744520
  755954
  758226
  760615
  766646
  774287
  776280
  785357
  795149
  803454
  807595
  811643
  814049
  817191
  819978
  821139
]
15.51 ms
(2.61%)
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
  423933
  517038
  575610
  568477
  698972
  669756
  713027
  558668
  626746
  776280
  743178
  760615
  766646
  624220
  720701
  566031
  383527
  418692
  420200
  423736
  479997
  515275
  681785
  691598
  717862
  651851
  582443
  606636
  629851
  774287
  740833
  785357
  256218
  420171
  509079
  548515
  387047
  409795
  457171
  449020
  531789
  556331
  579271
  585995
  807595
  795149
  633465
  390644
  432724
  396057
  479009
  534169
  700996
  618687
  727939
  32030
  817191
  819978
  460187
  470058
  472543
  517740
  615296
  643194
  811643
  209385
  391384
  415200
  416706
  550681
  684701
  707844
  654898
  722623
  624229
  602608
  588037
  620220
  643005
  644311
  755954
  744520
  724147
  741531
  722625
  803454
  471107
  420385
  515979
  482622
  407763
  485797
  513220
  578292
  640785
  758226
  404739
  463159
  434849
  400195
  385653
  447509
  190204
  471105
  821139
  584338
  159036
  400971
  576868
  721831
  381921
  411808
  415946
  411643
  415197
  814049
  480760
  465645
  478510
  497103
]
2.31 ms
(0.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "беловолосая большие toys"
]
2.19 ms
(0.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blonde big toys"
]
1.55 ms
(0.26%)
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.