GET https://search.jues.net/search/embeds/9?q=amateur%20latina

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.77 ms
(84.43%)
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
  468298
  473454
  493808
  528121
  530051
  530059
  538069
  538264
  545684
  546510
  575637
  586092
  589281
  592294
  596545
  597667
  601349
  603943
  605505
  612057
  621829
  621832
  621853
  621918
  622287
  622323
  623382
  624194
  625604
  626284
  626674
  626710
  633928
  634362
  635358
  635829
  640183
  651702
  652030
  675160
  678910
  679405
  682261
  694933
  701604
  703373
  703457
  708520
  713853
  716971
  719327
  720284
  720313
  724029
  724329
  726948
  727613
  728300
  731475
  732709
  733025
  736450
  738051
  739548
  739624
  740129
  740698
  743799
  747174
  748390
  748403
  751846
  752316
  752437
  752686
  755253
  756045
  756719
  757327
  757483
  757649
  759243
  759753
  766676
  770351
  770515
  770719
  770752
  772208
  772775
  772824
  773319
  773694
  773961
  774819
  774829
  776227
  778808
  780121
  784969
  784994
  785003
  785609
  785676
  785789
  788075
  788138
  788223
  792188
  793831
  794163
  799988
  807259
  808036
  810635
  823570
  825442
  826028
  826245
]
14.03 ms
(8.92%)
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
  528121
  589281
  703373
  538264
  538069
  575637
  651702
  675160
  652030
  678910
  679405
  703457
  708520
  546510
  592294
  597667
  603943
  621918
  635358
  621832
  622287
  622323
  605505
  612057
  634362
  626674
  785003
  794163
  625604
  493808
  682261
  624194
  640183
  633928
  626284
  626710
  776227
  793831
  788075
  726948
  759243
  770351
  770752
  635829
  530051
  530059
  825442
  826245
  823570
  468298
  473454
  545684
  694933
  720284
  716971
  713853
  720313
  586092
  621829
  596545
  621853
  623382
  780121
  774819
  774829
  775333
  784969
  784994
  785676
  799988
  808036
  727613
  738051
  739624
  772775
  772824
  773319
  773694
  807259
  732709
  733025
  740129
  756045
  759753
  724329
  728300
  736450
  748390
  751846
  752686
  739548
  743799
  747174
  752316
  752437
  755253
  757649
  772208
  773961
  731475
  740698
  748403
  756719
  757483
  766676
  770515
  701604
  778808
  785609
  785789
  788223
  792188
  810635
  826028
  719327
  601349
  788138
  770719
  724029
  757327
]
3.24 ms
(2.06%)
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
  468298
  473454
  493808
  528121
  530051
  530059
  538069
  538264
  545684
  546510
  575637
  586092
  589281
  592294
  596545
  597667
  601349
  603943
  605505
  612057
  621829
  621832
  621853
  621918
  622287
  622323
  623382
  624194
  625604
  626284
  626674
  626710
  633928
  634362
  635358
  635829
  640183
  651702
  652030
  675160
  678910
  679405
  682261
  694933
  701604
  703373
  703457
  708520
  713853
  716971
  719327
  720284
  720313
  724029
  724329
  726948
  727613
  728300
  731475
  732709
  733025
  736450
  738051
  739548
  739624
  740129
  740698
  743799
  747174
  748390
  748403
  751846
  752316
  752437
  752686
  755253
  756045
  756719
  757327
  757483
  757649
  759243
  759753
  766676
  770351
  770515
  770719
  770752
  772208
  772775
  772824
  773319
  773694
  773961
  774819
  774829
  776227
  778808
  780121
  784969
  784994
  785003
  785609
  785676
  785789
  788075
  788138
  788223
  792188
  793831
  794163
  799988
  807259
  808036
  810635
  823570
  825442
  826028
  826245
]
2.42 ms
(1.54%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск латинская"
]
1.55 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur latina"
]
1.53 ms
(0.97%)
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.