Query Metrics
7
Database Queries
7
Different statements
240.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.34 ms (87.78%) |
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 367962 393298 401981 411121 412702 413004 413090 416415 420320 424417 426547 427467 428138 432886 435930 439568 439593 439635 439636 439657 439660 439671 439717 439721 440979 447475 450847 454137 455922 456584 457396 458311 458312 458703 459406 460918 461394 462101 462107 464013 466143 466310 467497 469885 470768 471449 472695 473139 473229 473431 474113 474780 474788 474795 475192 475885 475951 476208 476249 476330 477366 478620 479115 481124 482824 483362 485485 485619 490394 491153 492062 492645 495060 496397 504692 505242 506529 510775 513131 519860 520895 520899 521239 522690 523171 524513 525263 525849 526737 526948 535015 544489 547836 549776 559063 560825 563616 565700 571754 576859 581618 583622 587311 590405 603488 603622 617638 621463 622839 627730 668525 715234 717189 726837 726981 760619 788949 806722 808691 809880 ] |
||||||||||||||||||||||||||||||
|
20.43 ms (8.49%) |
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 474780 367962 401981 428138 454137 473229 475885 477366 478620 439717 526737 492645 519860 483362 485619 459406 526948 525263 521239 583622 668525 587311 621463 603622 439657 455922 462101 466310 469885 473139 450847 482824 416415 475951 523171 524513 576859 590405 522690 393298 411121 435930 439636 424417 447475 456584 464013 457396 472695 476330 490394 513131 504692 475192 549776 559063 544489 581618 717189 715234 617638 806722 788949 760619 808691 726837 726981 809880 412702 470768 481124 413004 413090 439593 439635 439721 440979 458311 458312 461394 473431 474795 476208 460918 471449 474113 479115 439568 439660 462107 466143 467497 474788 476249 520895 520899 485485 492062 491153 510775 571754 622839 603488 627730 525849 535015 426547 427467 432886 420320 439671 458703 495060 496397 505242 506529 547836 565700 560825 563616 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (0.94%) |
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 367962 393298 401981 411121 412702 413004 413090 416415 420320 424417 426547 427467 428138 432886 435930 439568 439593 439635 439636 439657 439660 439671 439717 439721 440979 447475 450847 454137 455922 456584 457396 458311 458312 458703 459406 460918 461394 462101 462107 464013 466143 466310 467497 469885 470768 471449 472695 473139 473229 473431 474113 474780 474788 474795 475192 475885 475951 476208 476249 476330 477366 478620 479115 481124 482824 483362 485485 485619 490394 491153 492062 492645 495060 496397 504692 505242 506529 510775 513131 519860 520895 520899 521239 522690 523171 524513 525263 525849 526737 526948 535015 544489 547836 549776 559063 560825 563616 565700 571754 576859 581618 583622 587311 590405 603488 603622 617638 621463 622839 627730 668525 715234 717189 726837 726981 760619 788949 806722 808691 809880 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old young webcam"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.66%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old young вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old young вебкамер"
]
|
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.