GET https://search.jues.net/search/embeds/5?q=sex%20cute

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.15 ms
(84.53%)
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
  21109
  78412
  80203
  233934
  382130
  383763
  385260
  385357
  391543
  398384
  410299
  426670
  427755
  459665
  460939
  472755
  472865
  492310
  518772
  527610
  529498
  540213
  542183
  552437
  557584
  565003
  575549
  585913
  586452
  593281
  595540
  595598
  607802
  607903
  612807
  617183
  619448
  635153
  639915
  642093
  644014
  650118
  652522
  656028
  657931
  659623
  663390
  665754
  665906
  669858
  671531
  673125
  673776
  675396
  683774
  683797
  683877
  687971
  698809
  709802
  719813
  723819
  725282
  728217
  731881
  736139
  736342
  736889
  739411
  740366
  740763
  742160
  742504
  743232
  745361
  746075
  746803
  752513
  753525
  753853
  756070
  756144
  757423
  763276
  763748
  766055
  766472
  766758
  767177
  767306
  772076
  772416
  773126
  777132
  779233
  780043
  781407
  782109
  783579
  789901
  790053
  790134
  792384
  796982
  800534
  802752
  803640
  806644
  807275
  808082
  809810
  812178
  815131
  817022
  817819
  819372
  819607
  820086
  823528
]
13.99 ms
(8.50%)
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
  639915
  812178
  756070
  766758
  772416
  782109
  790134
  808082
  742504
  773126
  772076
  779233
  781407
  459665
  426670
  383763
  382130
  410299
  817819
  820086
  823528
  472755
  527610
  492310
  542183
  575549
  552437
  673125
  675396
  683774
  669858
  683797
  607903
  644014
  619448
  595540
  607802
  792384
  806644
  785992
  796982
  800534
  739411
  745361
  802752
  803640
  731881
  736889
  756144
  740366
  746803
  767306
  753525
  763276
  763748
  766055
  698809
  809810
  78412
  21109
  780043
  789901
  656028
  790053
  767177
  385260
  460939
  719813
  659623
  777132
  783579
  723819
  725282
  766472
  753853
  736139
  752513
  742160
  757423
  398384
  233934
  819607
  472865
  540213
  652522
  657931
  665906
  671531
  687971
  709802
  557584
  585913
  617183
  642093
  807275
  736342
  740763
  728217
  746075
  743232
  612807
  80203
  385357
  391543
  427755
  817022
  819372
  815131
  529498
  518772
  565003
  650118
  665754
  673776
  663390
  683877
  595598
  593281
  635153
  586452
]
3.27 ms
(1.99%)
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
  21109
  78412
  80203
  233934
  382130
  383763
  385260
  385357
  391543
  398384
  410299
  426670
  427755
  459665
  460939
  472755
  472865
  492310
  518772
  527610
  529498
  540213
  542183
  552437
  557584
  565003
  575549
  585913
  586452
  593281
  595540
  595598
  607802
  607903
  612807
  617183
  619448
  635153
  639915
  642093
  644014
  650118
  652522
  656028
  657931
  659623
  663390
  665754
  665906
  669858
  671531
  673125
  673776
  675396
  683774
  683797
  683877
  687971
  698809
  709802
  719813
  723819
  725282
  728217
  731881
  736139
  736342
  736889
  739411
  740366
  740763
  742160
  742504
  743232
  745361
  746075
  746803
  752513
  753525
  753853
  756070
  756144
  757423
  763276
  763748
  766055
  766472
  766758
  767177
  767306
  772076
  772416
  773126
  777132
  779233
  780043
  781407
  782109
  783579
  789901
  790053
  790134
  792384
  796982
  800534
  802752
  803640
  806644
  807275
  808082
  809810
  812178
  815131
  817022
  817819
  819372
  819607
  820086
  823528
]
2.54 ms
(1.54%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.11 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex cute"
]
1.81 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс cute"
]
1.74 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс cute"
]

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.