GET https://search.jues.net/search/embeds/7?q=mature%20in%20bed

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.69 ms
(81.20%)
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
  14853
  383000
  386874
  389150
  408218
  415506
  424131
  426003
  432299
  441844
  443736
  448338
  450141
  450146
  450641
  451457
  452640
  452659
  453465
  454423
  455128
  458385
  458703
  459200
  459646
  459950
  460745
  461364
  462457
  462731
  464299
  465379
  465380
  466153
  466944
  468518
  471055
  472907
  474412
  474442
  475887
  476350
  478365
  485409
  486365
  493676
  493761
  493775
  495250
  495520
  497492
  499906
  502712
  506353
  506799
  507088
  510155
  510878
  512029
  512057
  512503
  513143
  515068
  517017
  517245
  517601
  520469
  522484
  526679
  528749
  529338
  529811
  536107
  536661
  539464
  540543
  545880
  547993
  548015
  549718
  549720
  550219
  550355
  554235
  554451
  555223
  556625
  561476
  563081
  563228
  564548
  566196
  566359
  566914
  574173
  575694
  579371
  581359
  582797
  583696
  588852
  589286
  589696
  592948
  593047
  593064
  594546
  595255
  596025
  601852
  603424
  604240
  620230
  644075
  665309
  666132
  668738
  681259
  768851
  819342
]
18.67 ms
(11.34%)
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
  819342
  450146
  453465
  459646
  474412
  493676
  493761
  450141
  455128
  474442
  466944
  493775
  506353
  539464
  513143
  520469
  536107
  495250
  510878
  495520
  459950
  472907
  475887
  486365
  545880
  547993
  574173
  556625
  566914
  554451
  555223
  563081
  575694
  581359
  668738
  681259
  666132
  548015
  549718
  561476
  564548
  566359
  592948
  595255
  644075
  588852
  589286
  594546
  604240
  768851
  462731
  14853
  441844
  448338
  458385
  424131
  426003
  459200
  383000
  389150
  468518
  443736
  485409
  507088
  510155
  386874
  432299
  408218
  415506
  452640
  458703
  464299
  452659
  454423
  465379
  497492
  512029
  512503
  512057
  529338
  529811
  499906
  517017
  517245
  517601
  522484
  540543
  502712
  506799
  515068
  526679
  528749
  536661
  549720
  554235
  579371
  550219
  550355
  563228
  566196
  582797
  665309
  583696
  601852
  620230
  593047
  593064
  589696
  596025
  603424
  460745
  465380
  478365
  451457
  461364
  462457
  466153
  450641
  471055
  476350
]
4.64 ms
(2.82%)
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
  14853
  383000
  386874
  389150
  408218
  415506
  424131
  426003
  432299
  441844
  443736
  448338
  450141
  450146
  450641
  451457
  452640
  452659
  453465
  454423
  455128
  458385
  458703
  459200
  459646
  459950
  460745
  461364
  462457
  462731
  464299
  465379
  465380
  466153
  466944
  468518
  471055
  472907
  474412
  474442
  475887
  476350
  478365
  485409
  486365
  493676
  493761
  493775
  495250
  495520
  497492
  499906
  502712
  506353
  506799
  507088
  510155
  510878
  512029
  512057
  512503
  513143
  515068
  517017
  517245
  517601
  520469
  522484
  526679
  528749
  529338
  529811
  536107
  536661
  539464
  540543
  545880
  547993
  548015
  549718
  549720
  550219
  550355
  554235
  554451
  555223
  556625
  561476
  563081
  563228
  564548
  566196
  566359
  566914
  574173
  575694
  579371
  581359
  582797
  583696
  588852
  589286
  589696
  592948
  593047
  593064
  594546
  595255
  596025
  601852
  603424
  604240
  620230
  644075
  665309
  666132
  668738
  681259
  768851
  819342
]
2.25 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature in bed"
]
1.94 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.92 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature постел"
]
1.53 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature постел"
]

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.