GET https://search.jues.net/search/embeds/3?q=baby%20girls

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.40 ms
(54.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "baby девушк"
]
156.73 ms
(39.89%)
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
  396262
  408278
  417670
  424528
  424697
  424984
  425323
  426069
  426306
  426697
  429345
  430516
  433718
  433939
  433964
  443412
  445423
  445941
  447859
  448172
  449838
  455367
  455403
  456447
  458153
  461122
  462704
  462721
  465179
  465819
  466706
  468238
  469661
  471497
  472551
  482850
  482973
  483200
  483838
  488275
  491095
  495828
  497753
  498078
  498994
  501910
  503642
  503804
  505846
  508935
  510131
  520082
  520099
  520107
  527694
  530255
  539857
  540677
  541818
  546028
  546629
  553842
  555740
  560918
  564170
  567880
  568886
  568932
  571072
  571269
  575338
  577912
  578303
  579534
  581453
  581916
  584795
  586449
  589832
  589860
  589907
  590641
  592715
  597234
  597243
  597267
  603421
  604183
  612675
  619071
  619367
  620701
  637096
  659204
  680150
  680321
  688818
  693292
  703584
  731837
  732262
  738625
  744723
  748979
  758226
  759344
  763358
  769518
  779247
  790481
  792634
  795713
  799814
  807469
  808143
  808321
  810303
  812364
  815594
  816455
]
16.03 ms
(4.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
  520107
  589907
  592715
  469661
  560918
  688818
  578303
  744723
  433939
  816455
  508935
  483200
  546629
  581453
  541818
  703584
  567880
  799814
  790481
  795713
  462704
  433964
  458153
  527694
  510131
  568932
  589860
  748979
  497753
  530255
  571072
  584795
  680321
  564170
  779247
  732262
  807469
  808321
  731837
  763358
  456447
  455403
  455367
  462721
  498078
  586449
  597267
  812364
  396262
  408278
  417670
  553842
  568886
  693292
  604183
  603421
  808143
  769518
  426069
  443412
  472551
  555740
  579534
  738625
  471497
  465819
  448172
  449838
  424528
  424697
  430516
  491095
  424984
  466706
  468238
  482973
  619071
  426306
  426697
  483838
  520099
  546028
  577912
  589832
  590641
  612675
  810303
  445423
  465179
  501910
  488275
  495828
  503804
  520082
  505846
  429345
  540677
  680150
  619367
  433718
  659204
  575338
  620701
  792634
  425323
  503642
  815594
  571269
  581916
  597234
  637096
  758226
  445941
  482850
  498994
  447859
  539857
  461122
  597243
  759344
]
2.61 ms
(0.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
  396262
  408278
  417670
  424528
  424697
  424984
  425323
  426069
  426306
  426697
  429345
  430516
  433718
  433939
  433964
  443412
  445423
  445941
  447859
  448172
  449838
  455367
  455403
  456447
  458153
  461122
  462704
  462721
  465179
  465819
  466706
  468238
  469661
  471497
  472551
  482850
  482973
  483200
  483838
  488275
  491095
  495828
  497753
  498078
  498994
  501910
  503642
  503804
  505846
  508935
  510131
  520082
  520099
  520107
  527694
  530255
  539857
  540677
  541818
  546028
  546629
  553842
  555740
  560918
  564170
  567880
  568886
  568932
  571072
  571269
  575338
  577912
  578303
  579534
  581453
  581916
  584795
  586449
  589832
  589860
  589907
  590641
  592715
  597234
  597243
  597267
  603421
  604183
  612675
  619071
  619367
  620701
  637096
  659204
  680150
  680321
  688818
  693292
  703584
  731837
  732262
  738625
  744723
  748979
  758226
  759344
  763358
  769518
  779247
  790481
  792634
  795713
  799814
  807469
  808143
  808321
  810303
  812364
  815594
  816455
]
2.04 ms
(0.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "baby girls"
]
1.63 ms
(0.42%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "baby девушк"
]
1.48 ms
(0.38%)
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.