GET https://search.jues.net/search/embeds/3?q=asian%20hairy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.24 ms
(54.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "asian hairy"
]
154.79 ms
(40.28%)
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
  163368
  212138
  381963
  384092
  386068
  389525
  392439
  393129
  396451
  396602
  396989
  398105
  399018
  401509
  406907
  416143
  419056
  423139
  428960
  429341
  429534
  442620
  446893
  457979
  458545
  460962
  463729
  473751
  476153
  476162
  495155
  496114
  505352
  512033
  512200
  512204
  513802
  516452
  516853
  525069
  540213
  546086
  546428
  550732
  550750
  550775
  551979
  551993
  551999
  552000
  552297
  552911
  552928
  554320
  556408
  558369
  559854
  559880
  559895
  559968
  565470
  572746
  584681
  585825
  591836
  591911
  591955
  595705
  600544
  600583
  600830
  603213
  605069
  606487
  607532
  607845
  610365
  617493
  619413
  619420
  619429
  619435
  619463
  622122
  622601
  622639
  623542
  623555
  628909
  634756
  634760
  637740
  651667
  664267
  671839
  688677
  690771
  694468
  696125
  702609
  712169
  712188
  712219
  718955
  720678
  737125
  737132
  737136
  737144
  742475
  749518
  754784
  755312
  759315
  781122
  802266
  802831
  810016
  818351
  825405
]
12.89 ms
(3.36%)
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
  540213
  512033
  516452
  550732
  651667
  712219
  664267
  694468
  550775
  572746
  619429
  634756
  595705
  619413
  622639
  591911
  802831
  810016
  737132
  607532
  720678
  396989
  423139
  399018
  818351
  525069
  496114
  546428
  552297
  690771
  696125
  712188
  550750
  559880
  622122
  600830
  637740
  607845
  606487
  781122
  749518
  742475
  755312
  617493
  623555
  389525
  825405
  446893
  513802
  512200
  546086
  702609
  559854
  591836
  591955
  600583
  428960
  476153
  398105
  512204
  559895
  603213
  381963
  622601
  396451
  429341
  386068
  163368
  473751
  516853
  460962
  552928
  551993
  552000
  556408
  559968
  554320
  565470
  712169
  718955
  551999
  585825
  628909
  610365
  600544
  619420
  619435
  605069
  802266
  737125
  634760
  463729
  393129
  457979
  416143
  406907
  737136
  384092
  392439
  429534
  442620
  558369
  584681
  671839
  688677
  619463
  623542
  759315
  737144
  754784
  458545
  476162
  551979
  401509
  396602
  212138
  419056
  495155
  505352
  552911
]
3.41 ms
(0.89%)
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
  163368
  212138
  381963
  384092
  386068
  389525
  392439
  393129
  396451
  396602
  396989
  398105
  399018
  401509
  406907
  416143
  419056
  423139
  428960
  429341
  429534
  442620
  446893
  457979
  458545
  460962
  463729
  473751
  476153
  476162
  495155
  496114
  505352
  512033
  512200
  512204
  513802
  516452
  516853
  525069
  540213
  546086
  546428
  550732
  550750
  550775
  551979
  551993
  551999
  552000
  552297
  552911
  552928
  554320
  556408
  558369
  559854
  559880
  559895
  559968
  565470
  572746
  584681
  585825
  591836
  591911
  591955
  595705
  600544
  600583
  600830
  603213
  605069
  606487
  607532
  607845
  610365
  617493
  619413
  619420
  619429
  619435
  619463
  622122
  622601
  622639
  623542
  623555
  628909
  634756
  634760
  637740
  651667
  664267
  671839
  688677
  690771
  694468
  696125
  702609
  712169
  712188
  712219
  718955
  720678
  737125
  737132
  737136
  737144
  742475
  749518
  754784
  755312
  759315
  781122
  802266
  802831
  810016
  818351
  825405
]
1.82 ms
(0.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "азиатк волосатая"
]
1.69 ms
(0.44%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(0.38%)
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.