GET https://search.jues.net/search/embeds/6?q=bra%20white

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
177.66 ms
(84.63%)
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
  282264
  384811
  396778
  399659
  405561
  414975
  415444
  416253
  416420
  421712
  423321
  423684
  424329
  425996
  426432
  428281
  430969
  437451
  437655
  442148
  443320
  444780
  445808
  446204
  447896
  450435
  450565
  451642
  452229
  452497
  453713
  453890
  454636
  454858
  454965
  455797
  456713
  457554
  458879
  459158
  460036
  460436
  462968
  464619
  465861
  466165
  466268
  466712
  467988
  468450
  469277
  469424
  469862
  470310
  471812
  472654
  473772
  474108
  475167
  476071
  477653
  479928
  481315
  482242
  484598
  486801
  486860
  489014
  490852
  491146
  491166
  492415
  492614
  494798
  499784
  500249
  500562
  506562
  508478
  509217
  509712
  509869
  509881
  509904
  511066
  511310
  511823
  512471
  512893
  513276
  513983
  514640
  515059
  517151
  517383
  517386
  518091
  518521
  519023
  519300
  520330
  520878
  521376
  521687
  521739
  522049
  522297
  522543
  522806
  523030
  523505
  524915
  529070
  531513
  532980
  538145
  538212
  548555
  583139
  589041
]
22.13 ms
(10.54%)
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
  514640
  521739
  529070
  490852
  282264
  459158
  492415
  456713
  469277
  444780
  479928
  460436
  521376
  519300
  447896
  464619
  509712
  509904
  523030
  524915
  442148
  414975
  471812
  522297
  466268
  486860
  512471
  500562
  454636
  466165
  423684
  508478
  583139
  443320
  384811
  416253
  421712
  426432
  445808
  451642
  454858
  465861
  469862
  472654
  474108
  462968
  538145
  532980
  499784
  515059
  460036
  489014
  548555
  405561
  453713
  453890
  477653
  430969
  466712
  482242
  458879
  467988
  470310
  475167
  428281
  437655
  468450
  437451
  450565
  476071
  481315
  509217
  509881
  513276
  538212
  486801
  491146
  492614
  500249
  517151
  518091
  523505
  494798
  511310
  511823
  512893
  513983
  517383
  589041
  473772
  424329
  517386
  522806
  520330
  446204
  452497
  484598
  509869
  531513
  519023
  506562
  491166
  520878
  511066
  469424
  521687
  518521
  522543
  522049
  396778
  399659
  423321
  415444
  416420
  425996
  452229
  454965
  455797
  450435
  457554
]
2.64 ms
(1.26%)
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
  282264
  384811
  396778
  399659
  405561
  414975
  415444
  416253
  416420
  421712
  423321
  423684
  424329
  425996
  426432
  428281
  430969
  437451
  437655
  442148
  443320
  444780
  445808
  446204
  447896
  450435
  450565
  451642
  452229
  452497
  453713
  453890
  454636
  454858
  454965
  455797
  456713
  457554
  458879
  459158
  460036
  460436
  462968
  464619
  465861
  466165
  466268
  466712
  467988
  468450
  469277
  469424
  469862
  470310
  471812
  472654
  473772
  474108
  475167
  476071
  477653
  479928
  481315
  482242
  484598
  486801
  486860
  489014
  490852
  491146
  491166
  492415
  492614
  494798
  499784
  500249
  500562
  506562
  508478
  509217
  509712
  509869
  509881
  509904
  511066
  511310
  511823
  512471
  512893
  513276
  513983
  514640
  515059
  517151
  517383
  517386
  518091
  518521
  519023
  519300
  520330
  520878
  521376
  521687
  521739
  522049
  522297
  522543
  522806
  523030
  523505
  524915
  529070
  531513
  532980
  538145
  538212
  548555
  583139
  589041
]
2.29 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bra white"
]
1.86 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "бюстгалтер нижн бел white"
]
1.79 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "бюстгалтер нижн бел white"
]

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.