GET https://search.jues.net/search/embeds/4?q=latina%20amateur

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.53 ms
(88.62%)
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
  31218
  107060
  387908
  390575
  390839
  396079
  397179
  398002
  398516
  402816
  411834
  413963
  441829
  448643
  450656
  461302
  472907
  480624
  500949
  509353
  512695
  513855
  514177
  514183
  522430
  526387
  536852
  540923
  542605
  549472
  559169
  577448
  579302
  580408
  583357
  585808
  591559
  600699
  603021
  609854
  610244
  618859
  625765
  627280
  629519
  630434
  630995
  638184
  642617
  644102
  656581
  658099
  671569
  677289
  680258
  680751
  680756
  683078
  683106
  685638
  686319
  698099
  699450
  701617
  703422
  703604
  707547
  707758
  709504
  709835
  710583
  710910
  711270
  711662
  712081
  715987
  717285
  718938
  719861
  720304
  721896
  722086
  727555
  734175
  737491
  741115
  747851
  749719
  750768
  750916
  753099
  753173
  757522
  759373
  767381
  770731
  773723
  773730
  781613
  784077
  787593
  788968
  794336
  794356
  794508
  796694
  797325
  799766
  800270
  806495
  806706
  811468
  812000
  812799
  812845
  812853
  813062
  813270
  813580
  814471
]
10.87 ms
(6.53%)
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
  450656
  642617
  514183
  536852
  577448
  683078
  703422
  683106
  710583
  656581
  677289
  686319
  591559
  600699
  638184
  603021
  630995
  784077
  812845
  698099
  709835
  712081
  703604
  630434
  767381
  753099
  402816
  709504
  720304
  770731
  711270
  814471
  813580
  512695
  514177
  542605
  717285
  718938
  585808
  794508
  797325
  806706
  812853
  788968
  811468
  750768
  773730
  794356
  737491
  759373
  753173
  719861
  796694
  799766
  806495
  107060
  31218
  387908
  411834
  540923
  448643
  472907
  580408
  609854
  397179
  441829
  500949
  509353
  711662
  625765
  583357
  658099
  671569
  707758
  522430
  549472
  707547
  680258
  680751
  680756
  710910
  701617
  629519
  610244
  644102
  627280
  699450
  579302
  721896
  618859
  480624
  461302
  685638
  715987
  390575
  390839
  396079
  398002
  398516
  413963
  513855
  526387
  559169
  722086
  794336
  734175
  781613
  787593
  800270
  812799
  813062
  757522
  773723
  727555
  747851
  750916
  741115
  749719
  812000
  813270
]
2.11 ms
(1.27%)
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
  31218
  107060
  387908
  390575
  390839
  396079
  397179
  398002
  398516
  402816
  411834
  413963
  441829
  448643
  450656
  461302
  472907
  480624
  500949
  509353
  512695
  513855
  514177
  514183
  522430
  526387
  536852
  540923
  542605
  549472
  559169
  577448
  579302
  580408
  583357
  585808
  591559
  600699
  603021
  609854
  610244
  618859
  625765
  627280
  629519
  630434
  630995
  638184
  642617
  644102
  656581
  658099
  671569
  677289
  680258
  680751
  680756
  683078
  683106
  685638
  686319
  698099
  699450
  701617
  703422
  703604
  707547
  707758
  709504
  709835
  710583
  710910
  711270
  711662
  712081
  715987
  717285
  718938
  719861
  720304
  721896
  722086
  727555
  734175
  737491
  741115
  747851
  749719
  750768
  750916
  753099
  753173
  757522
  759373
  767381
  770731
  773723
  773730
  781613
  784077
  787593
  788968
  794336
  794356
  794508
  796694
  797325
  799766
  800270
  806495
  806706
  811468
  812000
  812799
  812845
  812853
  813062
  813270
  813580
  814471
]
1.86 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "latina amateur"
]
1.54 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.41 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "латинская любительск"
]
1.15 ms
(0.69%)
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.