GET https://search.jues.net/search/embeds/6?q=girls%20cute

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.59 ms
(85.19%)
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
  21109
  82133
  398486
  410356
  417733
  434664
  452662
  469775
  475754
  529498
  548702
  554724
  563572
  565117
  585784
  585802
  598789
  602769
  605120
  607845
  610834
  616966
  617183
  617754
  620581
  621161
  630991
  633995
  636798
  639915
  642908
  644052
  646449
  648722
  661387
  670395
  671531
  674872
  678421
  678683
  680676
  684799
  686046
  691969
  695661
  699005
  703111
  707276
  708451
  709916
  713977
  720378
  720845
  721091
  721522
  722772
  722874
  724003
  727906
  730043
  730276
  732041
  736889
  737219
  741233
  742160
  743496
  744018
  746075
  746096
  746406
  748561
  751762
  752116
  756312
  757373
  757585
  762136
  762627
  763776
  764376
  764696
  764994
  766055
  766861
  767348
  771163
  772416
  772738
  777132
  778667
  779027
  779233
  782739
  789355
  790583
  791303
  791380
  791389
  792269
  793714
  796995
  797104
  797812
  799303
  800534
  801594
  804228
  805057
  806641
  807932
  808082
  809810
  811049
  816143
  817022
  818083
  821984
  825120
]
10.71 ms
(7.50%)
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
  722874
  616966
  607845
  610834
  636798
  642908
  800534
  804228
  730043
  790583
  796995
  797104
  736889
  757585
  724003
  751762
  766861
  762627
  764376
  766055
  772738
  630991
  644052
  809810
  417733
  21109
  82133
  452662
  398486
  434664
  821984
  825120
  565117
  670395
  684799
  703111
  721091
  646449
  686046
  691969
  695661
  722772
  699005
  708451
  720845
  548702
  585802
  602769
  620581
  633995
  617754
  598789
  605120
  639915
  778213
  793714
  807932
  779027
  782739
  792269
  767348
  772416
  797812
  799303
  801594
  805057
  808082
  811049
  757373
  743496
  762136
  730276
  737219
  752116
  763776
  764696
  764994
  720378
  778667
  779233
  789355
  410356
  818083
  817022
  816143
  469775
  475754
  529498
  563572
  648722
  674872
  678683
  707276
  671531
  680676
  709916
  713977
  661387
  678421
  554724
  585784
  617183
  621161
  777132
  791380
  732041
  744018
  746406
  748561
  756312
  791389
  806641
  741233
  746075
  727906
  742160
  746096
  771163
  721522
  791303
]
3.12 ms
(2.19%)
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
  21109
  82133
  398486
  410356
  417733
  434664
  452662
  469775
  475754
  529498
  548702
  554724
  563572
  565117
  585784
  585802
  598789
  602769
  605120
  607845
  610834
  616966
  617183
  617754
  620581
  621161
  630991
  633995
  636798
  639915
  642908
  644052
  646449
  648722
  661387
  670395
  671531
  674872
  678421
  678683
  680676
  684799
  686046
  691969
  695661
  699005
  703111
  707276
  708451
  709916
  713977
  720378
  720845
  721091
  721522
  722772
  722874
  724003
  727906
  730043
  730276
  732041
  736889
  737219
  741233
  742160
  743496
  744018
  746075
  746096
  746406
  748561
  751762
  752116
  756312
  757373
  757585
  762136
  762627
  763776
  764376
  764696
  764994
  766055
  766861
  767348
  771163
  772416
  772738
  777132
  778667
  779027
  779233
  782739
  789355
  790583
  791303
  791380
  791389
  792269
  793714
  796995
  797104
  797812
  799303
  800534
  801594
  804228
  805057
  806641
  807932
  808082
  809810
  811049
  816143
  817022
  818083
  821984
  825120
]
2.23 ms
(1.56%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(1.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк cute"
]
1.73 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girls cute"
]
1.52 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк cute"
]

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.