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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.46 ms
(86.38%)
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
  145677
  172556
  187450
  212890
  263039
  383776
  402948
  403376
  413733
  415741
  423983
  428896
  435549
  450259
  453343
  465676
  466437
  472943
  509311
  511329
  511781
  513744
  514620
  520985
  521637
  523599
  524658
  530642
  540179
  543388
  545349
  553374
  556032
  561524
  570950
  576918
  577417
  578621
  580490
  582577
  589991
  591029
  591051
  591451
  591476
  591492
  591511
  591522
  596736
  603473
  603797
  604032
  605209
  610062
  622949
  623872
  629732
  629788
  633021
  642201
  642313
  646332
  648470
  649480
  652235
  664160
  668485
  670465
  670938
  671189
  671561
  672880
  672907
  674872
  704045
  705378
  706417
  717316
  726794
  736090
  736092
  739822
  739937
  742299
  743268
  743722
  744030
  744206
  745459
  749015
  750193
  750684
  751194
  751198
  753681
  754583
  754656
  755908
  759164
  763402
  764423
  765158
  766349
  780358
  782873
  786333
  789484
  793559
  796049
  799638
  804189
  807095
  808969
  810140
  810762
  811108
  814405
  816143
  817285
  823582
]
15.56 ms
(8.13%)
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
  402948
  187450
  523599
  513744
  521637
  450259
  466437
  383776
  212890
  145677
  263039
  403376
  415741
  816143
  814405
  817285
  823582
  465676
  514620
  511781
  530642
  509311
  520985
  524658
  540179
  561524
  577417
  580490
  582577
  545349
  543388
  553374
  556032
  570950
  646332
  649480
  670465
  670938
  671189
  672880
  674872
  704045
  717316
  648470
  668485
  672907
  706417
  652235
  664160
  671561
  576918
  578621
  589991
  604032
  622949
  633021
  591051
  596736
  623872
  629732
  591029
  591492
  591511
  629788
  642201
  591451
  591476
  591522
  603797
  642313
  780358
  782873
  786333
  796049
  799638
  807095
  810762
  789484
  808969
  810140
  811108
  744030
  749015
  751198
  754656
  755908
  764423
  793559
  739937
  742299
  750193
  763402
  765158
  745459
  751194
  753681
  754583
  726794
  736090
  736092
  739822
  743268
  743722
  744206
  750684
  759164
  766349
  603473
  605209
  610062
  705378
  804189
  423983
  428896
  172556
  435549
  413733
  511329
  453343
  472943
]
2.89 ms
(1.51%)
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
  145677
  172556
  187450
  212890
  263039
  383776
  402948
  403376
  413733
  415741
  423983
  428896
  435549
  450259
  453343
  465676
  466437
  472943
  509311
  511329
  511781
  513744
  514620
  520985
  521637
  523599
  524658
  530642
  540179
  543388
  545349
  553374
  556032
  561524
  570950
  576918
  577417
  578621
  580490
  582577
  589991
  591029
  591051
  591451
  591476
  591492
  591511
  591522
  596736
  603473
  603797
  604032
  605209
  610062
  622949
  623872
  629732
  629788
  633021
  642201
  642313
  646332
  648470
  649480
  652235
  664160
  668485
  670465
  670938
  671189
  671561
  672880
  672907
  674872
  704045
  705378
  706417
  717316
  726794
  736090
  736092
  739822
  739937
  742299
  743268
  743722
  744030
  744206
  745459
  749015
  750193
  750684
  751194
  751198
  753681
  754583
  754656
  755908
  759164
  763402
  764423
  765158
  766349
  780358
  782873
  786333
  789484
  793559
  796049
  799638
  804189
  807095
  808969
  810140
  810762
  811108
  814405
  816143
  817285
  823582
]
2.20 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo maid"
]
1.98 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.89 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло горничн"
]
1.56 ms
(0.81%)
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.