GET https://search.jues.net/search/embeds/7?q=teen%20small%20girls

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.66 ms
(86.47%)
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
  382888
  384233
  384935
  387352
  391190
  401287
  402217
  418369
  418414
  426099
  428569
  429060
  437635
  444841
  449456
  463912
  497467
  510679
  510735
  536256
  536271
  542042
  552161
  552187
  552691
  553586
  553722
  559179
  560411
  562286
  565044
  565055
  565952
  565957
  570643
  573430
  573792
  573895
  574848
  575070
  575075
  575202
  575344
  575453
  575485
  576305
  577847
  591819
  595424
  596619
  596630
  596672
  597066
  597567
  598580
  598679
  598726
  598734
  598788
  598813
  605331
  607125
  613471
  614559
  620901
  622236
  622399
  623204
  623932
  628415
  635064
  646819
  651875
  651876
  652949
  655633
  656749
  658616
  659413
  662047
  667513
  671578
  671832
  673807
  674216
  676521
  688997
  698033
  701012
  712713
  718663
  720450
  720749
  720822
  721419
  722542
  722629
  722890
  724724
  725144
  730464
  730674
  739073
  742224
  742941
  753800
  753806
  753895
  757442
  760942
  766432
  767941
  777079
  781051
  785610
  799002
  805172
  806342
  811832
  812348
]
14.61 ms
(8.07%)
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
  463912
  497467
  536256
  574848
  671832
  688997
  712713
  721419
  598788
  598734
  777079
  739073
  767941
  701012
  449456
  510679
  384233
  646819
  655633
  401287
  429060
  552691
  573792
  575344
  552187
  559179
  651875
  652949
  658616
  720822
  573895
  575075
  595424
  805172
  811832
  724724
  812348
  730674
  622236
  806342
  781051
  510735
  671578
  698033
  620901
  444841
  552161
  667513
  676521
  674216
  613471
  598726
  623932
  730464
  387352
  575485
  575202
  575453
  560411
  565044
  565055
  576305
  659413
  562286
  570643
  607125
  591819
  742224
  391190
  622399
  597066
  418369
  656749
  766432
  722629
  662047
  753800
  760942
  542042
  382888
  596619
  598580
  598679
  605331
  785610
  757442
  718663
  799002
  418414
  577847
  628415
  598813
  384935
  426099
  614559
  596672
  536271
  722890
  651876
  720749
  565957
  597567
  725144
  742941
  753806
  753895
  635064
  402217
  565952
  596630
  623204
  428569
  437635
  553586
  573430
  553722
  575070
  673807
  720450
  722542
]
3.99 ms
(2.20%)
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
  382888
  384233
  384935
  387352
  391190
  401287
  402217
  418369
  418414
  426099
  428569
  429060
  437635
  444841
  449456
  463912
  497467
  510679
  510735
  536256
  536271
  542042
  552161
  552187
  552691
  553586
  553722
  559179
  560411
  562286
  565044
  565055
  565952
  565957
  570643
  573430
  573792
  573895
  574848
  575070
  575075
  575202
  575344
  575453
  575485
  576305
  577847
  591819
  595424
  596619
  596630
  596672
  597066
  597567
  598580
  598679
  598726
  598734
  598788
  598813
  605331
  607125
  613471
  614559
  620901
  622236
  622399
  623204
  623932
  628415
  635064
  646819
  651875
  651876
  652949
  655633
  656749
  658616
  659413
  662047
  667513
  671578
  671832
  673807
  674216
  676521
  688997
  698033
  701012
  712713
  718663
  720450
  720749
  720822
  721419
  722542
  722629
  722890
  724724
  725144
  730464
  730674
  739073
  742224
  742941
  753800
  753806
  753895
  757442
  760942
  766432
  767941
  777079
  781051
  785610
  799002
  805172
  806342
  811832
  812348
]
1.74 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen small girls"
]
1.54 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(0.77%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen маленькая девушк"
]
1.23 ms
(0.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen маленькая девушк"
]

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.