GET https://search.jues.net/search/embeds/5?q=pussy%20beautiful

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
205.42 ms
(50.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy beautiful"
]
182.48 ms
(44.54%)
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
  38637
  75811
  116949
  145503
  185208
  185353
  382600
  386074
  389236
  398171
  401525
  401574
  401582
  402164
  406928
  412222
  412537
  414220
  418493
  431002
  431636
  442963
  444098
  448077
  467220
  473019
  485017
  486889
  491581
  494645
  494822
  499177
  501784
  515134
  515556
  521869
  528018
  532842
  533430
  537486
  546291
  556857
  561828
  563838
  566730
  583277
  594220
  605178
  608533
  618030
  620737
  621959
  659656
  673457
  673711
  676527
  676996
  689458
  693905
  717801
  719090
  719352
  721282
  722853
  723689
  723725
  723941
  723957
  725088
  727396
  727827
  729118
  743753
  744027
  744571
  745241
  745484
  746480
  746711
  746945
  751485
  752990
  755416
  755526
  759829
  761336
  771736
  774035
  775051
  775564
  775677
  778681
  780199
  780217
  781012
  785835
  789007
  789568
  789926
  791307
  791595
  791622
  791920
  796356
  797575
  799652
  800120
  802046
  802551
  807393
  808778
  810362
  810780
  812307
  813327
  818831
  819002
  819207
  820150
  824306
]
13.38 ms
(3.27%)
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
  414220
  418493
  444098
  448077
  473019
  486889
  494645
  501784
  491581
  515556
  485017
  494822
  499177
  521869
  528018
  412537
  820150
  537486
  659656
  693905
  689458
  621959
  796356
  780217
  791622
  725088
  744027
  752990
  774035
  797575
  810362
  723957
  755526
  743753
  751485
  771736
  719352
  789568
  406928
  401525
  185208
  402164
  620737
  813327
  727827
  755416
  727396
  759829
  775677
  802551
  401582
  431002
  561828
  442963
  819002
  818831
  824306
  819207
  533430
  721282
  594220
  775564
  791307
  800120
  789007
  723941
  745241
  785835
  807393
  808778
  812307
  744571
  775051
  75811
  382600
  145503
  467220
  515134
  778681
  810780
  431636
  386074
  676527
  618030
  605178
  608533
  789926
  722853
  38637
  401574
  412222
  532842
  583277
  563838
  546291
  556857
  673711
  676996
  673457
  566730
  780199
  781012
  791595
  791920
  799652
  723689
  729118
  745484
  746711
  802046
  723725
  746480
  761336
  746945
  717801
  719090
  185353
  389236
  398171
  116949
]
2.71 ms
(0.66%)
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
  38637
  75811
  116949
  145503
  185208
  185353
  382600
  386074
  389236
  398171
  401525
  401574
  401582
  402164
  406928
  412222
  412537
  414220
  418493
  431002
  431636
  442963
  444098
  448077
  467220
  473019
  485017
  486889
  491581
  494645
  494822
  499177
  501784
  515134
  515556
  521869
  528018
  532842
  533430
  537486
  546291
  556857
  561828
  563838
  566730
  583277
  594220
  605178
  608533
  618030
  620737
  621959
  659656
  673457
  673711
  676527
  676996
  689458
  693905
  717801
  719090
  719352
  721282
  722853
  723689
  723725
  723941
  723957
  725088
  727396
  727827
  729118
  743753
  744027
  744571
  745241
  745484
  746480
  746711
  746945
  751485
  752990
  755416
  755526
  759829
  761336
  771736
  774035
  775051
  775564
  775677
  778681
  780199
  780217
  781012
  785835
  789007
  789568
  789926
  791307
  791595
  791622
  791920
  796356
  797575
  799652
  800120
  802046
  802551
  807393
  808778
  810362
  810780
  812307
  813327
  818831
  819002
  819207
  820150
  824306
]
2.38 ms
(0.58%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(0.42%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy красивая"
]
1.56 ms
(0.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy красивая"
]

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.