GET https://search.jues.net/search/embeds/6?q=toys%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
216.83 ms
(53.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "toys секс"
]
164.33 ms
(40.84%)
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
  7133
  13265
  357604
  400563
  402515
  410227
  414236
  415956
  479725
  515287
  518136
  530955
  531744
  546172
  546321
  548113
  548515
  549116
  549117
  550711
  554673
  556287
  556610
  556904
  557283
  557617
  562465
  565469
  569699
  572986
  582758
  583580
  604112
  619694
  622695
  624379
  633473
  636963
  641300
  643975
  646863
  651327
  652174
  662916
  675347
  702616
  704460
  707581
  708112
  713124
  716530
  719372
  722409
  723824
  726469
  733601
  735131
  735658
  737687
  744801
  744807
  746576
  751065
  754299
  754446
  754482
  756817
  760371
  761297
  761786
  766768
  767248
  773265
  774957
  784229
  785072
  785315
  785888
  787160
  787958
  790979
  791867
  792102
  793158
  793331
  793611
  794595
  796910
  798761
  800547
  805495
  807601
  811514
  814135
  816630
  817191
  819248
  819409
  819710
  819909
  820198
  820598
  820968
  823016
  823123
  823137
  823725
  823859
  824835
  824979
  825339
  825838
  826250
  826251
  826809
  827531
  827951
  828651
]
10.79 ms
(2.68%)
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
  823123
  823725
  825339
  826250
  826251
  820598
  820968
  823016
  823137
  824979
  819248
  819409
  821958
  530955
  546321
  550711
  554673
  562465
  572986
  556904
  646863
  662916
  652174
  713124
  549116
  556610
  582758
  619694
  636963
  785888
  798761
  774957
  794595
  796910
  754482
  761786
  793158
  760371
  770215
  754446
  754299
  767248
  735131
  746576
  773265
  604112
  704460
  708112
  722409
  787160
  791867
  415956
  357604
  7133
  400563
  410227
  823859
  824835
  819710
  819909
  820198
  827531
  816630
  825838
  826809
  827951
  828651
  515287
  518136
  531744
  548113
  549117
  556287
  583580
  557283
  557617
  651327
  702616
  707581
  675347
  716530
  719372
  546172
  622695
  624379
  633473
  641300
  643975
  787958
  790979
  792102
  793331
  800547
  805495
  811514
  737687
  744801
  744807
  756817
  784229
  785072
  785315
  807601
  723824
  733601
  735658
  726469
  751065
  761297
  414236
  13265
  402515
  793611
  766768
  817191
  814135
  479725
  565469
  548515
  569699
]
5.01 ms
(1.25%)
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
  7133
  13265
  357604
  400563
  402515
  410227
  414236
  415956
  479725
  515287
  518136
  530955
  531744
  546172
  546321
  548113
  548515
  549116
  549117
  550711
  554673
  556287
  556610
  556904
  557283
  557617
  562465
  565469
  569699
  572986
  582758
  583580
  604112
  619694
  622695
  624379
  633473
  636963
  641300
  643975
  646863
  651327
  652174
  662916
  675347
  702616
  704460
  707581
  708112
  713124
  716530
  719372
  722409
  723824
  726469
  733601
  735131
  735658
  737687
  744801
  744807
  746576
  751065
  754299
  754446
  754482
  756817
  760371
  761297
  761786
  766768
  767248
  773265
  774957
  784229
  785072
  785315
  785888
  787160
  787958
  790979
  791867
  792102
  793158
  793331
  793611
  794595
  796910
  798761
  800547
  805495
  807601
  811514
  814135
  816630
  817191
  819248
  819409
  819710
  819909
  820198
  820598
  820968
  823016
  823123
  823137
  823725
  823859
  824835
  824979
  825339
  825838
  826250
  826251
  826809
  827531
  827951
  828651
]
1.96 ms
(0.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "toys sex"
]
1.84 ms
(0.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "toys секс"
]
1.58 ms
(0.39%)
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.