GET https://search.jues.net/search/embeds/5?q=babe%20ass

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.50 ms
(86.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
  13803
  35405
  92019
  101932
  212132
  212914
  213429
  222292
  313222
  383328
  387874
  389793
  396783
  397658
  408620
  409008
  424975
  426897
  427062
  444914
  445036
  454701
  463398
  491681
  510739
  514976
  525305
  528094
  528155
  530666
  530794
  533227
  537678
  538630
  539189
  543063
  546825
  551694
  556940
  558203
  559882
  568090
  569220
  572739
  584047
  585107
  589958
  598324
  600307
  605312
  610923
  615048
  622947
  641418
  644462
  647745
  651873
  652992
  653649
  655699
  656081
  657025
  658400
  659151
  659757
  659795
  661005
  661055
  667906
  670404
  671421
  673027
  682611
  692156
  692756
  704874
  710828
  711600
  714531
  716771
  719090
  720463
  740637
  750187
  755287
  764242
  766266
  766793
  767187
  774936
  775209
  776774
  778730
  778824
  779376
  784659
  785755
  787557
  792458
  795211
  800863
  806167
  807381
  808085
  808862
  810221
  811689
  814955
  815807
  815814
  816517
  816606
  817065
  817300
  820933
  821661
  822032
  822162
  823400
  826230
]
14.24 ms
(7.85%)
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
  774936
  776774
  778824
  785755
  787557
  808862
  212132
  313222
  213429
  445036
  13803
  212914
  35405
  585107
  537678
  525305
  514976
  556940
  661005
  652992
  622947
  766266
  610923
  800863
  427062
  543063
  551694
  658400
  659757
  704874
  655699
  656081
  659795
  659151
  671421
  598324
  792458
  807381
  778730
  766793
  755287
  719090
  389793
  408620
  651873
  661055
  641418
  409008
  424975
  528094
  653649
  673027
  600307
  605312
  811689
  810221
  764242
  740637
  615048
  714531
  716771
  779376
  784659
  806167
  383328
  387874
  397658
  426897
  454701
  538630
  710828
  711600
  589958
  795211
  808085
  750187
  767187
  644462
  775209
  92019
  444914
  101932
  222292
  396783
  815807
  815814
  821661
  822032
  816606
  826230
  816517
  817300
  820933
  814955
  817065
  822162
  823400
  463398
  491681
  530666
  533227
  539189
  510739
  528155
  530794
  546825
  558203
  584047
  559882
  569220
  572739
  568090
  667906
  670404
  682611
  692156
  692756
  720463
  657025
  647745
]
2.43 ms
(1.34%)
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
  13803
  35405
  92019
  101932
  212132
  212914
  213429
  222292
  313222
  383328
  387874
  389793
  396783
  397658
  408620
  409008
  424975
  426897
  427062
  444914
  445036
  454701
  463398
  491681
  510739
  514976
  525305
  528094
  528155
  530666
  530794
  533227
  537678
  538630
  539189
  543063
  546825
  551694
  556940
  558203
  559882
  568090
  569220
  572739
  584047
  585107
  589958
  598324
  600307
  605312
  610923
  615048
  622947
  641418
  644462
  647745
  651873
  652992
  653649
  655699
  656081
  657025
  658400
  659151
  659757
  659795
  661005
  661055
  667906
  670404
  671421
  673027
  682611
  692156
  692756
  704874
  710828
  711600
  714531
  716771
  719090
  720463
  740637
  750187
  755287
  764242
  766266
  766793
  767187
  774936
  775209
  776774
  778730
  778824
  779376
  784659
  785755
  787557
  792458
  795211
  800863
  806167
  807381
  808085
  808862
  810221
  811689
  814955
  815807
  815814
  816517
  816606
  817065
  817300
  820933
  821661
  822032
  822162
  823400
  826230
]
2.18 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "babe ass"
]
1.88 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "babe жоп"
]
1.78 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "babe жоп"
]

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.