GET https://search.jues.net/search/embeds/4?q=wife%20kitchen

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
173.44 ms
(84.21%)
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
  382215
  396826
  400811
  459933
  462215
  474950
  488224
  490525
  494642
  500007
  500576
  503985
  506079
  517282
  520359
  532138
  536934
  542292
  543306
  545924
  546272
  549534
  549717
  552552
  554985
  559237
  561886
  562620
  563016
  565774
  566094
  566880
  569023
  572882
  578691
  581581
  584639
  591028
  591029
  591218
  591452
  591468
  591503
  591550
  591559
  591566
  593821
  596980
  610112
  613559
  622750
  628075
  634892
  635034
  641414
  642245
  642281
  642288
  646610
  652750
  656672
  664483
  670948
  673256
  675344
  684684
  685411
  685516
  685519
  689545
  691793
  701213
  702641
  703587
  705074
  705306
  705307
  705321
  711737
  713997
  714929
  715364
  716004
  724090
  724848
  727764
  734358
  736010
  742763
  746097
  749363
  751680
  754173
  756872
  757113
  757247
  757303
  767972
  778191
  778488
  778667
  779315
  788603
  789374
  789451
  789604
  793236
  793599
  794215
  795448
  801436
  801455
  804405
  804978
  805098
  808296
  808310
  813939
]
21.01 ms
(10.20%)
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
  705074
  705307
  675344
  688681
  646610
  652750
  670948
  673256
  685411
  691793
  705321
  715364
  622750
  635034
  642281
  788603
  789604
  793236
  801455
  776183
  778191
  779315
  793599
  794215
  801436
  808310
  746097
  749363
  724090
  734358
  736010
  751680
  757303
  767972
  756872
  711737
  778667
  789374
  789451
  795448
  804978
  808296
  500007
  684684
  701213
  724848
  396826
  813939
  716004
  591029
  805098
  757247
  727764
  742763
  757113
  804405
  400811
  459933
  488224
  494642
  506079
  500576
  517282
  520359
  503985
  532138
  543306
  554985
  584639
  549534
  549717
  561886
  563016
  566880
  569023
  572882
  565774
  656672
  591028
  591566
  610112
  591452
  591218
  591468
  591550
  641414
  474950
  754173
  462215
  578691
  559237
  581581
  685519
  703587
  634892
  591559
  628075
  642288
  778488
  382215
  490525
  536934
  542292
  566094
  546272
  552552
  545924
  562620
  685516
  664483
  705306
  713997
  714929
  689545
  702641
  591503
  593821
  642245
  596980
  613559
]
3.79 ms
(1.84%)
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
  382215
  396826
  400811
  459933
  462215
  474950
  488224
  490525
  494642
  500007
  500576
  503985
  506079
  517282
  520359
  532138
  536934
  542292
  543306
  545924
  546272
  549534
  549717
  552552
  554985
  559237
  561886
  562620
  563016
  565774
  566094
  566880
  569023
  572882
  578691
  581581
  584639
  591028
  591029
  591218
  591452
  591468
  591503
  591550
  591559
  591566
  593821
  596980
  610112
  613559
  622750
  628075
  634892
  635034
  641414
  642245
  642281
  642288
  646610
  652750
  656672
  664483
  670948
  673256
  675344
  684684
  685411
  685516
  685519
  689545
  691793
  701213
  702641
  703587
  705074
  705306
  705307
  705321
  711737
  713997
  714929
  715364
  716004
  724090
  724848
  727764
  734358
  736010
  742763
  746097
  749363
  751680
  754173
  756872
  757113
  757247
  757303
  767972
  778191
  778488
  778667
  779315
  788603
  789374
  789451
  789604
  793236
  793599
  794215
  795448
  801436
  801455
  804405
  804978
  805098
  808296
  808310
  813939
]
2.18 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife kitchen"
]
1.98 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен кухн"
]
1.69 ms
(0.82%)
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.