GET https://search.jues.net/search/embeds/8?q=gorgeous%20wife

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.90 ms
(83.21%)
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
  390257
  398686
  407176
  417238
  424284
  424720
  427655
  429911
  436900
  438296
  438984
  445355
  446525
  450656
  452290
  452688
  454030
  455182
  455488
  455540
  455976
  457328
  459138
  459210
  459354
  459645
  459755
  459887
  461318
  463701
  464068
  464780
  465232
  468112
  469492
  470990
  473315
  475148
  475777
  475818
  479918
  480835
  486808
  488744
  497125
  501367
  506707
  526887
  537164
  545046
  554680
  558725
  563682
  576167
  577281
  583795
  596450
  600690
  615494
  618760
  619570
  626041
  626659
  628591
  628602
  629660
  640937
  651690
  652757
  660032
  660454
  663747
  667427
  668097
  670189
  676205
  687535
  688166
  695444
  705201
  706077
  709620
  710173
  723239
  724086
  728094
  732525
  734708
  739802
  739821
  745269
  748282
  749930
  753621
  765194
  765636
  767651
  777751
  777757
  777761
  777764
  777766
  777768
  780331
  781011
  786836
  790708
  791419
  792195
  794072
  794471
  797050
  800175
  801841
  802407
  807588
  810581
  814398
  819808
  824164
]
14.92 ms
(10.02%)
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
  417238
  424720
  429911
  424284
  438296
  445355
  819808
  814398
  824164
  446525
  457328
  469492
  475148
  479918
  488744
  452290
  452688
  454030
  455540
  459210
  459755
  450656
  455976
  459138
  459645
  463701
  468112
  470990
  480835
  486808
  497125
  501367
  537164
  526887
  506707
  461318
  577281
  583795
  563682
  652757
  670189
  688166
  695444
  710173
  651690
  660032
  687535
  705201
  706077
  723239
  660454
  663747
  667427
  668097
  676205
  545046
  554680
  558725
  576167
  626659
  628602
  600690
  628591
  640937
  596450
  629660
  619570
  626041
  777766
  786836
  800175
  801841
  802407
  777751
  777757
  777764
  777768
  781011
  790708
  792195
  810581
  765194
  791419
  794471
  728094
  732525
  724086
  767651
  739821
  745269
  748282
  753621
  734708
  739802
  749930
  765636
  615494
  618760
  709620
  777761
  780331
  794072
  797050
  807588
  407176
  464780
  473315
  475777
  475818
  464068
  398686
  427655
  436900
  438984
  455182
  455488
  459354
  459887
  465232
  390257
]
2.72 ms
(1.83%)
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
  390257
  398686
  407176
  417238
  424284
  424720
  427655
  429911
  436900
  438296
  438984
  445355
  446525
  450656
  452290
  452688
  454030
  455182
  455488
  455540
  455976
  457328
  459138
  459210
  459354
  459645
  459755
  459887
  461318
  463701
  464068
  464780
  465232
  468112
  469492
  470990
  473315
  475148
  475777
  475818
  479918
  480835
  486808
  488744
  497125
  501367
  506707
  526887
  537164
  545046
  554680
  558725
  563682
  576167
  577281
  583795
  596450
  600690
  615494
  618760
  619570
  626041
  626659
  628591
  628602
  629660
  640937
  651690
  652757
  660032
  660454
  663747
  667427
  668097
  670189
  676205
  687535
  688166
  695444
  705201
  706077
  709620
  710173
  723239
  724086
  728094
  732525
  734708
  739802
  739821
  745269
  748282
  749930
  753621
  765194
  765636
  767651
  777751
  777757
  777761
  777764
  777766
  777768
  780331
  781011
  786836
  790708
  791419
  792195
  794072
  794471
  797050
  800175
  801841
  802407
  807588
  810581
  814398
  819808
  824164
]
2.13 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "gorgeous wife"
]
1.88 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "шикарная жен"
]
1.70 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "шикарная жен"
]
1.65 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.