GET https://search.jues.net/search/embeds/8?q=mother%20bed

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.79 ms
(83.23%)
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
  330511
  382074
  384470
  386532
  387579
  388523
  388726
  390947
  391656
  394785
  396911
  397232
  398936
  401333
  401961
  402526
  407533
  413128
  414601
  415937
  417241
  418533
  426741
  428843
  431594
  435747
  437121
  439487
  443360
  443677
  443711
  446820
  447061
  447145
  450250
  452787
  457348
  458117
  458721
  458727
  459636
  460707
  460745
  461970
  462001
  462586
  462599
  463334
  465119
  466272
  466852
  468277
  468350
  468364
  469420
  469617
  469952
  470785
  471993
  472016
  477188
  479122
  480012
  480254
  482230
  482443
  483576
  483725
  485432
  487286
  488466
  490142
  493888
  497509
  501526
  502784
  504898
  506178
  508706
  509219
  509575
  509821
  514751
  516977
  518763
  525655
  527154
  536416
  541119
  545179
  545511
  547577
  559105
  563993
  564252
  564703
  566014
  567214
  573193
  573757
  577419
  586376
  589814
  590426
  591353
  593676
  599710
  604616
  613837
  637203
  647105
  666966
  671889
  671896
  678691
  683565
  813608
  819366
  824817
  828001
]
14.74 ms
(9.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
  819366
  824817
  828001
  604616
  396911
  460745
  466272
  384470
  435747
  482443
  469420
  480254
  490142
  469617
  485432
  497509
  518763
  573757
  573193
  566014
  683565
  547577
  599710
  591353
  462599
  470785
  401333
  462586
  477188
  461970
  443677
  479122
  482230
  504898
  509821
  506178
  509219
  401961
  402526
  813608
  460707
  483576
  536416
  527154
  462001
  488466
  671896
  666966
  678691
  589814
  330511
  480012
  388523
  390947
  431594
  426741
  437121
  516977
  483725
  487286
  386532
  391656
  394785
  387579
  397232
  428843
  415937
  418533
  417241
  439487
  447061
  447145
  458721
  463334
  465119
  468350
  469952
  446820
  458727
  466852
  468277
  468364
  509575
  514751
  501526
  502784
  541119
  564703
  545511
  564252
  577419
  545179
  559105
  563993
  647105
  671889
  567214
  586376
  613837
  637203
  590426
  593676
  382074
  458117
  472016
  407533
  443360
  443711
  471993
  398936
  459636
  413128
  457348
  414601
  493888
  525655
  508706
  388726
  450250
  452787
]
2.82 ms
(1.85%)
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
  330511
  382074
  384470
  386532
  387579
  388523
  388726
  390947
  391656
  394785
  396911
  397232
  398936
  401333
  401961
  402526
  407533
  413128
  414601
  415937
  417241
  418533
  426741
  428843
  431594
  435747
  437121
  439487
  443360
  443677
  443711
  446820
  447061
  447145
  450250
  452787
  457348
  458117
  458721
  458727
  459636
  460707
  460745
  461970
  462001
  462586
  462599
  463334
  465119
  466272
  466852
  468277
  468350
  468364
  469420
  469617
  469952
  470785
  471993
  472016
  477188
  479122
  480012
  480254
  482230
  482443
  483576
  483725
  485432
  487286
  488466
  490142
  493888
  497509
  501526
  502784
  504898
  506178
  508706
  509219
  509575
  509821
  514751
  516977
  518763
  525655
  527154
  536416
  541119
  545179
  545511
  547577
  559105
  563993
  564252
  564703
  566014
  567214
  573193
  573757
  577419
  586376
  589814
  590426
  591353
  593676
  599710
  604616
  613837
  637203
  647105
  666966
  671889
  671896
  678691
  683565
  813608
  819366
  824817
  828001
]
2.21 ms
(1.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин постел"
]
2.16 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother bed"
]
1.91 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин постел"
]
1.72 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.