GET https://search.jues.net/search/embeds/7?q=hairy%20natural

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
220.14 ms
(89.74%)
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
  382502
  390402
  401971
  404695
  404800
  405360
  406062
  406179
  406377
  408292
  411393
  413861
  419554
  419947
  420444
  424425
  426478
  426480
  428653
  429267
  442353
  446550
  447356
  447825
  447839
  452444
  453135
  453438
  453681
  454159
  455807
  455890
  456496
  458421
  459263
  460741
  462008
  464388
  466171
  466966
  467547
  470280
  470926
  471771
  474859
  476228
  477581
  480941
  484551
  484591
  484683
  486285
  489078
  492112
  493098
  494346
  502729
  502910
  503989
  505930
  506156
  509485
  509846
  511030
  512213
  512221
  512806
  516221
  516663
  518997
  522734
  523164
  525250
  526737
  543708
  547390
  547737
  552009
  558196
  558289
  563001
  565929
  566262
  568738
  572543
  574467
  577661
  585159
  585300
  592672
  593080
  597646
  599221
  603327
  610047
  615721
  617814
  619450
  622645
  623564
  630204
  630227
  645010
  647678
  655587
  663451
  664818
  667895
  672769
  684200
  687917
  687995
  688104
  691201
  703192
  717516
  722478
  766709
  804677
  814376
]
16.12 ms
(6.57%)
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
  574467
  577661
  664818
  687917
  703192
  647678
  684200
  688104
  691201
  655587
  663451
  667895
  687995
  722478
  547390
  572543
  585300
  610047
  619450
  585159
  592672
  597646
  599221
  603327
  622645
  593080
  623564
  804677
  766709
  617814
  630204
  630227
  390402
  429267
  459263
  382502
  401971
  405360
  408292
  419554
  460741
  424425
  426478
  456496
  467547
  404695
  411393
  458421
  471771
  454159
  455807
  476228
  509485
  526737
  484591
  505930
  518997
  525250
  484683
  492112
  494346
  506156
  502729
  568738
  428653
  484551
  455890
  406377
  426480
  453135
  453438
  464388
  516663
  563001
  547737
  470926
  466966
  419947
  470280
  509846
  717516
  814376
  420444
  565929
  566262
  406179
  406062
  442353
  447356
  543708
  615721
  462008
  466171
  413861
  672769
  558196
  404800
  645010
  447825
  452444
  453681
  489078
  493098
  446550
  447839
  474859
  480941
  502910
  503989
  511030
  512221
  516221
  523164
  512213
  512806
  522734
  477581
  486285
  552009
  558289
]
2.62 ms
(1.07%)
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
  382502
  390402
  401971
  404695
  404800
  405360
  406062
  406179
  406377
  408292
  411393
  413861
  419554
  419947
  420444
  424425
  426478
  426480
  428653
  429267
  442353
  446550
  447356
  447825
  447839
  452444
  453135
  453438
  453681
  454159
  455807
  455890
  456496
  458421
  459263
  460741
  462008
  464388
  466171
  466966
  467547
  470280
  470926
  471771
  474859
  476228
  477581
  480941
  484551
  484591
  484683
  486285
  489078
  492112
  493098
  494346
  502729
  502910
  503989
  505930
  506156
  509485
  509846
  511030
  512213
  512221
  512806
  516221
  516663
  518997
  522734
  523164
  525250
  526737
  543708
  547390
  547737
  552009
  558196
  558289
  563001
  565929
  566262
  568738
  572543
  574467
  577661
  585159
  585300
  592672
  593080
  597646
  599221
  603327
  610047
  615721
  617814
  619450
  622645
  623564
  630204
  630227
  645010
  647678
  655587
  663451
  664818
  667895
  672769
  684200
  687917
  687995
  688104
  691201
  703192
  717516
  722478
  766709
  804677
  814376
]
1.85 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy natural"
]
1.83 ms
(0.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая натуральная натуральные"
]
1.40 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "волосатая натуральная натуральные"
]
1.35 ms
(0.55%)
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.