GET https://search.jues.net/search/embeds/5?q=sleeping%20pov

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
117.77 ms
(80.36%)
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
  415425
  417854
  419093
  419265
  419330
  421792
  423642
  425560
  426080
  427282
  427291
  428798
  434057
  435020
  437352
  437613
  437634
  440690
  440702
  440817
  441666
  442415
  442458
  445859
  446469
  448722
  449719
  449849
  450585
  451056
  451162
  454538
  454650
  455002
  455635
  456234
  457513
  458317
  460033
  460318
  463047
  463207
  464176
  464796
  465762
  466083
  476952
  477408
  479606
  480028
  480963
  481794
  483657
  484943
  485432
  489099
  490468
  490755
  492137
  492474
  505549
  505998
  508626
  512846
  516783
  521845
  523451
  523760
  524040
  524285
  525151
  525173
  527260
  529252
  544663
  545319
  560869
  561946
  562868
  563003
  563112
  563544
  564093
  568368
  568539
  570712
  571700
  572718
  572976
  578838
  579956
  583269
  583786
  585170
  588577
  601988
  603800
  609681
  618982
  623230
  626919
  629195
  668717
  672837
  682363
  686459
  687259
  696603
  723926
  729170
  755613
  756711
  756877
  763955
  773432
  778021
  795287
  814230
  818090
  826330
]
17.85 ms
(12.18%)
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
  512846
  529252
  544663
  563544
  523451
  419330
  419093
  442458
  440690
  441666
  814230
  818090
  456234
  483657
  446469
  455002
  464176
  490755
  454650
  480963
  525151
  521845
  527260
  463047
  568368
  583269
  570712
  562868
  563003
  563112
  564093
  572718
  572976
  578838
  682363
  687259
  668717
  545319
  568539
  571700
  629195
  588577
  623230
  626919
  585170
  603800
  778021
  795287
  723926
  756877
  763955
  756711
  773432
  434057
  480028
  479606
  417854
  425560
  457513
  460033
  476952
  449719
  466083
  489099
  508626
  451162
  492137
  523760
  437613
  455635
  465762
  435020
  484943
  524285
  686459
  696603
  729170
  755613
  481794
  524040
  561946
  560869
  583786
  672837
  579956
  601988
  609681
  618982
  421792
  428798
  415425
  419265
  423642
  426080
  440702
  440817
  442415
  427282
  427291
  437352
  437634
  826330
  445859
  448722
  450585
  460318
  463207
  477408
  490468
  449849
  451056
  458317
  464796
  492474
  454538
  485432
  505549
  505998
  516783
  525173
]
2.67 ms
(1.82%)
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
  415425
  417854
  419093
  419265
  419330
  421792
  423642
  425560
  426080
  427282
  427291
  428798
  434057
  435020
  437352
  437613
  437634
  440690
  440702
  440817
  441666
  442415
  442458
  445859
  446469
  448722
  449719
  449849
  450585
  451056
  451162
  454538
  454650
  455002
  455635
  456234
  457513
  458317
  460033
  460318
  463047
  463207
  464176
  464796
  465762
  466083
  476952
  477408
  479606
  480028
  480963
  481794
  483657
  484943
  485432
  489099
  490468
  490755
  492137
  492474
  505549
  505998
  508626
  512846
  516783
  521845
  523451
  523760
  524040
  524285
  525151
  525173
  527260
  529252
  544663
  545319
  560869
  561946
  562868
  563003
  563112
  563544
  564093
  568368
  568539
  570712
  571700
  572718
  572976
  578838
  579956
  583269
  583786
  585170
  588577
  601988
  603800
  609681
  618982
  623230
  626919
  629195
  668717
  672837
  682363
  686459
  687259
  696603
  723926
  729170
  755613
  756711
  756877
  763955
  773432
  778021
  795287
  814230
  818090
  826330
]
2.54 ms
(1.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sleeping pov"
]
2.16 ms
(1.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "спящ пов"
]
1.81 ms
(1.24%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(1.19%)
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.