GET https://search.jues.net/search/embeds/3?q=stockings%20vintage

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.30 ms
(83.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
  511388
  519246
  538847
  538856
  538930
  538935
  538960
  539516
  541398
  541402
  542471
  542489
  544307
  544483
  544496
  544502
  544586
  546153
  547980
  548277
  549307
  549784
  554804
  556777
  557993
  560085
  560958
  561993
  563152
  563184
  563201
  563203
  563212
  563433
  563435
  564565
  565227
  566399
  567751
  572543
  572548
  573911
  574237
  574257
  574263
  574291
  576669
  576671
  576699
  576705
  581281
  581386
  583079
  583827
  583872
  589640
  592390
  592419
  592462
  592526
  592636
  593514
  598407
  603200
  606290
  606417
  610310
  612413
  615737
  620140
  620154
  621700
  623934
  644643
  644894
  644922
  648463
  649956
  653450
  654092
  665751
  668154
  670062
  670090
  670274
  671749
  671758
  671878
  672122
  673497
  674119
  677740
  690783
  690822
  691518
  692103
  692258
  692265
  694023
  695191
  695196
  695923
  696240
  696350
  698548
  703040
  703109
  703540
  705295
  708435
  714504
  719059
  724135
  727436
  735919
  772554
  772574
  791002
  807976
  811492
]
16.57 ms
(10.59%)
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
  563435
  583872
  592526
  772574
  772554
  549784
  544586
  593514
  542471
  583079
  620154
  598407
  564565
  574263
  554804
  566399
  574257
  563203
  560085
  538960
  539516
  538930
  538935
  556777
  583827
  544307
  541402
  549307
  565227
  648463
  649956
  692258
  695196
  695923
  703040
  694023
  698548
  705295
  665751
  677740
  695191
  563433
  606417
  621700
  592419
  620140
  603200
  615737
  791002
  811492
  727436
  724135
  735919
  703109
  714504
  544502
  567751
  563184
  690783
  589640
  644922
  572548
  563212
  671749
  672122
  703540
  563201
  592462
  623934
  606290
  644643
  807976
  519246
  574291
  612413
  576699
  573911
  576669
  560958
  581281
  544483
  544496
  557993
  574237
  576705
  581386
  690822
  670274
  546153
  548277
  561993
  563152
  572543
  592390
  610310
  592636
  511388
  541398
  644894
  538856
  538847
  542489
  547980
  576671
  671758
  691518
  692103
  696240
  696350
  708435
  719059
  668154
  653450
  654092
  670062
  670090
  671878
  673497
  674119
  692265
]
2.52 ms
(1.61%)
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
  511388
  519246
  538847
  538856
  538930
  538935
  538960
  539516
  541398
  541402
  542471
  542489
  544307
  544483
  544496
  544502
  544586
  546153
  547980
  548277
  549307
  549784
  554804
  556777
  557993
  560085
  560958
  561993
  563152
  563184
  563201
  563203
  563212
  563433
  563435
  564565
  565227
  566399
  567751
  572543
  572548
  573911
  574237
  574257
  574263
  574291
  576669
  576671
  576699
  576705
  581281
  581386
  583079
  583827
  583872
  589640
  592390
  592419
  592462
  592526
  592636
  593514
  598407
  603200
  606290
  606417
  610310
  612413
  615737
  620140
  620154
  621700
  623934
  644643
  644894
  644922
  648463
  649956
  653450
  654092
  665751
  668154
  670062
  670090
  670274
  671749
  671758
  671878
  672122
  673497
  674119
  677740
  690783
  690822
  691518
  692103
  692258
  692265
  694023
  695191
  695196
  695923
  696240
  696350
  698548
  703040
  703109
  703540
  705295
  708435
  714504
  719059
  724135
  727436
  735919
  772554
  772574
  791002
  807976
  811492
]
1.90 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "stockings vintage"
]
1.88 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "чулк нижн бел vintage"
]
1.68 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "чулк нижн бел vintage"
]

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.