GET https://search.jues.net/search/embeds/8?q=redhead%20mature

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
372.09 ms
(93.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
  34394
  357513
  387026
  388087
  391108
  392104
  395842
  396707
  397861
  400818
  400998
  401005
  401749
  404600
  405252
  413126
  417174
  419145
  421817
  421824
  421826
  421834
  421840
  421847
  421899
  421936
  423934
  434044
  439704
  439802
  440687
  440826
  442218
  442238
  442307
  442773
  442783
  443105
  443171
  445873
  447475
  447961
  448827
  451850
  453387
  453701
  457281
  460651
  462268
  464256
  465985
  466941
  468437
  469736
  470647
  472159
  473148
  474092
  475801
  477881
  478801
  483450
  483732
  485386
  489847
  489971
  490384
  490513
  492321
  492449
  498362
  499025
  499778
  503169
  509637
  510783
  512067
  513133
  515499
  518325
  518581
  522657
  523441
  523762
  523773
  530790
  532813
  532903
  532918
  532943
  549737
  549739
  560899
  562001
  562423
  562977
  570841
  571501
  576702
  587167
  624195
  693308
  725575
  731751
  731756
  731769
  731796
  758438
  761414
  766911
  781654
  788209
  790611
  801450
  802986
  809932
  816865
  823769
  826783
  827059
]
16.39 ms
(4.12%)
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
  790611
  758438
  781654
  731756
  731769
  731796
  725575
  731751
  801450
  391108
  827059
  693308
  761414
  802986
  357513
  397861
  387026
  469736
  532943
  562001
  624195
  587167
  395842
  388087
  396707
  400818
  401005
  413126
  440687
  440826
  442218
  442238
  442307
  443171
  434044
  445873
  447475
  448827
  447961
  451850
  457281
  460651
  462268
  466941
  474092
  492449
  498362
  515499
  499778
  509637
  523441
  512067
  522657
  530790
  532903
  532918
  464256
  470647
  472159
  478801
  492321
  571501
  549737
  549739
  560899
  562423
  562977
  570841
  576702
  788209
  809932
  766911
  404600
  421840
  423934
  400998
  401749
  405252
  417174
  421824
  421899
  439802
  465985
  477881
  419145
  421817
  421834
  421847
  442783
  421936
  439704
  453387
  468437
  473148
  421826
  442773
  443105
  453701
  475801
  503169
  518581
  523773
  483450
  485386
  490384
  513133
  518325
  523762
  532813
  483732
  489847
  489971
  490513
  499025
  510783
  392104
  34394
  816865
  823769
  826783
]
2.85 ms
(0.71%)
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
  34394
  357513
  387026
  388087
  391108
  392104
  395842
  396707
  397861
  400818
  400998
  401005
  401749
  404600
  405252
  413126
  417174
  419145
  421817
  421824
  421826
  421834
  421840
  421847
  421899
  421936
  423934
  434044
  439704
  439802
  440687
  440826
  442218
  442238
  442307
  442773
  442783
  443105
  443171
  445873
  447475
  447961
  448827
  451850
  453387
  453701
  457281
  460651
  462268
  464256
  465985
  466941
  468437
  469736
  470647
  472159
  473148
  474092
  475801
  477881
  478801
  483450
  483732
  485386
  489847
  489971
  490384
  490513
  492321
  492449
  498362
  499025
  499778
  503169
  509637
  510783
  512067
  513133
  515499
  518325
  518581
  522657
  523441
  523762
  523773
  530790
  532813
  532903
  532918
  532943
  549737
  549739
  560899
  562001
  562423
  562977
  570841
  571501
  576702
  587167
  624195
  693308
  725575
  731751
  731756
  731769
  731796
  758438
  761414
  766911
  781654
  788209
  790611
  801450
  802986
  809932
  816865
  823769
  826783
  827059
]
2.20 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "redhead mature"
]
1.89 ms
(0.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рыжая mature"
]
1.43 ms
(0.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "рыжая mature"
]
1.39 ms
(0.35%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.