Query Metrics
7
Database Queries
7
Different statements
159.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.18 ms (82.97%) |
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 188062 387055 390924 397483 398484 402876 411237 411540 411623 411627 411630 411956 419145 428500 442634 447837 450165 453121 453628 454186 454227 454228 455910 456687 459826 462084 462085 462256 462701 463171 463803 464138 466552 466908 466971 467035 468127 469292 470016 472151 472413 472418 472421 472655 474116 474382 474395 474820 474833 474859 474878 475220 476257 476260 479766 479771 482188 483142 485704 485706 485714 485727 485740 485744 485754 485764 486494 487927 496524 498228 498697 500459 502030 511338 514331 515061 518857 519143 519144 519154 522477 523367 523556 525503 525510 529575 531531 538064 548067 548235 549222 550648 550656 552058 554796 559328 565931 567339 589658 592951 624787 637743 666811 667320 667486 712835 715554 728163 768418 771336 771340 771342 774318 800724 817594 818717 825379 826342 826782 827164 ] |
||||||||||||||||||||||||||||||
|
17.94 ms (11.26%) |
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 398484 479766 462084 554796 456687 531531 715554 482188 519144 523367 485740 589658 470016 485764 462085 459826 462256 447837 511338 523556 472418 474382 485706 525510 825379 454227 454228 466971 567339 442634 462701 474116 483142 485744 487927 498228 466908 479771 411540 518857 826782 728163 387055 475220 559328 818717 428500 474395 515061 525503 498697 474833 472421 552058 397483 468127 548235 474878 549222 188062 485704 485754 454186 419145 817594 450165 522477 548067 771340 411630 514331 411623 453628 667320 411956 827164 486494 474820 402876 666811 411627 472151 500459 496524 463171 411237 464138 469292 472413 485714 800724 485727 529575 550656 768418 474859 538064 550648 624787 390924 466552 771336 463803 771342 453121 476260 565931 519154 502030 592951 467035 455910 826342 774318 712835 519143 637743 472655 667486 476257 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.56%) |
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 188062 387055 390924 397483 398484 402876 411237 411540 411623 411627 411630 411956 419145 428500 442634 447837 450165 453121 453628 454186 454227 454228 455910 456687 459826 462084 462085 462256 462701 463171 463803 464138 466552 466908 466971 467035 468127 469292 470016 472151 472413 472418 472421 472655 474116 474382 474395 474820 474833 474859 474878 475220 476257 476260 479766 479771 482188 483142 485704 485706 485714 485727 485740 485744 485754 485764 486494 487927 496524 498228 498697 500459 502030 511338 514331 515061 518857 519143 519144 519154 522477 523367 523556 525503 525510 529575 531531 538064 548067 548235 549222 550648 550656 552058 554796 559328 565931 567339 589658 592951 624787 637743 666811 667320 667486 712835 715554 728163 768418 771336 771340 771342 774318 800724 817594 818717 825379 826342 826782 827164 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"granny blow job"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"granny минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"granny минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.95%) |
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.