GET https://search.jues.net/search/embeds/9?q=mom%20brunette

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
169.14 ms
(87.83%)
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
  521217
  532051
  533345
  536323
  536706
  537233
  537624
  539649
  543647
  549145
  550328
  556825
  558751
  559156
  561445
  562911
  563310
  569525
  571195
  579769
  585633
  589646
  589894
  591120
  592490
  593493
  596128
  597898
  598358
  598384
  600783
  605233
  605362
  606384
  607286
  612991
  615395
  619431
  624447
  627153
  629256
  629852
  634559
  639642
  644016
  645992
  668156
  671628
  674256
  676581
  680833
  680888
  681837
  687572
  689682
  690774
  698038
  698859
  699540
  699764
  703795
  705256
  708960
  713612
  714340
  718965
  721692
  727738
  741194
  741309
  742007
  758287
  760733
  776741
  777228
  779608
  779793
  781832
  782665
  783308
  784559
  787715
  788961
  789474
  789504
  789599
  797638
  799533
  799986
  800416
  801170
  801884
  805719
  807431
  807726
  809412
  810801
  812657
  815120
  815564
  815777
  816501
  816880
  816904
  817333
  817366
  817840
  817859
  818215
  819711
  820052
  820392
  820744
  821083
  823118
  823272
  823522
  824023
  824618
  826860
]
12.39 ms
(6.44%)
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
  816880
  817859
  820052
  820392
  823118
  823272
  823522
  824023
  815120
  815564
  815777
  816501
  816904
  817333
  817366
  817840
  818215
  819711
  820744
  821083
  824618
  826860
  521217
  536706
  539649
  536323
  537233
  533345
  532051
  537624
  558751
  559156
  563310
  569525
  543647
  579769
  668156
  671628
  690774
  708960
  713612
  714340
  718965
  721692
  674256
  676581
  680833
  698859
  699540
  699764
  645992
  680888
  681837
  687572
  689682
  698038
  703795
  705256
  549145
  550328
  556825
  561445
  562911
  571195
  591120
  592490
  598384
  606384
  629256
  596128
  598358
  607286
  612991
  615395
  585633
  589646
  589894
  593493
  597898
  605233
  619431
  624447
  629852
  639642
  600783
  605362
  627153
  634559
  644016
  776741
  779793
  781832
  782665
  788961
  789599
  799986
  800416
  801170
  807431
  809412
  810801
  812657
  777228
  779608
  784559
  789474
  789504
  797638
  799533
  801884
  805719
  807726
  727738
  741194
  741309
  742007
  758287
  760733
  783308
  787715
]
3.25 ms
(1.69%)
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
  521217
  532051
  533345
  536323
  536706
  537233
  537624
  539649
  543647
  549145
  550328
  556825
  558751
  559156
  561445
  562911
  563310
  569525
  571195
  579769
  585633
  589646
  589894
  591120
  592490
  593493
  596128
  597898
  598358
  598384
  600783
  605233
  605362
  606384
  607286
  612991
  615395
  619431
  624447
  627153
  629256
  629852
  634559
  639642
  644016
  645992
  668156
  671628
  674256
  676581
  680833
  680888
  681837
  687572
  689682
  690774
  698038
  698859
  699540
  699764
  703795
  705256
  708960
  713612
  714340
  718965
  721692
  727738
  741194
  741309
  742007
  758287
  760733
  776741
  777228
  779608
  779793
  781832
  782665
  783308
  784559
  787715
  788961
  789474
  789504
  789599
  797638
  799533
  799986
  800416
  801170
  801884
  805719
  807431
  807726
  809412
  810801
  812657
  815120
  815564
  815777
  816501
  816880
  816904
  817333
  817366
  817840
  817859
  818215
  819711
  820052
  820392
  820744
  821083
  823118
  823272
  823522
  824023
  824618
  826860
]
2.18 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom brunette"
]
1.95 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom черноволосая"
]
1.90 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom черноволосая"
]

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.