GET https://search.jues.net/search/embeds/10?q=big%20cock%20doggy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.53 ms
(89.05%)
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
  358864
  397265
  402904
  421648
  425113
  434582
  434767
  438050
  438830
  441933
  444928
  447848
  452216
  453467
  455775
  456349
  456477
  457974
  458448
  458651
  459441
  459933
  459948
  460489
  462006
  462115
  462598
  463301
  463458
  465747
  466004
  468399
  468427
  469638
  471460
  471603
  472650
  472852
  473296
  475201
  476071
  481237
  483224
  483633
  484544
  485417
  487993
  494883
  497647
  499997
  500542
  504732
  504967
  505295
  505498
  505732
  505997
  506872
  508367
  508727
  508977
  509859
  509872
  512910
  512960
  513515
  514931
  516788
  519604
  520000
  520318
  520588
  520614
  521175
  521851
  525146
  527294
  543764
  544279
  544280
  546945
  549576
  551581
  559737
  564747
  565380
  569007
  574222
  574703
  578088
  578217
  580029
  580393
  580611
  588787
  593207
  599527
  601241
  601291
  601337
  606709
  611813
  616856
  625863
  626291
  634127
  656320
  662475
  681879
  682588
  683565
  718657
  744856
  745918
  759745
  761600
  777168
  780728
  811496
  824363
]
10.31 ms
(5.86%)
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
  434582
  455775
  456477
  471460
  458448
  459441
  459948
  497647
  505997
  506872
  508977
  521175
  527294
  494883
  520000
  500542
  521851
  525146
  463301
  472650
  472852
  544280
  662475
  682588
  580393
  434767
  438830
  444928
  453467
  456349
  462115
  468399
  473296
  475201
  358864
  397265
  402904
  441933
  447848
  465747
  458651
  460489
  462006
  481237
  462598
  469638
  438050
  466004
  468427
  471603
  476071
  504732
  508367
  509872
  520318
  483633
  485417
  499997
  504967
  505295
  519604
  520588
  520614
  483224
  487993
  505498
  508727
  512910
  512960
  516788
  505732
  509859
  513515
  514931
  463458
  546945
  601337
  484544
  425113
  421648
  459933
  457974
  824363
  580029
  543764
  544279
  551581
  559737
  564747
  569007
  574222
  574703
  580611
  549576
  578088
  656320
  683565
  681879
  718657
  565380
  578217
  611813
  625863
  588787
  601291
  606709
  593207
  599527
  601241
  616856
  634127
  780728
  761600
  744856
  745918
  626291
  777168
  452216
  811496
  759745
]
2.52 ms
(1.43%)
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
  358864
  397265
  402904
  421648
  425113
  434582
  434767
  438050
  438830
  441933
  444928
  447848
  452216
  453467
  455775
  456349
  456477
  457974
  458448
  458651
  459441
  459933
  459948
  460489
  462006
  462115
  462598
  463301
  463458
  465747
  466004
  468399
  468427
  469638
  471460
  471603
  472650
  472852
  473296
  475201
  476071
  481237
  483224
  483633
  484544
  485417
  487993
  494883
  497647
  499997
  500542
  504732
  504967
  505295
  505498
  505732
  505997
  506872
  508367
  508727
  508977
  509859
  509872
  512910
  512960
  513515
  514931
  516788
  519604
  520000
  520318
  520588
  520614
  521175
  521851
  525146
  527294
  543764
  544279
  544280
  546945
  549576
  551581
  559737
  564747
  565380
  569007
  574222
  574703
  578088
  578217
  580029
  580393
  580611
  588787
  593207
  599527
  601241
  601291
  601337
  606709
  611813
  616856
  625863
  626291
  634127
  656320
  662475
  681879
  682588
  683565
  718657
  744856
  745918
  759745
  761600
  777168
  780728
  811496
  824363
]
2.08 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big cock doggy"
]
1.49 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие cock рак"
]
1.42 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие cock рак"
]

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.