GET https://search.jues.net/search/embeds/10?q=creampie%20girl

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.61 ms
(85.54%)
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
  76150
  185428
  249773
  330564
  338411
  350287
  386212
  390990
  398355
  398399
  398907
  403782
  415092
  423436
  432804
  447733
  449108
  450190
  452275
  496247
  505947
  522055
  531340
  533383
  534615
  535993
  539241
  539283
  541283
  542106
  546292
  546434
  546493
  550345
  550973
  551588
  552621
  552730
  559423
  565215
  574157
  574211
  604552
  625757
  625799
  634540
  653124
  654337
  654353
  654398
  656494
  656619
  659212
  662146
  664224
  664968
  676308
  677191
  680342
  682918
  691197
  693425
  695123
  695915
  705225
  714392
  717128
  720579
  720737
  723637
  740743
  742144
  743039
  750129
  750769
  755576
  756972
  766883
  769036
  770506
  770835
  773640
  776363
  777109
  777143
  777754
  778641
  779195
  779681
  781077
  781091
  781154
  783000
  783673
  787282
  787433
  789757
  791770
  794511
  796073
  797918
  802043
  803548
  803748
  804020
  807472
  807521
  810338
  811046
  812149
  814732
  816613
  817734
  818085
  819737
  823490
  825537
  825557
  826162
  827984
]
13.54 ms
(8.30%)
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
  770506
  773640
  714392
  717128
  776363
  778641
  779195
  781077
  781091
  781154
  783673
  787433
  803548
  803748
  804020
  810338
  811046
  403782
  423436
  76150
  185428
  249773
  823490
  825537
  816613
  817734
  826162
  827984
  447733
  539241
  496247
  522055
  539283
  552730
  565215
  541283
  552621
  691197
  693425
  676308
  654337
  654398
  664968
  695915
  720579
  604552
  625799
  777109
  783000
  794511
  777754
  740743
  789757
  791770
  797918
  756972
  769036
  750129
  770835
  750769
  625757
  634540
  777143
  779681
  812149
  350287
  695123
  398907
  574211
  546493
  659212
  682918
  546292
  802043
  807472
  807521
  787282
  796073
  742144
  766883
  743039
  755576
  390990
  386212
  338411
  330564
  398399
  398355
  432804
  415092
  818085
  723637
  819737
  814732
  825557
  449108
  450190
  452275
  533383
  534615
  535993
  505947
  531340
  542106
  546434
  550973
  551588
  574157
  550345
  559423
  656619
  664224
  677191
  680342
  705225
  720737
  653124
  654353
  656494
  662146
]
2.82 ms
(1.73%)
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
  76150
  185428
  249773
  330564
  338411
  350287
  386212
  390990
  398355
  398399
  398907
  403782
  415092
  423436
  432804
  447733
  449108
  450190
  452275
  496247
  505947
  522055
  531340
  533383
  534615
  535993
  539241
  539283
  541283
  542106
  546292
  546434
  546493
  550345
  550973
  551588
  552621
  552730
  559423
  565215
  574157
  574211
  604552
  625757
  625799
  634540
  653124
  654337
  654353
  654398
  656494
  656619
  659212
  662146
  664224
  664968
  676308
  677191
  680342
  682918
  691197
  693425
  695123
  695915
  705225
  714392
  717128
  720579
  720737
  723637
  740743
  742144
  743039
  750129
  750769
  755576
  756972
  766883
  769036
  770506
  770835
  773640
  776363
  777109
  777143
  777754
  778641
  779195
  779681
  781077
  781091
  781154
  783000
  783673
  787282
  787433
  789757
  791770
  794511
  796073
  797918
  802043
  803548
  803748
  804020
  807472
  807521
  810338
  811046
  812149
  814732
  816613
  817734
  818085
  819737
  823490
  825537
  825557
  826162
  827984
]
2.26 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "creampie girl"
]
1.93 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "creampie девушк"
]
1.45 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "creampie девушк"
]

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.