GET https://search.jues.net/search/embeds/4?q=delicious%20girls

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
177.10 ms
(85.49%)
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
  384556
  414114
  422936
  426307
  444712
  451141
  451247
  451816
  452592
  456703
  457186
  463067
  465345
  468190
  469580
  470449
  470599
  472025
  472493
  472569
  476676
  482454
  485145
  485336
  487633
  496470
  496674
  498254
  499426
  500758
  502803
  504713
  504765
  505806
  508158
  511793
  512574
  513699
  513705
  514997
  520460
  522235
  523882
  525204
  525441
  526904
  527377
  528699
  528702
  530452
  531804
  533390
  535426
  535578
  535580
  536378
  538498
  539294
  540252
  544898
  549769
  553720
  555742
  556345
  557377
  565313
  566862
  573407
  575932
  579825
  582920
  588454
  589304
  591056
  591141
  592095
  595956
  597025
  603713
  604387
  605108
  607477
  614443
  621729
  624456
  625893
  629457
  633468
  648370
  667002
  668685
  682273
  684637
  691820
  707539
  712475
  726543
  726713
  737188
  738030
  747188
  755030
  764490
  766869
  779506
  782259
  785096
  789002
  795757
  805179
  812361
  814210
  814235
  814265
  814501
  817917
]
17.71 ms
(8.55%)
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
  782259
  487633
  504713
  530452
  556345
  472025
  456703
  814210
  538498
  540252
  549769
  555742
  557377
  648370
  712475
  625893
  779506
  814501
  451247
  463067
  496470
  535580
  531804
  535426
  579825
  691820
  575932
  595956
  607477
  624456
  766869
  605108
  444712
  512574
  485336
  812361
  814265
  536378
  566862
  785096
  513705
  817917
  457186
  511793
  684637
  682273
  589304
  795757
  737188
  747188
  738030
  470599
  513699
  451141
  485145
  526904
  472493
  522235
  468190
  614443
  755030
  764490
  707539
  525204
  789002
  414114
  504765
  668685
  588454
  384556
  472569
  498254
  505806
  544898
  582920
  592095
  805179
  726713
  452592
  499426
  502803
  629457
  535578
  621729
  496674
  500758
  422936
  553720
  604387
  426307
  539294
  533390
  565313
  667002
  469580
  451816
  470449
  527377
  482454
  633468
  814235
  573407
  528699
  726543
  465345
  528702
  508158
  603713
  520460
  476676
  591141
  525441
  597025
  523882
  591056
  514997
]
4.70 ms
(2.27%)
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
  384556
  414114
  422936
  426307
  444712
  451141
  451247
  451816
  452592
  456703
  457186
  463067
  465345
  468190
  469580
  470449
  470599
  472025
  472493
  472569
  476676
  482454
  485145
  485336
  487633
  496470
  496674
  498254
  499426
  500758
  502803
  504713
  504765
  505806
  508158
  511793
  512574
  513699
  513705
  514997
  520460
  522235
  523882
  525204
  525441
  526904
  527377
  528699
  528702
  530452
  531804
  533390
  535426
  535578
  535580
  536378
  538498
  539294
  540252
  544898
  549769
  553720
  555742
  556345
  557377
  565313
  566862
  573407
  575932
  579825
  582920
  588454
  589304
  591056
  591141
  592095
  595956
  597025
  603713
  604387
  605108
  607477
  614443
  621729
  624456
  625893
  629457
  633468
  648370
  667002
  668685
  682273
  684637
  691820
  707539
  712475
  726543
  726713
  737188
  738030
  747188
  755030
  764490
  766869
  779506
  782259
  785096
  789002
  795757
  805179
  812361
  814210
  814235
  814265
  814501
  817917
]
2.05 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "delicious girls"
]
1.99 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "delicious девушк"
]
1.87 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "delicious девушк"
]

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.