GET https://search.jues.net/search/embeds/10?q=busty%20girls

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.21 ms
(84.76%)
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
  23135
  113755
  382181
  383652
  385009
  385172
  389019
  402351
  403384
  408741
  413163
  414256
  417641
  423673
  425607
  426486
  445010
  447504
  456817
  463341
  464522
  476439
  477222
  486947
  522182
  523434
  529353
  535317
  536514
  540176
  550013
  550585
  557966
  558058
  565205
  565621
  566668
  568124
  568776
  572018
  576323
  578478
  579785
  587163
  591049
  593481
  593553
  594110
  594204
  594226
  604104
  604106
  604804
  604806
  606400
  614542
  618916
  622680
  624078
  630254
  635977
  640528
  641408
  646030
  648222
  651216
  661964
  662499
  664260
  668523
  671392
  671560
  673122
  678615
  678787
  685840
  702549
  710903
  716140
  716241
  717921
  718190
  720045
  721394
  734837
  738062
  738286
  744204
  744380
  752913
  756697
  757226
  760042
  760134
  762338
  769904
  775116
  775669
  776786
  776790
  776840
  777648
  778595
  780963
  781884
  784210
  796245
  803826
  804751
  806144
  807333
  808490
  810572
  810818
  812742
  813807
  819649
  820340
  823306
  824769
]
13.30 ms
(8.59%)
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
  721394
  718190
  614542
  804751
  752913
  423673
  445010
  447504
  486947
  385172
  389019
  413163
  408741
  426486
  813807
  819649
  823306
  820340
  535317
  557966
  550585
  565205
  566668
  578478
  579785
  550013
  568776
  662499
  664260
  671392
  673122
  646030
  648222
  651216
  702549
  716140
  717921
  604806
  624078
  587163
  591049
  622680
  641408
  593481
  594204
  640528
  776840
  778595
  807333
  808490
  810818
  775116
  744204
  760134
  781884
  796245
  803826
  744380
  738286
  756697
  757226
  769904
  760042
  762338
  604104
  716241
  776786
  403384
  402351
  456817
  476439
  529353
  568124
  414256
  385009
  464522
  618916
  810572
  382181
  425607
  824769
  477222
  536514
  522182
  540176
  558058
  565621
  671560
  678615
  685840
  661964
  720045
  668523
  678787
  572018
  576323
  593553
  635977
  594226
  604106
  604804
  606400
  630254
  594110
  776790
  780963
  784210
  806144
  777648
  812742
  734837
  738062
  710903
  775669
  463341
  417641
  23135
  523434
  383652
  113755
]
3.02 ms
(1.95%)
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
  23135
  113755
  382181
  383652
  385009
  385172
  389019
  402351
  403384
  408741
  413163
  414256
  417641
  423673
  425607
  426486
  445010
  447504
  456817
  463341
  464522
  476439
  477222
  486947
  522182
  523434
  529353
  535317
  536514
  540176
  550013
  550585
  557966
  558058
  565205
  565621
  566668
  568124
  568776
  572018
  576323
  578478
  579785
  587163
  591049
  593481
  593553
  594110
  594204
  594226
  604104
  604106
  604804
  604806
  606400
  614542
  618916
  622680
  624078
  630254
  635977
  640528
  641408
  646030
  648222
  651216
  661964
  662499
  664260
  668523
  671392
  671560
  673122
  678615
  678787
  685840
  702549
  710903
  716140
  716241
  717921
  718190
  720045
  721394
  734837
  738062
  738286
  744204
  744380
  752913
  756697
  757226
  760042
  760134
  762338
  769904
  775116
  775669
  776786
  776790
  776840
  777648
  778595
  780963
  781884
  784210
  796245
  803826
  804751
  806144
  807333
  808490
  810572
  810818
  812742
  813807
  819649
  820340
  823306
  824769
]
2.08 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "busty girls"
]
1.82 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "busty девушк"
]
1.59 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "busty девушк"
]

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.