GET https://search.jues.net/search/embeds/6?q=solo%20doggy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
196.34 ms
(86.72%)
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
  4311
  54161
  186823
  269287
  280580
  382207
  387477
  391150
  391217
  392004
  392019
  393832
  396362
  397509
  398077
  405683
  415753
  416593
  416599
  417030
  419832
  424294
  430369
  435512
  435539
  435590
  438579
  440639
  443106
  444426
  448000
  452764
  456245
  464031
  465144
  465727
  466405
  467051
  467577
  467616
  468256
  468269
  468329
  469092
  469250
  470453
  470473
  471108
  471155
  475457
  476049
  479549
  479931
  480428
  480450
  480498
  482751
  483523
  484241
  485281
  487414
  493022
  496081
  499914
  500333
  502776
  508552
  509298
  513744
  517272
  518185
  518885
  526645
  528142
  530199
  531794
  531806
  537379
  539317
  544098
  545223
  554949
  555002
  555046
  556340
  570936
  583355
  583734
  615157
  623278
  623300
  628205
  629205
  643698
  661034
  675654
  716360
  717443
  722952
  742636
  747356
  750593
  751339
  752609
  755287
  756921
  757473
  761039
  768915
  782080
  784128
  791823
  799942
  804205
  807121
  809068
  821602
  826209
  826322
  827389
]
19.18 ms
(8.47%)
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
  750593
  751339
  755287
  756921
  757473
  768915
  615157
  623278
  629205
  643698
  716360
  717443
  722952
  782080
  784128
  791823
  799942
  804205
  807121
  4311
  269287
  742636
  761039
  393832
  392019
  382207
  391150
  405683
  416593
  438579
  443106
  430369
  435539
  435512
  415753
  424294
  440639
  444426
  583734
  482751
  465727
  467577
  468269
  469092
  479931
  487414
  448000
  467616
  468329
  469250
  500333
  544098
  555046
  556340
  545223
  555002
  583355
  675654
  554949
  570936
  623300
  752609
  397509
  416599
  452764
  464031
  480428
  417030
  465144
  471108
  479549
  392004
  466405
  471155
  480450
  419832
  467051
  470453
  470473
  468256
  476049
  518185
  528142
  484241
  526645
  485281
  493022
  502776
  508552
  517272
  483523
  499914
  518885
  456245
  661034
  628205
  809068
  747356
  480498
  435590
  513744
  186823
  280580
  54161
  387477
  391217
  396362
  398077
  821602
  826209
  826322
  827389
  475457
  496081
  530199
  537379
  539317
  509298
  531794
  531806
]
3.36 ms
(1.48%)
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
  4311
  54161
  186823
  269287
  280580
  382207
  387477
  391150
  391217
  392004
  392019
  393832
  396362
  397509
  398077
  405683
  415753
  416593
  416599
  417030
  419832
  424294
  430369
  435512
  435539
  435590
  438579
  440639
  443106
  444426
  448000
  452764
  456245
  464031
  465144
  465727
  466405
  467051
  467577
  467616
  468256
  468269
  468329
  469092
  469250
  470453
  470473
  471108
  471155
  475457
  476049
  479549
  479931
  480428
  480450
  480498
  482751
  483523
  484241
  485281
  487414
  493022
  496081
  499914
  500333
  502776
  508552
  509298
  513744
  517272
  518185
  518885
  526645
  528142
  530199
  531794
  531806
  537379
  539317
  544098
  545223
  554949
  555002
  555046
  556340
  570936
  583355
  583734
  615157
  623278
  623300
  628205
  629205
  643698
  661034
  675654
  716360
  717443
  722952
  742636
  747356
  750593
  751339
  752609
  755287
  756921
  757473
  761039
  768915
  782080
  784128
  791823
  799942
  804205
  807121
  809068
  821602
  826209
  826322
  827389
]
2.01 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.97 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo doggy"
]
1.81 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло рак"
]
1.72 ms
(0.76%)
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.