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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.46 ms
(61.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature tattoo solo"
]
108.24 ms
(32.11%)
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
  401948
  416025
  417980
  419824
  420129
  432289
  432296
  432936
  442064
  443257
  444544
  444548
  444851
  445409
  448464
  449073
  452304
  455217
  457063
  457294
  458768
  458770
  462840
  463795
  466477
  468142
  468146
  468165
  468220
  468642
  468661
  472188
  473453
  473743
  477021
  478215
  481794
  483735
  485546
  486240
  486761
  486784
  493249
  493837
  499726
  500342
  500734
  500799
  501228
  502467
  505344
  508891
  513183
  513986
  515435
  517703
  520138
  520797
  520911
  521798
  526908
  528348
  532118
  541836
  541851
  553194
  565628
  568379
  568481
  569133
  572259
  575973
  576604
  577398
  583033
  583577
  585007
  586007
  587142
  587866
  596324
  598649
  600406
  601134
  601175
  602249
  603414
  604933
  605183
  607530
  607694
  607709
  617032
  624341
  697000
  718678
  752661
  763724
  791489
  805139
  805144
  805146
  810831
  820656
  823695
]
15.16 ms
(4.50%)
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
  419824
  444851
  515435
  541851
  572259
  607694
  444544
  493837
  401948
  532118
  596324
  603414
  820656
  420129
  500342
  513986
  575973
  600406
  417980
  468165
  455217
  500799
  520797
  541836
  568379
  486240
  520911
  416025
  432289
  449073
  466477
  473453
  448464
  458768
  458770
  477021
  486784
  452304
  457294
  463795
  468142
  508891
  468220
  473743
  718678
  576604
  617032
  752661
  763724
  791489
  805139
  444548
  457063
  478215
  468146
  483735
  502467
  517703
  553194
  601134
  823695
  604933
  432296
  468661
  468642
  513183
  569133
  602249
  586007
  697000
  805144
  805146
  462840
  442064
  472188
  486761
  505344
  528348
  583577
  568481
  601175
  605183
  624341
  810831
  443257
  432936
  521798
  481794
  577398
  587866
  607530
  607709
  485546
  445409
  583033
  587142
  499726
  500734
  501228
  526908
  585007
  565628
  598649
  493249
  520138
]
2.50 ms
(0.74%)
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
  401948
  416025
  417980
  419824
  420129
  432289
  432296
  432936
  442064
  443257
  444544
  444548
  444851
  445409
  448464
  449073
  452304
  455217
  457063
  457294
  458768
  458770
  462840
  463795
  466477
  468142
  468146
  468165
  468220
  468642
  468661
  472188
  473453
  473743
  477021
  478215
  481794
  483735
  485546
  486240
  486761
  486784
  493249
  493837
  499726
  500342
  500734
  500799
  501228
  502467
  505344
  508891
  513183
  513986
  515435
  517703
  520138
  520797
  520911
  521798
  526908
  528348
  532118
  541836
  541851
  553194
  565628
  568379
  568481
  569133
  572259
  575973
  576604
  577398
  583033
  583577
  585007
  586007
  587142
  587866
  596324
  598649
  600406
  601134
  601175
  602249
  603414
  604933
  605183
  607530
  607694
  607709
  617032
  624341
  697000
  718678
  752661
  763724
  791489
  805139
  805144
  805146
  810831
  820656
  823695
]
1.70 ms
(0.50%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature татуированные соло"
]
1.57 ms
(0.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.44%)
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.