GET https://search.jues.net/search/embeds/8?q=teen%20tights

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.68 ms
(82.74%)
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
  338371
  386166
  391717
  393670
  397785
  406339
  421482
  421971
  425594
  432543
  433435
  433574
  433600
  433618
  433662
  433867
  445431
  451161
  452322
  452394
  458605
  462969
  466987
  469177
  469644
  470170
  470422
  470961
  471693
  475032
  505979
  508750
  510010
  511761
  515720
  516035
  523390
  524115
  525081
  525965
  527497
  528361
  529018
  529022
  535427
  542002
  547658
  550480
  560925
  571219
  571834
  574887
  597003
  599072
  601194
  614967
  616296
  621259
  624689
  632697
  633472
  633518
  634106
  635141
  636059
  636183
  637106
  637134
  644498
  651611
  656942
  659315
  687431
  689315
  689616
  694010
  694953
  702627
  710946
  711274
  715050
  716900
  720273
  721549
  728167
  735768
  740934
  747469
  752566
  755630
  758201
  758579
  761495
  761625
  764116
  766835
  772449
  775269
  776484
  777173
  777921
  781006
  784744
  785606
  785868
  787438
  792799
  796364
  797247
  800572
  804319
  805242
  806043
  806842
  806919
  808787
  811786
  816755
  819613
  821044
]
17.19 ms
(10.48%)
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
  735768
  747469
  761625
  635141
  715050
  777173
  777921
  784744
  800572
  393670
  421482
  433600
  433867
  516035
  525081
  510010
  515720
  547658
  560925
  525965
  466987
  637134
  632697
  386166
  338371
  819613
  821044
  816755
  462969
  469644
  470422
  445431
  451161
  475032
  505979
  523390
  508750
  529018
  535427
  542002
  550480
  574887
  656942
  651611
  659315
  689616
  694010
  694953
  711274
  687431
  689315
  710946
  720273
  721549
  571219
  634106
  636183
  599072
  624689
  636059
  597003
  614967
  616296
  601194
  637106
  781006
  804319
  805242
  806919
  808787
  811786
  776484
  787438
  796364
  806842
  740934
  758579
  761495
  772449
  785606
  785868
  792799
  797247
  806043
  755630
  766835
  752566
  758201
  764116
  728167
  633472
  633518
  644498
  702627
  775269
  391717
  452322
  458605
  470961
  421971
  433435
  433662
  397785
  406339
  425594
  432543
  469177
  470170
  433574
  433618
  452394
  471693
  511761
  529022
  524115
  527497
  716900
  528361
  571834
  621259
]
3.41 ms
(2.08%)
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
  338371
  386166
  391717
  393670
  397785
  406339
  421482
  421971
  425594
  432543
  433435
  433574
  433600
  433618
  433662
  433867
  445431
  451161
  452322
  452394
  458605
  462969
  466987
  469177
  469644
  470170
  470422
  470961
  471693
  475032
  505979
  508750
  510010
  511761
  515720
  516035
  523390
  524115
  525081
  525965
  527497
  528361
  529018
  529022
  535427
  542002
  547658
  550480
  560925
  571219
  571834
  574887
  597003
  599072
  601194
  614967
  616296
  621259
  624689
  632697
  633472
  633518
  634106
  635141
  636059
  636183
  637106
  637134
  644498
  651611
  656942
  659315
  687431
  689315
  689616
  694010
  694953
  702627
  710946
  711274
  715050
  716900
  720273
  721549
  728167
  735768
  740934
  747469
  752566
  755630
  758201
  758579
  761495
  761625
  764116
  766835
  772449
  775269
  776484
  777173
  777921
  781006
  784744
  785606
  785868
  787438
  792799
  796364
  797247
  800572
  804319
  805242
  806043
  806842
  806919
  808787
  811786
  816755
  819613
  821044
]
2.16 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen tights"
]
2.11 ms
(1.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.95 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen колготк"
]
1.50 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen колготк"
]

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.