Query Metrics
7
Database Queries
7
Different statements
197.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.37 ms (88.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 419628 422365 435356 444262 446929 453920 457372 459944 461904 462057 464563 468658 468965 469833 471020 478547 481401 481465 482437 483725 483726 483767 483776 485254 485847 486010 486014 488242 488467 489301 489330 491599 492488 492958 493443 493980 494600 495122 498837 499000 505937 511453 517400 517882 518926 521184 524029 524138 524859 541892 542784 547790 560435 563551 563710 564490 571696 573354 577132 578731 578766 583335 589672 591929 591957 592304 595231 595601 607717 613690 613782 615984 616472 619312 625121 628625 628714 666033 674916 697196 707440 707467 715935 720187 727434 728255 728716 729181 730936 737922 739778 746101 752719 752826 756245 769465 796563 803625 807842 809784 824634 824892 ] |
||||||||||||||||||||||||||||||
|
11.86 ms (6.02%) |
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 803625 483776 488467 824634 482437 453920 486014 517400 563710 715935 628625 595231 809784 707467 483767 499000 483725 469833 462057 564490 578766 674916 578731 592304 613690 796563 727434 730936 728716 613782 720187 505937 498837 824892 471020 485254 488242 524138 486010 541892 666033 591957 752719 752826 728255 619312 464563 492488 521184 478547 563551 707440 697196 595601 589672 625121 628714 807842 756245 769465 729181 739778 422365 444262 517882 518926 483726 494600 495122 511453 542784 573354 457372 468658 446929 485847 492958 493443 491599 560435 615984 746101 737922 481465 435356 524859 493980 547790 577132 591929 607717 616472 481401 489301 571696 459944 461904 489330 583335 524029 468965 419628 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.42%) |
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 419628 422365 435356 444262 446929 453920 457372 459944 461904 462057 464563 468658 468965 469833 471020 478547 481401 481465 482437 483725 483726 483767 483776 485254 485847 486010 486014 488242 488467 489301 489330 491599 492488 492958 493443 493980 494600 495122 498837 499000 505937 511453 517400 517882 518926 521184 524029 524138 524859 541892 542784 547790 560435 563551 563710 564490 571696 573354 577132 578731 578766 583335 589672 591929 591957 592304 595231 595601 607717 613690 613782 615984 616472 619312 625121 628625 628714 666033 674916 697196 707440 707467 715935 720187 727434 728255 728716 729181 730936 737922 739778 746101 752719 752826 756245 769465 796563 803625 807842 809784 824634 824892 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam pregnant"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер беремен"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.73%) |
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.