GET https://search.jues.net/search/embeds/5?q=step%20fuck

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.80 ms
(35.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
  394251
  394258
  396280
  398268
  399433
  399439
  399456
  399511
  399516
  399518
  400156
  401378
  402079
  402599
  409100
  422352
  433681
  435647
  438005
  440292
  440864
  441692
  442418
  442862
  443183
  445502
  448166
  453260
  455652
  457113
  459947
  463703
  464144
  465507
  484764
  486946
  489960
  492614
  493844
  496292
  514813
  519828
  523475
  526812
  528833
  532614
  534722
  535915
  544103
  546979
  556398
  558876
  561281
  561597
  561810
  563183
  569394
  571129
  574990
  578569
  579209
  579227
  582197
  584666
  588378
  593598
  594108
  598178
  599710
  601325
  607698
  608415
  615712
  619955
  622321
  623754
  623790
  623818
  625254
  630910
  645255
  659389
  662140
  685023
  685068
  701527
  702312
  710588
  713552
  714062
  714097
  714626
  716324
  718049
  725788
  738013
  742839
  753722
  756973
  757501
  758174
  761986
  777732
  785945
  788821
  789693
  790030
  790534
  793042
  793500
  795234
  796206
  798171
  805069
  805284
  810760
  813035
  818080
  820337
]
207.25 ms
(34.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "step fuck"
]
156.04 ms
(26.20%)
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
  394251
  394258
  396280
  398268
  399433
  399439
  399456
  399511
  399516
  399518
  400156
  401378
  402079
  402599
  409100
  422352
  433681
  435647
  438005
  440292
  440864
  441692
  442418
  442862
  443183
  445502
  448166
  453260
  455652
  457113
  459947
  463703
  464144
  465507
  484764
  486946
  489960
  492614
  493844
  496292
  514813
  519828
  523475
  526812
  528833
  532614
  534722
  535915
  544103
  546979
  556398
  558876
  561281
  561597
  561810
  563183
  569394
  571129
  574990
  578569
  579209
  579227
  582197
  584666
  588378
  593598
  594108
  598178
  599710
  601325
  607698
  608415
  615712
  619955
  622321
  623754
  623790
  623818
  625254
  630910
  645255
  659389
  662140
  685023
  685068
  701527
  702312
  710588
  713552
  714062
  714097
  714626
  716324
  718049
  725788
  738013
  742839
  753722
  756973
  757501
  758174
  761986
  777732
  785945
  788821
  789693
  790030
  790534
  793042
  793500
  795234
  796206
  798171
  805069
  805284
  810760
  813035
  818080
  820337
]
14.88 ms
(2.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
  394258
  399439
  761986
  396280
  623818
  402079
  401378
  443183
  445502
  465507
  662140
  574990
  785945
  440864
  489960
  526812
  582197
  685068
  579227
  625254
  793500
  795234
  716324
  790534
  399518
  399456
  453260
  532614
  569394
  710588
  685023
  563183
  622321
  623790
  619955
  796206
  725788
  798171
  399433
  455652
  402599
  440292
  519828
  659389
  714097
  702312
  594108
  593598
  756973
  435647
  535915
  441692
  442418
  457113
  544103
  558876
  579209
  561597
  713552
  599710
  623754
  607698
  805284
  615712
  714626
  718049
  492614
  496292
  394251
  433681
  818080
  463703
  528833
  534722
  523475
  484764
  578569
  561810
  584666
  561281
  714062
  645255
  701527
  571129
  598178
  601325
  608415
  588378
  779905
  789693
  813035
  742839
  758174
  753722
  738013
  793042
  442862
  438005
  486946
  493844
  448166
  757501
  790030
  398268
  556398
  777732
  805069
  810760
  409100
  399511
  399516
  820337
  788821
  630910
  400156
  422352
  459947
  464144
  514813
  546979
]
1.69 ms
(0.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "step секс"
]
1.56 ms
(0.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "step секс"
]

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.