GET https://search.jues.net/search/embeds/5?q=touch%20in%20public

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.86 ms
(53.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "touch in public"
]
154.62 ms
(39.29%)
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
  387709
  406695
  414009
  417722
  429266
  439652
  453638
  456955
  459346
  476441
  486601
  486659
  487946
  488240
  489431
  489787
  492208
  493160
  495275
  496354
  505963
  509548
  510609
  516742
  517480
  517580
  523592
  523813
  525892
  525971
  526360
  527822
  528141
  528447
  529185
  529454
  530312
  532152
  533628
  537224
  539106
  539942
  541150
  541284
  542533
  544305
  545028
  546149
  546419
  548547
  549521
  551038
  551831
  551921
  551960
  552051
  552280
  553079
  554260
  555313
  555434
  555502
  555698
  555942
  557467
  558234
  559200
  559242
  560083
  561252
  562037
  562118
  562836
  564935
  565126
  568177
  570843
  572290
  572291
  576137
  576725
  577620
  578060
  578118
  578161
  578961
  579516
  579764
  580958
  581188
  584736
  585666
  589568
  589775
  590499
  596014
  596599
  598186
  598515
  601159
  603704
  604941
  605396
  606890
  609221
  612065
  614325
  615587
  617770
  618952
  619734
  623973
  626145
  635697
  649362
  651269
  657817
  663374
  677106
  678481
]
19.12 ms
(4.86%)
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
  617770
  456955
  486601
  489431
  525892
  529185
  579764
  577620
  551921
  603704
  598186
  489787
  596014
  387709
  429266
  476441
  486659
  505963
  533628
  539106
  523592
  541284
  545028
  548547
  559200
  560083
  565126
  578060
  578118
  541150
  549521
  555313
  555698
  584736
  649362
  651269
  677106
  551831
  555942
  557467
  564935
  590499
  589568
  589775
  619734
  453638
  417722
  493160
  562037
  572290
  609221
  529454
  585666
  559242
  579516
  581188
  552280
  578961
  523813
  487946
  406695
  496354
  517480
  562118
  561252
  618952
  623973
  612065
  528447
  542533
  525971
  527822
  539942
  509548
  517580
  528141
  544305
  578161
  555434
  555502
  572291
  576137
  663374
  546149
  554260
  626145
  614325
  598515
  604941
  606890
  635697
  562836
  552051
  530312
  532152
  678481
  596599
  414009
  526360
  537224
  510609
  516742
  546419
  551960
  558234
  553079
  657817
  551038
  576725
  615587
  601159
  605396
  439652
  492208
  568177
  580958
  495275
  570843
  459346
  488240
]
2.98 ms
(0.76%)
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
  387709
  406695
  414009
  417722
  429266
  439652
  453638
  456955
  459346
  476441
  486601
  486659
  487946
  488240
  489431
  489787
  492208
  493160
  495275
  496354
  505963
  509548
  510609
  516742
  517480
  517580
  523592
  523813
  525892
  525971
  526360
  527822
  528141
  528447
  529185
  529454
  530312
  532152
  533628
  537224
  539106
  539942
  541150
  541284
  542533
  544305
  545028
  546149
  546419
  548547
  549521
  551038
  551831
  551921
  551960
  552051
  552280
  553079
  554260
  555313
  555434
  555502
  555698
  555942
  557467
  558234
  559200
  559242
  560083
  561252
  562037
  562118
  562836
  564935
  565126
  568177
  570843
  572290
  572291
  576137
  576725
  577620
  578060
  578118
  578161
  578961
  579516
  579764
  580958
  581188
  584736
  585666
  589568
  589775
  590499
  596014
  596599
  598186
  598515
  601159
  603704
  604941
  605396
  606890
  609221
  612065
  614325
  615587
  617770
  618952
  619734
  623973
  626145
  635697
  649362
  651269
  657817
  663374
  677106
  678481
]
1.89 ms
(0.48%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "трога на улиц"
]
1.49 ms
(0.38%)
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.