GET https://search.jues.net/search/embeds/6?q=squirt%20on%20dick

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.13 ms
(83.22%)
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
  396330
  398235
  398719
  399143
  405528
  416820
  418578
  418607
  418738
  421152
  422134
  422733
  424362
  425034
  426675
  434378
  434693
  438878
  447697
  448327
  449322
  451014
  451248
  452720
  453332
  454531
  455471
  468022
  468135
  469755
  472230
  473133
  473907
  478963
  478970
  492718
  493220
  504958
  505101
  505692
  507737
  508430
  510224
  510291
  511348
  516015
  516656
  517798
  522383
  524592
  526461
  527193
  530026
  531184
  531908
  532655
  538963
  545372
  545465
  545469
  545599
  556747
  560225
  561495
  564120
  567737
  584762
  585983
  586339
  588070
  593615
  599833
  599966
  600252
  600481
  604053
  608442
  613860
  620298
  625753
  628507
  631604
  631947
  639760
  639767
  644986
  653520
  666863
  666880
  666894
  682911
  693024
  693753
  694907
  712286
  720235
  725309
  725649
  728340
  735631
  745964
  749732
  755478
  758218
  759488
  764081
  766372
  773416
  783108
  789939
  800226
  800884
  801041
  801084
  801949
  802570
  810299
  814114
  814883
  826873
]
17.72 ms
(10.75%)
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
  545372
  545469
  399143
  451014
  454531
  468022
  452720
  453332
  473133
  505692
  531184
  545465
  556747
  584762
  448327
  455471
  422733
  468135
  524592
  492718
  504958
  725649
  801084
  801041
  508430
  516015
  438878
  473907
  449322
  493220
  511348
  560225
  653520
  693024
  631604
  608442
  773416
  749732
  625753
  800884
  517798
  764081
  604053
  561495
  586339
  613860
  759488
  666863
  712286
  720235
  783108
  530026
  644986
  532655
  666880
  666894
  639767
  545599
  802570
  418738
  814883
  600481
  810299
  422134
  516656
  694907
  434693
  418607
  538963
  600252
  510291
  522383
  531908
  620298
  631947
  478963
  478970
  418578
  451248
  505101
  398719
  814114
  682911
  567737
  585983
  593615
  728340
  766372
  758218
  789939
  628507
  800226
  735631
  510224
  527193
  421152
  425034
  693753
  725309
  755478
  745964
  588070
  526461
  405528
  416820
  447697
  801949
  396330
  424362
  426675
  434378
  472230
  469755
  507737
  564120
  826873
  398235
  599966
  639760
  599833
]
2.71 ms
(1.65%)
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
  396330
  398235
  398719
  399143
  405528
  416820
  418578
  418607
  418738
  421152
  422134
  422733
  424362
  425034
  426675
  434378
  434693
  438878
  447697
  448327
  449322
  451014
  451248
  452720
  453332
  454531
  455471
  468022
  468135
  469755
  472230
  473133
  473907
  478963
  478970
  492718
  493220
  504958
  505101
  505692
  507737
  508430
  510224
  510291
  511348
  516015
  516656
  517798
  522383
  524592
  526461
  527193
  530026
  531184
  531908
  532655
  538963
  545372
  545465
  545469
  545599
  556747
  560225
  561495
  564120
  567737
  584762
  585983
  586339
  588070
  593615
  599833
  599966
  600252
  600481
  604053
  608442
  613860
  620298
  625753
  628507
  631604
  631947
  639760
  639767
  644986
  653520
  666863
  666880
  666894
  682911
  693024
  693753
  694907
  712286
  720235
  725309
  725649
  728340
  735631
  745964
  749732
  755478
  758218
  759488
  764081
  766372
  773416
  783108
  789939
  800226
  800884
  801041
  801084
  801949
  802570
  810299
  814114
  814883
  826873
]
2.08 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "squirt on dick"
]
1.82 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сквирт оргазм член"
]
1.66 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сквирт оргазм член"
]
1.66 ms
(1.01%)
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.