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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.97 ms
(84.52%)
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
  129640
  186858
  191698
  390051
  391581
  391666
  391931
  409152
  418954
  425578
  426416
  429552
  441068
  443744
  445401
  445661
  446109
  448968
  449691
  450377
  453441
  454415
  456312
  456611
  458312
  460172
  467348
  469150
  469300
  469472
  474461
  478617
  479522
  483628
  492643
  493174
  493191
  493229
  496041
  506278
  507144
  514445
  523136
  523590
  525561
  530325
  531836
  537576
  538007
  543135
  543680
  546617
  554888
  555226
  560699
  562357
  563066
  563232
  563830
  569145
  570972
  576540
  580283
  589659
  591910
  599998
  601076
  604208
  624936
  629739
  629971
  663937
  673791
  692704
  700818
  702551
  714539
  714655
  718581
  723659
  726606
  731552
  734309
  737049
  740567
  745335
  753656
  759009
  760690
  761246
  768394
  771145
  771730
  775064
  779599
  788031
  790337
  791332
  794872
  795960
  797175
  797345
  797500
  801451
  801912
  804153
  805635
  805689
  814678
  815912
  816508
  816932
  817181
  820134
  823933
  826710
  826938
  828472
  828520
  828874
]
16.87 ms
(9.32%)
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
  530325
  555226
  663937
  629971
  629739
  797500
  791332
  456611
  624936
  429552
  523590
  563066
  426416
  714655
  589659
  599998
  601076
  775064
  794872
  797175
  779599
  391581
  525561
  469300
  460172
  469150
  591910
  456312
  391931
  543680
  814678
  554888
  692704
  700818
  702551
  801912
  740567
  760690
  771730
  446109
  537576
  469472
  483628
  191698
  828520
  828472
  563830
  788031
  771145
  506278
  453441
  443744
  445401
  563232
  673791
  479522
  458312
  493191
  493174
  514445
  538007
  129640
  445661
  474461
  391666
  441068
  449691
  493229
  448968
  467348
  560699
  562357
  797345
  805635
  478617
  523136
  496041
  492643
  543135
  761246
  714539
  801451
  726606
  828874
  450377
  454415
  425578
  569145
  418954
  570972
  718581
  186858
  815912
  816508
  759009
  390051
  820134
  823933
  546617
  804153
  790337
  745335
  409152
  723659
  826710
  817181
  826938
  816932
  507144
  531836
  580283
  576540
  604208
  805689
  737049
  795960
  734309
  753656
  768394
  731552
]
3.70 ms
(2.04%)
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
  129640
  186858
  191698
  390051
  391581
  391666
  391931
  409152
  418954
  425578
  426416
  429552
  441068
  443744
  445401
  445661
  446109
  448968
  449691
  450377
  453441
  454415
  456312
  456611
  458312
  460172
  467348
  469150
  469300
  469472
  474461
  478617
  479522
  483628
  492643
  493174
  493191
  493229
  496041
  506278
  507144
  514445
  523136
  523590
  525561
  530325
  531836
  537576
  538007
  543135
  543680
  546617
  554888
  555226
  560699
  562357
  563066
  563232
  563830
  569145
  570972
  576540
  580283
  589659
  591910
  599998
  601076
  604208
  624936
  629739
  629971
  663937
  673791
  692704
  700818
  702551
  714539
  714655
  718581
  723659
  726606
  731552
  734309
  737049
  740567
  745335
  753656
  759009
  760690
  761246
  768394
  771145
  771730
  775064
  779599
  788031
  790337
  791332
  794872
  795960
  797175
  797345
  797500
  801451
  801912
  804153
  805635
  805689
  814678
  815912
  816508
  816932
  817181
  820134
  823933
  826710
  826938
  828472
  828520
  828874
]
2.10 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ван мам женщин"
]
1.99 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bathroom mother"
]
1.74 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "ван мам женщин"
]
1.62 ms
(0.90%)
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.