GET https://search.jues.net/search/embeds/10?q=wife%20real

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
168.83 ms
(87.30%)
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
  4274
  83499
  388542
  392978
  397089
  397900
  398579
  400906
  404000
  418900
  424757
  425574
  426897
  428180
  432743
  438506
  440580
  440963
  441109
  441755
  443166
  446649
  450275
  456828
  457019
  457113
  457187
  457376
  458804
  459650
  461867
  463239
  464251
  474242
  474502
  475653
  487176
  490157
  499083
  505897
  515381
  518383
  520790
  521000
  522438
  531380
  541167
  552473
  565032
  577541
  577678
  584365
  585899
  607964
  610121
  610309
  616072
  627357
  629843
  644188
  658124
  674263
  693227
  693799
  695084
  708533
  712393
  715129
  716303
  718811
  720124
  721102
  721241
  721249
  721610
  723622
  724475
  727564
  727896
  728779
  731224
  741076
  741382
  743559
  751507
  751925
  757715
  757776
  762369
  763529
  765394
  768650
  770591
  771819
  773313
  773740
  776194
  777327
  784284
  788359
  788377
  795075
  797709
  797719
  803309
  806697
  809706
  812732
  813667
  813842
  813863
  814762
  814763
  815993
  818835
  819938
  823177
  824320
  824868
]
14.05 ms
(7.26%)
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
  773313
  728779
  751925
  763529
  765394
  768650
  727564
  727896
  731224
  743559
  757715
  762369
  770591
  773740
  607964
  616072
  627357
  708533
  712393
  716303
  720124
  721610
  776194
  777327
  784284
  788359
  797709
  797719
  809706
  812732
  4274
  397900
  404000
  450275
  474242
  400906
  438506
  418900
  457187
  505897
  818835
  541167
  741382
  388542
  487176
  521000
  432743
  565032
  731666
  815993
  644188
  721102
  531380
  584365
  577678
  693227
  658124
  806697
  724475
  771819
  741076
  751507
  757776
  803309
  464251
  522438
  397089
  440580
  721249
  788377
  443166
  813667
  814762
  814763
  585899
  83499
  446649
  457113
  520790
  552473
  693799
  674263
  695084
  721241
  610121
  629843
  795075
  823177
  475653
  461867
  515381
  577541
  715129
  718811
  610309
  490157
  392978
  398579
  425574
  441755
  426897
  424757
  428180
  441109
  440963
  723622
  813842
  819938
  824320
  824868
  813863
  456828
  457019
  458804
  474502
  459650
  457376
  463239
  499083
  518383
]
3.54 ms
(1.83%)
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
  4274
  83499
  388542
  392978
  397089
  397900
  398579
  400906
  404000
  418900
  424757
  425574
  426897
  428180
  432743
  438506
  440580
  440963
  441109
  441755
  443166
  446649
  450275
  456828
  457019
  457113
  457187
  457376
  458804
  459650
  461867
  463239
  464251
  474242
  474502
  475653
  487176
  490157
  499083
  505897
  515381
  518383
  520790
  521000
  522438
  531380
  541167
  552473
  565032
  577541
  577678
  584365
  585899
  607964
  610121
  610309
  616072
  627357
  629843
  644188
  658124
  674263
  693227
  693799
  695084
  708533
  712393
  715129
  716303
  718811
  720124
  721102
  721241
  721249
  721610
  723622
  724475
  727564
  727896
  728779
  731224
  741076
  741382
  743559
  751507
  751925
  757715
  757776
  762369
  763529
  765394
  768650
  770591
  771819
  773313
  773740
  776194
  777327
  784284
  788359
  788377
  795075
  797709
  797719
  803309
  806697
  809706
  812732
  813667
  813842
  813863
  814762
  814763
  815993
  818835
  819938
  823177
  824320
  824868
]
1.86 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife real"
]
1.84 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен real"
]
1.43 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен real"
]

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.