GET https://search.jues.net/search/embeds/6?q=%D0%B6%D0%B5%D0%BD%D1%8F%20%D0%BC%D0%B0%D0%BC%D0%BA%D0%B8

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.36 ms
(87.47%)
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
  391296
  398385
  457600
  478103
  478621
  493681
  495059
  500086
  510056
  529337
  530464
  533793
  535617
  535856
  536066
  536429
  536623
  540565
  542865
  542986
  543555
  544262
  544878
  545175
  546486
  552816
  555473
  562465
  564294
  566379
  566396
  566767
  583546
  584247
  592282
  600499
  603291
  603680
  618124
  621622
  630680
  637497
  651753
  656841
  658434
  663516
  669262
  670754
  671905
  681747
  685118
  702355
  702359
  707383
  710220
  713425
  715587
  722298
  724570
  727655
  730962
  732123
  732224
  732865
  732931
  733057
  734153
  734177
  744480
  744764
  745784
  747197
  748469
  748477
  759698
  760394
  760851
  761001
  763426
  769524
  774064
  780371
  787247
  788010
  788653
  794172
  794562
  795196
  795476
  795861
  796781
  796784
  798723
  801381
  801567
  802159
  804942
  808243
  816177
  824129
  824615
  827687
  828074
  828106
  828122
  828142
  828181
  828255
  828296
  828351
  828374
  828444
  828555
  828614
  828659
  828665
  828687
  828739
  828832
]
10.80 ms
(6.68%)
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
  828832
  828106
  828374
  828739
  828074
  828296
  828122
  828142
  828181
  828351
  824129
  828255
  827687
  828659
  828665
  828687
  828614
  828444
  478621
  478103
  535617
  536623
  535856
  510056
  530464
  536066
  500086
  544262
  546486
  552816
  555473
  583546
  566379
  542865
  566396
  651753
  670754
  671905
  681747
  722298
  710220
  656841
  658434
  669262
  685118
  713425
  715587
  592282
  600499
  603291
  637497
  621622
  603680
  618124
  630680
  780371
  788010
  795476
  798723
  801567
  788653
  794562
  795196
  802159
  744764
  748477
  761367
  787247
  794172
  795861
  796781
  804942
  808243
  727655
  730962
  732931
  734153
  745784
  759698
  760851
  761001
  724570
  733057
  747197
  769524
  734177
  760394
  763426
  774064
  732224
  732865
  744480
  748469
  702355
  702359
  796784
  536429
  663516
  707383
  584247
  391296
  732123
  801381
  457600
  543555
  398385
  816177
  824615
  828555
  493681
  529337
  533793
  540565
  495059
  542986
  562465
  566767
  544878
  545175
  564294
]
3.03 ms
(1.87%)
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
  391296
  398385
  457600
  478103
  478621
  493681
  495059
  500086
  510056
  529337
  530464
  533793
  535617
  535856
  536066
  536429
  536623
  540565
  542865
  542986
  543555
  544262
  544878
  545175
  546486
  552816
  555473
  562465
  564294
  566379
  566396
  566767
  583546
  584247
  592282
  600499
  603291
  603680
  618124
  621622
  630680
  637497
  651753
  656841
  658434
  663516
  669262
  670754
  671905
  681747
  685118
  702355
  702359
  707383
  710220
  713425
  715587
  722298
  724570
  727655
  730962
  732123
  732224
  732865
  732931
  733057
  734153
  734177
  744480
  744764
  745784
  747197
  748469
  748477
  759698
  760394
  760851
  761001
  763426
  769524
  774064
  780371
  787247
  788010
  788653
  794172
  794562
  795196
  795476
  795861
  796781
  796784
  798723
  801381
  801567
  802159
  804942
  808243
  816177
  824129
  824615
  827687
  828074
  828106
  828122
  828142
  828181
  828255
  828296
  828351
  828374
  828444
  828555
  828614
  828659
  828665
  828687
  828739
  828832
]
1.89 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "женя мамки"
]
1.60 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен мам женщин"
]
1.37 ms
(0.85%)
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.