GET https://search.jues.net/search/embeds/10?q=black%20black%20girls

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.28 ms
(84.80%)
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
  33236
  69611
  154491
  155198
  383011
  383933
  393660
  395989
  396711
  399038
  399255
  402350
  403293
  404360
  405508
  410076
  411052
  414101
  415155
  417495
  417825
  419998
  432105
  437517
  441901
  445973
  449161
  454331
  458202
  461738
  462802
  465700
  467110
  468789
  477082
  483587
  489347
  493001
  496308
  499556
  509149
  510017
  510330
  512120
  519766
  519862
  526095
  529634
  536570
  536930
  537832
  538725
  540528
  545475
  548588
  554797
  557749
  558171
  560292
  565098
  566242
  568257
  580614
  580757
  589238
  590165
  591162
  593104
  598504
  602061
  602894
  607101
  607152
  607215
  608516
  617130
  620487
  623963
  624831
  630913
  637077
  638477
  660365
  663321
  666490
  674100
  683593
  695464
  704184
  704185
  709885
  710266
  710872
  718947
  719243
  720186
  724841
  725115
  730466
  732468
  738855
  740268
  740965
  741296
  742163
  744607
  745111
  768692
  785552
  785580
  789790
  796629
  796871
  797051
  803374
  807847
  812738
  814130
  814459
  823030
]
12.96 ms
(8.70%)
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
  33236
  405508
  383011
  155198
  396711
  399038
  402350
  403293
  411052
  417825
  410076
  432105
  814130
  462802
  483587
  454331
  468789
  489347
  510017
  512120
  519766
  499556
  536930
  537832
  540528
  560292
  565098
  683593
  674100
  704184
  710266
  710872
  719243
  660365
  704185
  566242
  591162
  590165
  589238
  602894
  630913
  638477
  796871
  807847
  789790
  796629
  803374
  742163
  744607
  741296
  745111
  732468
  768692
  724841
  740965
  620487
  797051
  812738
  417495
  458202
  461738
  395989
  419998
  445973
  465700
  509149
  496308
  545475
  399255
  404360
  441901
  785580
  415155
  510330
  383933
  69611
  437517
  814459
  477082
  449161
  493001
  536570
  526095
  558171
  568257
  666490
  695464
  718947
  720186
  580614
  624831
  598504
  617130
  730466
  725115
  740268
  738855
  607215
  709885
  154491
  393660
  414101
  823030
  467110
  519862
  529634
  538725
  548588
  554797
  557749
  663321
  580757
  623963
  607152
  602061
  607101
  593104
  608516
  637077
  785552
]
3.20 ms
(2.15%)
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
  33236
  69611
  154491
  155198
  383011
  383933
  393660
  395989
  396711
  399038
  399255
  402350
  403293
  404360
  405508
  410076
  411052
  414101
  415155
  417495
  417825
  419998
  432105
  437517
  441901
  445973
  449161
  454331
  458202
  461738
  462802
  465700
  467110
  468789
  477082
  483587
  489347
  493001
  496308
  499556
  509149
  510017
  510330
  512120
  519766
  519862
  526095
  529634
  536570
  536930
  537832
  538725
  540528
  545475
  548588
  554797
  557749
  558171
  560292
  565098
  566242
  568257
  580614
  580757
  589238
  590165
  591162
  593104
  598504
  602061
  602894
  607101
  607152
  607215
  608516
  617130
  620487
  623963
  624831
  630913
  637077
  638477
  660365
  663321
  666490
  674100
  683593
  695464
  704184
  704185
  709885
  710266
  710872
  718947
  719243
  720186
  724841
  725115
  730466
  732468
  738855
  740268
  740965
  741296
  742163
  744607
  745111
  768692
  785552
  785580
  789790
  796629
  796871
  797051
  803374
  807847
  812738
  814130
  814459
  823030
]
1.75 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "black black girls"
]
1.69 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "black black девушк"
]
1.43 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "black black девушк"
]

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.