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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
190.40 ms
(88.01%)
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
  381917
  387130
  396686
  400684
  416439
  417927
  418350
  421809
  424299
  426796
  430728
  433748
  436577
  437797
  440361
  442486
  442943
  444078
  444577
  444853
  445778
  446560
  451138
  452554
  454239
  454616
  458262
  459195
  459306
  459684
  460064
  460257
  461256
  463501
  464687
  464815
  469597
  471690
  472042
  474312
  476510
  477235
  479877
  487711
  491017
  497652
  498346
  498539
  498576
  498620
  498834
  499134
  502195
  504937
  509068
  510555
  510847
  510888
  512017
  513310
  513848
  517084
  519383
  519820
  520183
  521051
  525350
  529174
  529969
  536372
  538497
  540377
  546577
  548850
  552247
  555468
  556150
  559191
  559586
  562062
  566071
  572530
  574381
  577475
  583283
  585767
  589436
  591827
  596138
  597853
  598388
  600910
  604604
  605412
  613517
  619477
  628515
  632198
  634589
  647950
  666816
  675448
  688148
  706400
  715287
  720618
  726936
  747404
  771821
  775846
  776678
  780406
  784417
  789764
  790853
  799190
  813101
  814210
  821847
]
16.28 ms
(7.53%)
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
  512017
  513848
  498834
  519383
  540377
  559191
  589436
  444853
  487711
  400684
  416439
  459306
  546577
  597853
  446560
  555468
  498620
  510555
  583283
  647950
  666816
  613517
  628515
  726936
  780406
  417927
  451138
  471690
  596138
  499134
  747404
  437797
  436577
  445778
  454616
  502195
  518967
  498539
  536372
  464815
  556150
  562062
  585767
  600910
  813101
  387130
  440361
  498346
  510847
  498576
  381917
  430728
  444577
  442486
  444078
  418350
  421809
  814210
  821847
  460257
  474312
  491017
  459195
  460064
  472042
  497652
  510888
  519820
  521051
  504937
  509068
  513310
  517084
  520183
  529174
  538497
  525350
  529969
  463501
  464687
  469597
  548850
  566071
  552247
  577475
  720618
  675448
  688148
  706400
  715287
  559586
  572530
  574381
  598388
  591827
  604604
  605412
  634589
  775846
  776678
  789764
  784417
  771821
  619477
  632198
  790853
  799190
  426796
  452554
  476510
  433748
  396686
  424299
  459684
  477235
  479877
  442943
  454239
  458262
  461256
]
2.82 ms
(1.30%)
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
  381917
  387130
  396686
  400684
  416439
  417927
  418350
  421809
  424299
  426796
  430728
  433748
  436577
  437797
  440361
  442486
  442943
  444078
  444577
  444853
  445778
  446560
  451138
  452554
  454239
  454616
  458262
  459195
  459306
  459684
  460064
  460257
  461256
  463501
  464687
  464815
  469597
  471690
  472042
  474312
  476510
  477235
  479877
  487711
  491017
  497652
  498346
  498539
  498576
  498620
  498834
  499134
  502195
  504937
  509068
  510555
  510847
  510888
  512017
  513310
  513848
  517084
  519383
  519820
  520183
  521051
  525350
  529174
  529969
  536372
  538497
  540377
  546577
  548850
  552247
  555468
  556150
  559191
  559586
  562062
  566071
  572530
  574381
  577475
  583283
  585767
  589436
  591827
  596138
  597853
  598388
  600910
  604604
  605412
  613517
  619477
  628515
  632198
  634589
  647950
  666816
  675448
  688148
  706400
  715287
  720618
  726936
  747404
  771821
  775846
  776678
  780406
  784417
  789764
  790853
  799190
  813101
  814210
  821847
]
1.90 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "perfect big ass"
]
1.68 ms
(0.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "perfect большая большие жоп"
]
1.64 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "perfect большая большие жоп"
]
1.62 ms
(0.75%)
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.