GET https://search.jues.net/search/embeds/9?q=russian%20girlfriend

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
190.51 ms
(87.06%)
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
  390938
  415793
  423361
  423982
  425725
  426084
  426238
  428047
  433410
  434359
  436681
  442387
  442435
  447173
  448260
  448876
  450990
  451156
  453686
  456075
  456373
  456648
  456688
  457617
  457841
  460334
  462011
  467532
  467888
  468097
  470443
  472300
  472350
  473258
  473259
  473690
  474611
  475207
  478361
  479592
  482120
  483035
  484123
  484139
  486958
  487195
  487313
  488157
  488259
  488829
  491040
  491920
  492921
  493452
  495584
  496042
  496429
  497300
  498364
  501935
  505071
  507846
  508245
  509036
  509641
  509672
  511076
  511250
  512345
  512540
  512738
  515757
  516534
  517832
  519610
  521474
  521647
  521905
  522308
  522488
  523055
  523276
  524045
  524624
  527831
  533138
  540977
  547549
  547617
  549134
  551612
  552585
  552663
  557569
  560832
  565426
  565838
  569097
  572913
  574721
  579194
  584669
  586595
  586838
  590601
  592263
  617660
  620626
  624933
  625547
  639208
  653233
  653467
  656477
  657667
  722846
  763437
  779012
  801292
  807506
]
17.68 ms
(8.08%)
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
  547617
  551612
  552663
  565426
  574721
  586838
  592263
  620626
  624933
  590601
  617660
  801292
  763437
  639208
  722846
  779012
  807506
  423361
  447173
  456648
  415793
  425725
  442435
  456075
  467532
  390938
  456373
  460334
  473690
  433410
  436681
  451156
  470443
  472300
  473258
  475207
  479592
  462011
  468097
  472350
  473259
  512738
  519610
  533138
  484123
  486958
  488157
  491040
  493452
  496429
  498364
  501935
  505071
  509641
  515757
  521474
  522308
  522488
  523276
  524624
  483035
  496042
  516534
  521905
  523055
  527831
  484139
  487195
  487313
  488829
  495584
  509036
  511076
  517832
  524045
  540977
  579194
  656477
  653233
  569097
  456688
  448260
  450990
  457841
  474611
  423982
  426084
  442387
  467888
  509672
  511250
  512345
  549134
  565838
  552585
  557569
  560832
  584669
  657667
  653467
  547549
  572913
  586595
  625547
  428047
  453686
  482120
  426238
  434359
  448876
  457617
  478361
  507846
  512540
  521647
  488259
  491920
  492921
  497300
  508245
]
3.79 ms
(1.73%)
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
  390938
  415793
  423361
  423982
  425725
  426084
  426238
  428047
  433410
  434359
  436681
  442387
  442435
  447173
  448260
  448876
  450990
  451156
  453686
  456075
  456373
  456648
  456688
  457617
  457841
  460334
  462011
  467532
  467888
  468097
  470443
  472300
  472350
  473258
  473259
  473690
  474611
  475207
  478361
  479592
  482120
  483035
  484123
  484139
  486958
  487195
  487313
  488157
  488259
  488829
  491040
  491920
  492921
  493452
  495584
  496042
  496429
  497300
  498364
  501935
  505071
  507846
  508245
  509036
  509641
  509672
  511076
  511250
  512345
  512540
  512738
  515757
  516534
  517832
  519610
  521474
  521647
  521905
  522308
  522488
  523055
  523276
  524045
  524624
  527831
  533138
  540977
  547549
  547617
  549134
  551612
  552585
  552663
  557569
  560832
  565426
  565838
  569097
  572913
  574721
  579194
  584669
  586595
  586838
  590601
  592263
  617660
  620626
  624933
  625547
  639208
  653233
  653467
  656477
  657667
  722846
  763437
  779012
  801292
  807506
]
1.84 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian girlfriend"
]
1.75 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск girlfriend"
]
1.67 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск girlfriend"
]
1.59 ms
(0.73%)
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.