GET https://search.jues.net/search/embeds/10?q=asian%20man

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.10 ms
(84.23%)
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
  31432
  405174
  422567
  422694
  422933
  422957
  456629
  457117
  457981
  459524
  460606
  463798
  464138
  464943
  473109
  485074
  485131
  489342
  504589
  505005
  507609
  513230
  516060
  517749
  520244
  528307
  532161
  532255
  533348
  534077
  534833
  539879
  541215
  543420
  543905
  545607
  546654
  546777
  546786
  550744
  554004
  556973
  556975
  558221
  559155
  564213
  565101
  565265
  565566
  566047
  566789
  568041
  568061
  569827
  580281
  586015
  587545
  587563
  588170
  588226
  592317
  592971
  595567
  595954
  596337
  596954
  597142
  597246
  597917
  598637
  598834
  600487
  600558
  601125
  605432
  606868
  614603
  619372
  619439
  619475
  620964
  623615
  623617
  623809
  623814
  624814
  626795
  631572
  637689
  638327
  649163
  663537
  666968
  706945
  709117
  713520
  713532
  713547
  713551
  713569
  713834
  717860
  736421
  736738
  737124
  742484
  745663
  750876
  761585
  766625
  769337
  774000
  790957
  804776
  807688
  807716
  810995
  811340
  814223
  816260
]
16.00 ms
(8.86%)
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
  586015
  596337
  597917
  598834
  626795
  587563
  595954
  631572
  588226
  592317
  596954
  600487
  600558
  606868
  624814
  588170
  605432
  623814
  811340
  807716
  737124
  761585
  810995
  736421
  742484
  745663
  774000
  619372
  620964
  638327
  713834
  460606
  464943
  528307
  485074
  534077
  513230
  736738
  619475
  546786
  532255
  614603
  457981
  554004
  550744
  619439
  541215
  709117
  422933
  814223
  816260
  489342
  464138
  534833
  539879
  546777
  543905
  546654
  556975
  564213
  580281
  543420
  556973
  565265
  565566
  649163
  713520
  713569
  713532
  558221
  569827
  592971
  623809
  595567
  637689
  769337
  790957
  750876
  713547
  31432
  405174
  422567
  456629
  422957
  504589
  517749
  566789
  663537
  623615
  559155
  601125
  459524
  533348
  568061
  507609
  463798
  473109
  485131
  520244
  505005
  516060
  532161
  545607
  565101
  568041
  713551
  717860
  666968
  706945
  566047
  597142
  597246
  587545
  598637
  623617
  766625
  804776
  807688
  422694
  457117
]
4.32 ms
(2.39%)
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
  31432
  405174
  422567
  422694
  422933
  422957
  456629
  457117
  457981
  459524
  460606
  463798
  464138
  464943
  473109
  485074
  485131
  489342
  504589
  505005
  507609
  513230
  516060
  517749
  520244
  528307
  532161
  532255
  533348
  534077
  534833
  539879
  541215
  543420
  543905
  545607
  546654
  546777
  546786
  550744
  554004
  556973
  556975
  558221
  559155
  564213
  565101
  565265
  565566
  566047
  566789
  568041
  568061
  569827
  580281
  586015
  587545
  587563
  588170
  588226
  592317
  592971
  595567
  595954
  596337
  596954
  597142
  597246
  597917
  598637
  598834
  600487
  600558
  601125
  605432
  606868
  614603
  619372
  619439
  619475
  620964
  623615
  623617
  623809
  623814
  624814
  626795
  631572
  637689
  638327
  649163
  663537
  666968
  706945
  709117
  713520
  713532
  713547
  713551
  713569
  713834
  717860
  736421
  736738
  737124
  742484
  745663
  750876
  761585
  766625
  769337
  774000
  790957
  804776
  807688
  807716
  810995
  811340
  814223
  816260
]
2.27 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "asian man"
]
2.07 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.98 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "азиатк мужчин"
]
1.84 ms
(1.02%)
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.