GET https://search.jues.net/search/embeds/9?q=bitch%20teens

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
233.72 ms
(85.44%)
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
  214663
  222010
  233386
  373416
  384933
  384972
  389091
  391674
  395428
  404766
  405272
  420636
  425775
  427218
  433373
  463002
  463606
  472272
  487973
  488473
  490853
  491090
  494980
  495218
  502854
  503292
  504903
  506612
  508424
  508437
  508990
  509464
  512885
  514785
  515119
  516943
  520330
  521576
  521624
  521989
  524013
  525272
  525306
  526343
  529266
  530291
  538208
  546861
  554778
  556327
  558134
  561699
  561704
  563887
  564705
  565156
  565653
  566272
  566538
  566960
  567416
  568676
  569065
  571653
  572771
  572885
  575144
  576095
  577362
  581485
  581797
  584419
  584702
  586406
  589127
  590596
  594231
  596627
  597208
  597572
  597975
  598702
  598785
  599290
  599317
  599552
  600531
  601430
  601454
  601677
  602446
  603047
  605913
  608407
  608416
  608560
  608737
  609259
  609892
  610869
  611251
  615590
  615623
  615703
  616089
  617056
  617597
  620086
  620546
  621091
  621804
  622932
  625001
  632304
  636154
  636231
  651929
  652931
  653325
  661528
]
29.81 ms
(10.90%)
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
  420636
  433373
  472272
  503292
  502854
  504903
  538208
  487973
  490853
  491090
  508990
  514785
  427218
  516943
  515119
  584702
  567416
  625001
  589127
  594231
  566272
  572771
  572885
  577362
  581485
  556327
  558134
  561699
  563887
  564705
  565156
  565653
  568676
  575144
  576095
  584419
  554778
  561704
  651929
  652931
  653325
  661528
  546861
  566538
  566960
  569065
  571653
  581797
  600531
  601454
  601677
  605913
  608737
  590596
  598702
  601430
  603047
  609892
  611251
  615590
  616089
  620086
  622932
  636154
  586406
  597572
  597975
  598785
  599290
  599317
  599552
  608560
  610869
  615623
  617056
  620546
  632304
  596627
  597208
  602446
  608407
  608416
  609259
  615703
  617597
  621091
  621804
  636231
  404766
  425775
  405272
  463002
  463606
  521576
  495218
  512885
  521989
  524013
  525272
  488473
  530291
  494980
  506612
  508424
  508437
  509464
  520330
  521624
  525306
  526343
  529266
  384972
  384933
  214663
  222010
  233386
  391674
  395428
  373416
  389091
]
2.78 ms
(1.02%)
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
  214663
  222010
  233386
  373416
  384933
  384972
  389091
  391674
  395428
  404766
  405272
  420636
  425775
  427218
  433373
  463002
  463606
  472272
  487973
  488473
  490853
  491090
  494980
  495218
  502854
  503292
  504903
  506612
  508424
  508437
  508990
  509464
  512885
  514785
  515119
  516943
  520330
  521576
  521624
  521989
  524013
  525272
  525306
  526343
  529266
  530291
  538208
  546861
  554778
  556327
  558134
  561699
  561704
  563887
  564705
  565156
  565653
  566272
  566538
  566960
  567416
  568676
  569065
  571653
  572771
  572885
  575144
  576095
  577362
  581485
  581797
  584419
  584702
  586406
  589127
  590596
  594231
  596627
  597208
  597572
  597975
  598702
  598785
  599290
  599317
  599552
  600531
  601430
  601454
  601677
  602446
  603047
  605913
  608407
  608416
  608560
  608737
  609259
  609892
  610869
  611251
  615590
  615623
  615703
  616089
  617056
  617597
  620086
  620546
  621091
  621804
  622932
  625001
  632304
  636154
  636231
  651929
  652931
  653325
  661528
]
2.16 ms
(0.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.89 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bitch teens"
]
1.61 ms
(0.59%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "женскийрод teens"
]
1.57 ms
(0.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "женскийрод teens"
]

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.