GET https://search.jues.net/search/embeds/4?q=fucking%20blonde

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.86 ms
(83.78%)
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
  16946
  28386
  35067
  66716
  82710
  97107
  131726
  194687
  268637
  385788
  385946
  391760
  392068
  392880
  393456
  395101
  395755
  398124
  398492
  398882
  400042
  400587
  401766
  404078
  404731
  407293
  407562
  409168
  411977
  412091
  412227
  415508
  417419
  419861
  423625
  425835
  426031
  434080
  436462
  443028
  444698
  444735
  448592
  455822
  457016
  457508
  457855
  458359
  458591
  459096
  459505
  465228
  470046
  472150
  473228
  475819
  477316
  482610
  483147
  486011
  486894
  490164
  504162
  513036
  516100
  519161
  519260
  520892
  520938
  521401
  522600
  524282
  526056
  527917
  531120
  551242
  556655
  566833
  569861
  572095
  577087
  589573
  591788
  592227
  592735
  598216
  598349
  603482
  606611
  611020
  615023
  622967
  630267
  637520
  646000
  653876
  665622
  673141
  681646
  692077
  702224
  712879
  713364
  731623
  737533
  739820
  741710
  743208
  758789
  785026
  785967
  801282
  808064
  811493
  814429
  817785
  821478
  821496
  824921
  827009
]
16.52 ms
(9.42%)
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
  577087
  569861
  637520
  603482
  785026
  459096
  412227
  591788
  395101
  268637
  35067
  398124
  404078
  817785
  824921
  821478
  821496
  827009
  448592
  524282
  673141
  681646
  622967
  611020
  811493
  801282
  737533
  743208
  731623
  385788
  423625
  457016
  458591
  477316
  28386
  425835
  455822
  472150
  482610
  519161
  522600
  566833
  653876
  606611
  444698
  486011
  131726
  444735
  457508
  519260
  615023
  592227
  702224
  391760
  392880
  521401
  419861
  814429
  526056
  556655
  712879
  589573
  82710
  486894
  393456
  392068
  400587
  409168
  415508
  551242
  665622
  713364
  785967
  741710
  739820
  630267
  808064
  417419
  412091
  457855
  459505
  520938
  97107
  400042
  407562
  465228
  490164
  520892
  527917
  572095
  646000
  692077
  598216
  592735
  598349
  758789
  66716
  194687
  395755
  16946
  411977
  426031
  443028
  473228
  475819
  470046
  516100
  513036
  458359
  483147
  504162
  531120
  385946
  398492
  398882
  401766
  404731
  434080
  436462
  407293
]
4.10 ms
(2.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
  16946
  28386
  35067
  66716
  82710
  97107
  131726
  194687
  268637
  385788
  385946
  391760
  392068
  392880
  393456
  395101
  395755
  398124
  398492
  398882
  400042
  400587
  401766
  404078
  404731
  407293
  407562
  409168
  411977
  412091
  412227
  415508
  417419
  419861
  423625
  425835
  426031
  434080
  436462
  443028
  444698
  444735
  448592
  455822
  457016
  457508
  457855
  458359
  458591
  459096
  459505
  465228
  470046
  472150
  473228
  475819
  477316
  482610
  483147
  486011
  486894
  490164
  504162
  513036
  516100
  519161
  519260
  520892
  520938
  521401
  522600
  524282
  526056
  527917
  531120
  551242
  556655
  566833
  569861
  572095
  577087
  589573
  591788
  592227
  592735
  598216
  598349
  603482
  606611
  611020
  615023
  622967
  630267
  637520
  646000
  653876
  665622
  673141
  681646
  692077
  702224
  712879
  713364
  731623
  737533
  739820
  741710
  743208
  758789
  785026
  785967
  801282
  808064
  811493
  814429
  817785
  821478
  821496
  824921
  827009
]
2.25 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fucking blonde"
]
1.91 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "fucking беловолосая"
]
1.85 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "fucking беловолосая"
]

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.