GET https://search.jues.net/search/embeds/3?q=doggy%20hair

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.17 ms
(86.96%)
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
  365978
  385969
  411913
  418907
  420642
  421435
  423304
  424284
  436020
  443938
  444218
  447306
  447779
  448734
  448771
  450285
  458193
  459418
  466703
  467603
  473827
  480083
  483767
  486635
  488684
  494313
  494893
  502934
  502999
  504347
  505569
  512429
  514046
  520582
  526683
  532306
  538099
  538396
  538448
  539145
  541952
  550268
  553620
  558226
  559672
  560276
  560314
  560555
  561179
  562456
  562709
  568019
  572566
  578135
  583323
  585638
  595245
  597678
  597847
  602111
  602635
  603564
  606354
  612644
  617953
  619829
  621289
  624100
  639124
  648885
  660454
  661769
  663721
  663883
  664634
  667150
  668183
  680281
  702310
  704594
  707419
  707459
  708063
  708677
  712449
  712610
  715476
  717433
  720163
  726897
  727874
  729115
  732500
  738751
  740815
  740961
  746645
  749607
  751842
  757522
  759073
  763431
  769296
  771316
  778415
  779360
  792022
  792406
  795776
  797840
  799742
  799825
  799830
  800988
  810940
  811527
  820174
  826395
  828804
]
14.17 ms
(8.10%)
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
  447306
  505569
  385969
  467603
  488684
  562456
  512429
  494893
  421435
  448771
  826395
  365978
  418907
  424284
  443938
  486635
  448734
  526683
  538099
  539145
  520582
  538448
  502934
  502999
  480083
  559672
  578135
  553620
  558226
  661769
  663883
  667150
  680281
  702310
  664634
  708677
  648885
  660454
  708063
  560555
  572566
  595245
  603564
  612644
  621289
  585638
  597847
  639124
  799825
  799830
  811527
  779360
  746645
  769296
  783461
  792406
  757522
  726897
  738751
  763431
  729115
  740961
  751842
  771316
  727874
  732500
  740815
  749607
  619829
  704594
  707459
  795776
  473827
  447779
  450285
  458193
  483767
  538396
  828804
  707419
  800988
  792022
  810940
  560314
  504347
  514046
  799742
  797840
  820174
  568019
  712610
  561179
  624100
  759073
  778415
  423304
  420642
  444218
  436020
  411913
  459418
  466703
  532306
  494313
  550268
  583323
  541952
  560276
  663721
  715476
  720163
  712449
  717433
  668183
  562709
  602111
  606354
  617953
  597678
  602635
]
2.33 ms
(1.33%)
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
  365978
  385969
  411913
  418907
  420642
  421435
  423304
  424284
  436020
  443938
  444218
  447306
  447779
  448734
  448771
  450285
  458193
  459418
  466703
  467603
  473827
  480083
  483767
  486635
  488684
  494313
  494893
  502934
  502999
  504347
  505569
  512429
  514046
  520582
  526683
  532306
  538099
  538396
  538448
  539145
  541952
  550268
  553620
  558226
  559672
  560276
  560314
  560555
  561179
  562456
  562709
  568019
  572566
  578135
  583323
  585638
  595245
  597678
  597847
  602111
  602635
  603564
  606354
  612644
  617953
  619829
  621289
  624100
  639124
  648885
  660454
  661769
  663721
  663883
  664634
  667150
  668183
  680281
  702310
  704594
  707419
  707459
  708063
  708677
  712449
  712610
  715476
  717433
  720163
  726897
  727874
  729115
  732500
  738751
  740815
  740961
  746645
  749607
  751842
  757522
  759073
  763431
  769296
  771316
  778415
  779360
  792022
  792406
  795776
  797840
  799742
  799825
  799830
  800988
  810940
  811527
  820174
  826395
  828804
]
1.91 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "doggy hair"
]
1.65 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рак hair"
]
1.43 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "рак hair"
]
1.32 ms
(0.75%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.