GET https://search.jues.net/search/embeds/9?q=vagina%20red

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.65 ms
(89.07%)
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
  8518
  23696
  45306
  233446
  396055
  426352
  433582
  434326
  435498
  437738
  442236
  442947
  450886
  451255
  451592
  452230
  454190
  456906
  457528
  461411
  462224
  462833
  463655
  464556
  467761
  468704
  470995
  473322
  475352
  476315
  476513
  483822
  486787
  489842
  494545
  505549
  505551
  507133
  509593
  518309
  528129
  529901
  535341
  536463
  539572
  542767
  542951
  544941
  549797
  550006
  557097
  558324
  563065
  566780
  569420
  569982
  572287
  576917
  577735
  581503
  583542
  611356
  657398
  668766
  668970
  682329
  693948
  697079
  703945
  714868
  715810
  719111
  729717
  730595
  737338
  741556
  742706
  742927
  744570
  746070
  747269
  747384
  751761
  755426
  756152
  758629
  759582
  760697
  762169
  762203
  763798
  764919
  765278
  765573
  765726
  766357
  766867
  767181
  768462
  768852
  769742
  770849
  771289
  771834
  772410
  773771
  775415
  777381
  785369
  786051
  787343
  791405
  791460
  792551
  797389
  797440
  797843
  802369
  805524
  809604
]
15.89 ms
(6.66%)
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
  759582
  766357
  786051
  787343
  797843
  805524
  730595
  746070
  758629
  762203
  769742
  770849
  741556
  742706
  747269
  751761
  762169
  765278
  765573
  768462
  772410
  729717
  737338
  742927
  744570
  755426
  756152
  760697
  766867
  767181
  771834
  747384
  763798
  764919
  765726
  768852
  771289
  773771
  611356
  697079
  703945
  719111
  775415
  777381
  785369
  791405
  791460
  792551
  797389
  797440
  802369
  809604
  8518
  462833
  23696
  45306
  233446
  457528
  461411
  452230
  451255
  451592
  505551
  518309
  396055
  442236
  426352
  433582
  434326
  435498
  437738
  442947
  470995
  473322
  483822
  489842
  454190
  462224
  463655
  464556
  467761
  450886
  456906
  505549
  507133
  539572
  509593
  528129
  535341
  536463
  494545
  529901
  468704
  475352
  476315
  476513
  486787
  549797
  558324
  581503
  583542
  542767
  550006
  569982
  542951
  544941
  563065
  566780
  569420
  657398
  668766
  682329
  715810
  668970
  714868
  693948
  557097
  572287
  576917
  577735
]
2.55 ms
(1.07%)
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
  8518
  23696
  45306
  233446
  396055
  426352
  433582
  434326
  435498
  437738
  442236
  442947
  450886
  451255
  451592
  452230
  454190
  456906
  457528
  461411
  462224
  462833
  463655
  464556
  467761
  468704
  470995
  473322
  475352
  476315
  476513
  483822
  486787
  489842
  494545
  505549
  505551
  507133
  509593
  518309
  528129
  529901
  535341
  536463
  539572
  542767
  542951
  544941
  549797
  550006
  557097
  558324
  563065
  566780
  569420
  569982
  572287
  576917
  577735
  581503
  583542
  611356
  657398
  668766
  668970
  682329
  693948
  697079
  703945
  714868
  715810
  719111
  729717
  730595
  737338
  741556
  742706
  742927
  744570
  746070
  747269
  747384
  751761
  755426
  756152
  758629
  759582
  760697
  762169
  762203
  763798
  764919
  765278
  765573
  765726
  766357
  766867
  767181
  768462
  768852
  769742
  770849
  771289
  771834
  772410
  773771
  775415
  777381
  785369
  786051
  787343
  791405
  791460
  792551
  797389
  797440
  797843
  802369
  805524
  809604
]
2.42 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вагин red"
]
1.92 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "vagina red"
]
1.69 ms
(0.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вагин red"
]
1.63 ms
(0.68%)
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.