GET https://search.jues.net/search/embeds/3?q=vagina%20dildo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.35 ms
(81.32%)
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
  396339
  399163
  418117
  419167
  429860
  430549
  432824
  432944
  439362
  441069
  442430
  448008
  450076
  452824
  454007
  456868
  460038
  465691
  466360
  467616
  469086
  473535
  475422
  475426
  476666
  476825
  478519
  483946
  485471
  493443
  509329
  509593
  511277
  513223
  513986
  514868
  515419
  515442
  516676
  517349
  520152
  522169
  522231
  526179
  529053
  533397
  536914
  538484
  538759
  542097
  544110
  549645
  550021
  550845
  551598
  554371
  556514
  560252
  560918
  561952
  564040
  565642
  566083
  569765
  571765
  577192
  577479
  577706
  580055
  580103
  580194
  580848
  581407
  584046
  584119
  584590
  584999
  588811
  589150
  589836
  592632
  592650
  593053
  595612
  595646
  595894
  596402
  596440
  596963
  597691
  598956
  599180
  600125
  601774
  602166
  602416
  604870
  609574
  614350
  618507
  623300
  632123
  638671
  639102
  651700
  652513
  663749
  664987
  666160
  668151
  669271
  669854
  670970
  675402
  678974
  686331
  690609
  765721
  785880
  814386
]
15.43 ms
(10.43%)
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
  476825
  513986
  678974
  601774
  456868
  516676
  432824
  666160
  396339
  439362
  509329
  520152
  515442
  577706
  596440
  639102
  485471
  465691
  452824
  566083
  686331
  592632
  526179
  544110
  565642
  664987
  675402
  580055
  589150
  598956
  418117
  419167
  467616
  475422
  473535
  529053
  571765
  549645
  550845
  609574
  478519
  511277
  399163
  536914
  584046
  663749
  556514
  592650
  441069
  669854
  509593
  569765
  670970
  668151
  690609
  550021
  460038
  476666
  517349
  475426
  596963
  604870
  595894
  450076
  483946
  469086
  651700
  593053
  602166
  596402
  430549
  448008
  493443
  522231
  522169
  560252
  554371
  580848
  599180
  785880
  765721
  602416
  551598
  597691
  442430
  466360
  538759
  564040
  560918
  561952
  581407
  669271
  600125
  632123
  618507
  454007
  584999
  513223
  514868
  577479
  595646
  638671
  623300
  429860
  588811
  814386
  515419
  580103
  595612
  584119
  533397
  580194
  432944
  589836
  577192
  538484
  542097
  584590
  652513
  614350
]
4.10 ms
(2.77%)
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
  396339
  399163
  418117
  419167
  429860
  430549
  432824
  432944
  439362
  441069
  442430
  448008
  450076
  452824
  454007
  456868
  460038
  465691
  466360
  467616
  469086
  473535
  475422
  475426
  476666
  476825
  478519
  483946
  485471
  493443
  509329
  509593
  511277
  513223
  513986
  514868
  515419
  515442
  516676
  517349
  520152
  522169
  522231
  526179
  529053
  533397
  536914
  538484
  538759
  542097
  544110
  549645
  550021
  550845
  551598
  554371
  556514
  560252
  560918
  561952
  564040
  565642
  566083
  569765
  571765
  577192
  577479
  577706
  580055
  580103
  580194
  580848
  581407
  584046
  584119
  584590
  584999
  588811
  589150
  589836
  592632
  592650
  593053
  595612
  595646
  595894
  596402
  596440
  596963
  597691
  598956
  599180
  600125
  601774
  602166
  602416
  604870
  609574
  614350
  618507
  623300
  632123
  638671
  639102
  651700
  652513
  663749
  664987
  666160
  668151
  669271
  669854
  670970
  675402
  678974
  686331
  690609
  765721
  785880
  814386
]
2.44 ms
(1.65%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.28 ms
(1.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "vagina dildo"
]
1.86 ms
(1.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вагин дилд"
]
1.53 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.