GET https://search.jues.net/search/embeds/8?q=old%20young%20webcam

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.34 ms
(87.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
  367962
  393298
  401981
  411121
  412702
  413004
  413090
  416415
  420320
  424417
  426547
  427467
  428138
  432886
  435930
  439568
  439593
  439635
  439636
  439657
  439660
  439671
  439717
  439721
  440979
  447475
  450847
  454137
  455922
  456584
  457396
  458311
  458312
  458703
  459406
  460918
  461394
  462101
  462107
  464013
  466143
  466310
  467497
  469885
  470768
  471449
  472695
  473139
  473229
  473431
  474113
  474780
  474788
  474795
  475192
  475885
  475951
  476208
  476249
  476330
  477366
  478620
  479115
  481124
  482824
  483362
  485485
  485619
  490394
  491153
  492062
  492645
  495060
  496397
  504692
  505242
  506529
  510775
  513131
  519860
  520895
  520899
  521239
  522690
  523171
  524513
  525263
  525849
  526737
  526948
  535015
  544489
  547836
  549776
  559063
  560825
  563616
  565700
  571754
  576859
  581618
  583622
  587311
  590405
  603488
  603622
  617638
  621463
  622839
  627730
  668525
  715234
  717189
  726837
  726981
  760619
  788949
  806722
  808691
  809880
]
20.43 ms
(8.49%)
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
  474780
  367962
  401981
  428138
  454137
  473229
  475885
  477366
  478620
  439717
  526737
  492645
  519860
  483362
  485619
  459406
  526948
  525263
  521239
  583622
  668525
  587311
  621463
  603622
  439657
  455922
  462101
  466310
  469885
  473139
  450847
  482824
  416415
  475951
  523171
  524513
  576859
  590405
  522690
  393298
  411121
  435930
  439636
  424417
  447475
  456584
  464013
  457396
  472695
  476330
  490394
  513131
  504692
  475192
  549776
  559063
  544489
  581618
  717189
  715234
  617638
  806722
  788949
  760619
  808691
  726837
  726981
  809880
  412702
  470768
  481124
  413004
  413090
  439593
  439635
  439721
  440979
  458311
  458312
  461394
  473431
  474795
  476208
  460918
  471449
  474113
  479115
  439568
  439660
  462107
  466143
  467497
  474788
  476249
  520895
  520899
  485485
  492062
  491153
  510775
  571754
  622839
  603488
  627730
  525849
  535015
  426547
  427467
  432886
  420320
  439671
  458703
  495060
  496397
  505242
  506529
  547836
  565700
  560825
  563616
]
2.27 ms
(0.94%)
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
  367962
  393298
  401981
  411121
  412702
  413004
  413090
  416415
  420320
  424417
  426547
  427467
  428138
  432886
  435930
  439568
  439593
  439635
  439636
  439657
  439660
  439671
  439717
  439721
  440979
  447475
  450847
  454137
  455922
  456584
  457396
  458311
  458312
  458703
  459406
  460918
  461394
  462101
  462107
  464013
  466143
  466310
  467497
  469885
  470768
  471449
  472695
  473139
  473229
  473431
  474113
  474780
  474788
  474795
  475192
  475885
  475951
  476208
  476249
  476330
  477366
  478620
  479115
  481124
  482824
  483362
  485485
  485619
  490394
  491153
  492062
  492645
  495060
  496397
  504692
  505242
  506529
  510775
  513131
  519860
  520895
  520899
  521239
  522690
  523171
  524513
  525263
  525849
  526737
  526948
  535015
  544489
  547836
  549776
  559063
  560825
  563616
  565700
  571754
  576859
  581618
  583622
  587311
  590405
  603488
  603622
  617638
  621463
  622839
  627730
  668525
  715234
  717189
  726837
  726981
  760619
  788949
  806722
  808691
  809880
]
2.10 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "old young webcam"
]
1.60 ms
(0.66%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "old young вебкамер"
]
1.35 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "old young вебкамер"
]

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.