GET https://search.jues.net/search/embeds/6?q=blonde%20old

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.10 ms
(81.33%)
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
  41516
  170836
  187567
  188266
  188507
  233331
  257966
  330462
  381940
  382003
  382411
  383373
  383472
  383565
  383631
  383987
  384752
  384856
  384878
  385163
  385882
  386205
  386864
  388449
  388765
  388769
  389482
  390497
  390653
  391163
  392458
  392729
  393771
  395654
  395688
  395695
  395849
  396270
  396312
  396472
  396757
  396862
  396947
  396966
  396983
  399304
  399689
  399865
  400166
  400196
  402570
  403042
  404953
  405188
  407362
  407383
  407414
  407796
  409667
  409894
  412303
  419428
  419844
  424463
  443705
  443997
  447246
  449880
  454187
  455197
  464960
  466131
  466847
  467336
  474060
  475100
  476559
  477960
  489138
  491776
  504393
  518917
  522003
  554472
  592735
  622037
  623598
  637747
  698293
  698708
  717708
  717713
  720701
  721704
  722662
  725138
  725558
  726859
  732078
  734692
  737897
  744095
  745999
  752945
  754227
  757151
  760615
  770280
  772109
  774927
  775014
  775994
  786172
  797915
  800074
  801371
  802460
  804192
  805221
  808224
]
18.13 ms
(12.08%)
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
  801371
  774927
  802460
  726859
  734692
  754227
  757151
  772109
  800074
  725558
  732078
  745999
  744095
  725138
  737897
  760615
  770280
  622037
  623598
  637747
  698293
  698708
  717708
  717713
  720701
  721704
  775014
  775994
  786172
  797915
  804192
  805221
  187567
  386864
  466131
  466847
  41516
  407383
  454187
  467336
  384878
  385882
  395654
  396862
  399689
  399865
  424463
  447246
  233331
  388769
  391163
  396966
  412303
  443705
  477960
  419844
  443997
  504393
  522003
  752945
  409667
  383472
  396312
  403042
  592735
  722662
  384856
  393771
  257966
  170836
  402570
  383987
  388449
  400166
  407362
  409894
  449880
  464960
  518917
  554472
  381940
  400196
  407414
  475100
  476559
  404953
  419428
  405188
  455197
  489138
  491776
  396947
  407796
  808224
  474060
  388765
  396757
  386205
  383373
  385163
  384752
  383565
  383631
  188266
  188507
  392458
  392729
  395688
  395695
  395849
  330462
  382003
  382411
  389482
  390497
  390653
  396270
  396472
  396983
  399304
]
2.49 ms
(1.66%)
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
  41516
  170836
  187567
  188266
  188507
  233331
  257966
  330462
  381940
  382003
  382411
  383373
  383472
  383565
  383631
  383987
  384752
  384856
  384878
  385163
  385882
  386205
  386864
  388449
  388765
  388769
  389482
  390497
  390653
  391163
  392458
  392729
  393771
  395654
  395688
  395695
  395849
  396270
  396312
  396472
  396757
  396862
  396947
  396966
  396983
  399304
  399689
  399865
  400166
  400196
  402570
  403042
  404953
  405188
  407362
  407383
  407414
  407796
  409667
  409894
  412303
  419428
  419844
  424463
  443705
  443997
  447246
  449880
  454187
  455197
  464960
  466131
  466847
  467336
  474060
  475100
  476559
  477960
  489138
  491776
  504393
  518917
  522003
  554472
  592735
  622037
  623598
  637747
  698293
  698708
  717708
  717713
  720701
  721704
  722662
  725138
  725558
  726859
  732078
  734692
  737897
  744095
  745999
  752945
  754227
  757151
  760615
  770280
  772109
  774927
  775014
  775994
  786172
  797915
  800074
  801371
  802460
  804192
  805221
  808224
]
2.11 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blonde old"
]
1.94 ms
(1.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беловолосая old"
]
1.69 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "беловолосая old"
]
1.66 ms
(1.11%)
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.