GET https://search.jues.net/search/embeds/7?q=beautiful%20mature

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
213.44 ms
(52.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "красивая mature"
]
164.42 ms
(40.44%)
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
  124144
  188379
  238809
  249637
  381946
  395661
  399688
  400138
  400169
  400195
  401185
  401318
  401615
  403464
  405490
  407458
  411394
  411828
  413478
  413783
  414029
  419527
  423653
  423917
  435676
  440979
  443168
  443695
  443734
  443946
  451451
  452034
  453074
  453681
  454143
  455048
  460190
  463925
  464157
  464445
  464460
  465500
  466840
  467410
  468199
  469272
  471407
  471814
  473177
  473806
  474022
  476330
  476331
  477210
  477957
  478928
  479803
  480397
  480834
  482780
  483365
  484519
  484768
  485125
  486449
  486834
  488619
  490138
  490910
  491440
  492472
  493898
  496540
  498501
  502843
  511828
  512873
  513149
  513964
  515122
  515276
  516003
  516656
  516838
  517000
  517008
  517490
  517861
  518753
  519233
  519358
  519368
  519844
  520021
  522364
  524944
  524952
  531066
  531184
  531219
  531228
  531523
  532170
  532266
  533957
  534244
  534636
  536347
  536357
  538005
  538913
  562907
  606455
  617152
  673791
  685864
  732243
  792533
  801240
  807383
]
19.13 ms
(4.70%)
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
  517000
  238809
  188379
  400169
  401615
  405490
  413783
  423653
  463925
  485125
  486449
  486834
  453681
  464460
  468199
  473806
  479803
  483365
  455048
  467410
  476330
  482780
  488619
  517861
  531219
  532266
  536347
  496540
  513964
  517490
  519844
  522364
  531523
  536357
  538913
  498501
  512873
  516838
  531184
  531228
  532170
  534636
  469272
  473177
  474022
  480834
  493898
  562907
  673791
  685864
  606455
  617152
  801240
  807383
  732243
  792533
  124144
  395661
  407458
  411828
  443168
  451451
  460190
  464157
  476331
  477957
  381946
  399688
  400138
  403464
  411394
  414029
  419527
  440979
  443695
  443946
  454143
  471407
  249637
  400195
  401185
  413478
  423917
  453074
  466840
  465500
  480397
  435676
  443734
  471814
  478928
  511828
  516656
  519233
  519358
  519368
  538005
  490910
  513149
  518753
  520021
  524944
  484768
  502843
  515276
  516003
  531066
  490138
  491440
  534244
  477210
  515122
  401318
  464445
  492472
  517008
  524952
  484519
  533957
  452034
]
3.53 ms
(0.87%)
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
  124144
  188379
  238809
  249637
  381946
  395661
  399688
  400138
  400169
  400195
  401185
  401318
  401615
  403464
  405490
  407458
  411394
  411828
  413478
  413783
  414029
  419527
  423653
  423917
  435676
  440979
  443168
  443695
  443734
  443946
  451451
  452034
  453074
  453681
  454143
  455048
  460190
  463925
  464157
  464445
  464460
  465500
  466840
  467410
  468199
  469272
  471407
  471814
  473177
  473806
  474022
  476330
  476331
  477210
  477957
  478928
  479803
  480397
  480834
  482780
  483365
  484519
  484768
  485125
  486449
  486834
  488619
  490138
  490910
  491440
  492472
  493898
  496540
  498501
  502843
  511828
  512873
  513149
  513964
  515122
  515276
  516003
  516656
  516838
  517000
  517008
  517490
  517861
  518753
  519233
  519358
  519368
  519844
  520021
  522364
  524944
  524952
  531066
  531184
  531219
  531228
  531523
  532170
  532266
  533957
  534244
  534636
  536347
  536357
  538005
  538913
  562907
  606455
  617152
  673791
  685864
  732243
  792533
  801240
  807383
]
2.35 ms
(0.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful mature"
]
1.91 ms
(0.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая mature"
]

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.