GET https://search.jues.net/search/embeds/3?q=blonde%20tights

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.12 ms
(56.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blonde tights"
]
128.52 ms
(34.82%)
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
  45853
  133695
  161969
  186592
  212750
  212982
  213057
  213330
  213692
  290232
  318700
  325648
  329508
  383440
  384864
  384878
  385216
  385992
  386839
  390734
  394670
  395633
  400811
  400847
  402306
  402530
  409652
  411373
  411421
  416675
  417521
  418724
  423521
  424502
  428241
  432297
  444895
  446086
  446252
  447694
  448487
  450748
  452260
  459614
  464336
  464502
  466027
  472898
  478125
  478131
  480389
  485437
  491188
  496781
  502843
  505333
  505634
  514443
  516055
  516778
  521093
  523168
  529015
  530007
  531945
  539208
  542987
  551269
  554097
  554524
  555065
  555567
  564597
  567860
  569440
  572954
  576728
  584793
  590613
  597051
  597550
  600384
  603507
  605864
  618856
  620228
  620250
  644707
  669907
  716621
  717410
  717610
  725138
  728167
  728172
  748690
  752359
  755355
  755442
  756409
  757803
  758417
  769158
  771867
  772021
  781189
  786438
  795149
  795858
  797262
  798573
  802460
  807383
  809328
  811095
  812697
  814049
  819009
  823103
  828633
]
22.97 ms
(6.22%)
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
  496781
  644707
  620228
  795858
  809328
  786438
  755442
  290232
  485437
  828633
  386839
  505333
  539208
  576728
  597051
  758417
  769158
  797262
  728172
  752359
  771867
  781189
  798573
  402530
  213057
  446252
  480389
  447694
  466027
  542987
  569440
  424502
  444895
  448487
  478125
  478131
  516778
  521093
  531945
  755355
  161969
  384864
  133695
  464502
  554524
  717610
  600384
  802460
  811095
  748690
  812697
  756409
  728167
  725138
  395633
  472898
  384878
  450748
  605864
  417521
  325648
  411373
  823103
  385216
  329508
  400847
  409652
  428241
  491188
  584793
  554097
  564597
  567860
  590613
  807383
  416675
  452260
  411421
  385992
  459614
  505634
  502843
  523168
  530007
  618856
  620250
  446086
  669907
  717410
  551269
  555065
  603507
  772021
  795149
  516055
  212750
  186592
  716621
  212982
  402306
  383440
  318700
  418724
  464336
  572954
  514443
  597550
  213692
  45853
  819009
  529015
  757803
  394670
  213330
  400811
  814049
  390734
  423521
  432297
  555567
]
3.70 ms
(1.00%)
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
  45853
  133695
  161969
  186592
  212750
  212982
  213057
  213330
  213692
  290232
  318700
  325648
  329508
  383440
  384864
  384878
  385216
  385992
  386839
  390734
  394670
  395633
  400811
  400847
  402306
  402530
  409652
  411373
  411421
  416675
  417521
  418724
  423521
  424502
  428241
  432297
  444895
  446086
  446252
  447694
  448487
  450748
  452260
  459614
  464336
  464502
  466027
  472898
  478125
  478131
  480389
  485437
  491188
  496781
  502843
  505333
  505634
  514443
  516055
  516778
  521093
  523168
  529015
  530007
  531945
  539208
  542987
  551269
  554097
  554524
  555065
  555567
  564597
  567860
  569440
  572954
  576728
  584793
  590613
  597051
  597550
  600384
  603507
  605864
  618856
  620228
  620250
  644707
  669907
  716621
  717410
  717610
  725138
  728167
  728172
  748690
  752359
  755355
  755442
  756409
  757803
  758417
  769158
  771867
  772021
  781189
  786438
  795149
  795858
  797262
  798573
  802460
  807383
  809328
  811095
  812697
  814049
  819009
  823103
  828633
]
2.13 ms
(0.58%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беловолосая колготк"
]
2.07 ms
(0.56%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.