GET https://search.jues.net/search/embeds/9?q=bathroom%20mother

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.47 ms
(82.92%)
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
  3444
  23524
  24158
  146508
  187516
  213573
  310945
  351650
  392602
  396534
  396758
  404483
  407109
  407566
  436231
  437604
  439732
  440706
  447853
  448619
  450808
  451711
  452115
  454407
  456825
  457427
  458431
  458716
  459245
  463285
  465386
  465495
  465910
  465948
  467120
  470590
  470823
  472967
  473712
  474794
  478157
  480819
  481309
  484640
  485311
  490935
  492272
  493778
  504345
  507254
  509337
  527230
  531370
  532111
  534209
  534655
  547871
  549707
  552863
  553317
  557514
  563182
  568343
  578693
  581994
  587161
  589651
  591281
  591636
  592857
  601938
  606703
  606728
  610061
  615680
  641082
  661944
  666849
  667536
  668192
  670698
  684916
  704599
  709258
  711362
  716329
  718908
  719929
  720297
  721498
  740158
  742742
  745326
  746819
  747958
  766892
  767078
  780692
  786545
  788947
  793898
  794102
  795984
  796971
  798643
  799383
  802085
  804269
  805678
  806201
  807600
  811541
  815751
  818135
  818440
  818813
  823760
  825904
  828291
]
14.69 ms
(9.95%)
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
  447853
  458431
  459245
  527230
  465910
  553317
  780692
  766892
  440706
  451711
  480819
  481309
  436231
  470823
  437604
  454407
  456825
  478157
  490935
  3444
  146508
  24158
  825904
  818440
  818813
  534209
  581994
  718908
  670698
  704599
  811541
  796971
  711362
  786545
  794102
  23524
  213573
  474794
  485311
  557514
  592857
  719929
  493778
  396758
  591636
  465948
  470590
  818135
  568343
  661944
  709258
  804269
  802085
  187516
  828291
  828076
  547871
  458716
  716329
  740158
  351650
  815751
  606728
  641082
  798643
  806201
  747958
  465495
  448619
  473712
  472967
  507254
  509337
  534655
  552863
  578693
  666849
  668192
  667536
  549707
  587161
  606703
  799383
  392602
  396534
  504345
  450808
  615680
  463285
  407566
  452115
  404483
  407109
  467120
  531370
  563182
  720297
  684916
  610061
  591281
  805678
  788947
  746819
  795984
  742742
  745326
  767078
  793898
  807600
  465386
  310945
  823760
  532111
  721498
  589651
  601938
  439732
  457427
  484640
  492272
]
3.66 ms
(2.48%)
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
  3444
  23524
  24158
  146508
  187516
  213573
  310945
  351650
  392602
  396534
  396758
  404483
  407109
  407566
  436231
  437604
  439732
  440706
  447853
  448619
  450808
  451711
  452115
  454407
  456825
  457427
  458431
  458716
  459245
  463285
  465386
  465495
  465910
  465948
  467120
  470590
  470823
  472967
  473712
  474794
  478157
  480819
  481309
  484640
  485311
  490935
  492272
  493778
  504345
  507254
  509337
  527230
  531370
  532111
  534209
  534655
  547871
  549707
  552863
  553317
  557514
  563182
  568343
  578693
  581994
  587161
  589651
  591281
  591636
  592857
  601938
  606703
  606728
  610061
  615680
  641082
  661944
  666849
  667536
  668192
  670698
  684916
  704599
  709258
  711362
  716329
  718908
  719929
  720297
  721498
  740158
  742742
  745326
  746819
  747958
  766892
  767078
  780692
  786545
  788947
  793898
  794102
  795984
  796971
  798643
  799383
  802085
  804269
  805678
  806201
  807600
  811541
  815751
  818135
  818440
  818813
  823760
  825904
  828291
]
1.84 ms
(1.24%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bathroom mother"
]
1.68 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ван мам женщин"
]
1.56 ms
(1.06%)
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.